SSAS cube data problem - help needed!This is a discussion on SSAS cube data problem - help needed! within the data.oledb.olap forums in Data Warehousing category; I didn't do anything special, just add some calculations/named sets, processed the cube, then when I tried to browse it with the cube browser, all data available in meta-data pane, yet if I drag a measure into the OWC pane, only the measure name displayed with a blank row below it. Dimension hierarchy shows only a All on both column list and row list. I've tried MDX query in SSMS and resulted the same: no measure data and All for any dimension hierarchies. I don't understand this situation, please, any advice on this?... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
02-04-2008, 02:59 PM
|
 SSAS cube data problem - help needed! I didn't do anything special, just add some calculations/named sets, processed the cube, then when I tried to browse it with the cube browser, all data available in meta-data pane, yet if I drag a measure into the OWC pane, only the measure name displayed with a blank row below it. Dimension hierarchy shows only a "All" on both column list and row list. I've tried MDX query in SSMS and resulted the same: no measure data and "All" for any dimension hierarchies. I don't understand this situation, please, any advice on this?  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 09:23 AM.
