| MDX-When I process cube, I can see that data is loaded, but when I query data, all measures are empty |
| Written by Vidas Matelis | |||
| Thursday, 06 December 2007 19:47 | |||
|
Q: When I process cube, I can see that data is loaded, but when I query data, all measures are empty. When I remove most of the dimensions and leave just a few, I can see measure values just when all dimensions have selections on any member below "All" level. A: This sounds like a case when in cube MDX script CALCULATE statement is commented out or removed. In cubes MDX statement make sure that first statement is:
|
Most read
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
- MDX-How do you format or round KPI expression value?
- MDX-How do you calculate monthly average of one year, optionally including empty months?
Top Rated
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- Analysis Services 2005 XMLA script to add/drop existing partition aggregate
- Why In Reporting Services MDX query disappears after leaving "Data" tab.
- When accessing calculation tab in BIDS I am getting error Unexpected error occurred
- In an MDX query how can I get the top 3 sales years based on the order quantity?
- What TCP port SQL Server Analysis Services 2005 uses
- How to calculate YTD monthly average and compare it over several years for the same selected month
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
