Report Portal

MDX-When I process cube, I can see that data is loaded, but when I query data, all measures are empty

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:

CALCULATE;

// rest of your calculations should be below

 

 

Tags: mdx, faq, process

 

2007-2015 VidasSoft Systems Inc.