Thursday, December 27, 2012

SSAS - Cube displays null value while browsing


I am sharing the issues which I have faced in my project and the solution I used ....
Problem:
I have build a cube in SSAS 2008. The cube processes successfully. but when i browse the cube it does not show data.
I check it in DSVFact table--> Explore data --> it displays data. But i cannot see the data when i browse the cube.
Solution:
I found that  "CALCULATE;" command is missing in the starting of the script in the calculaitons tab of the cube.
I have added the the command and saved the solution and processed it, now its displaying the values in the cube...

No comments: