Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Dimension is showing as blank

Author  Topic 

thussain
Starting Member

7 Posts

Posted - 2005-07-13 : 18:39:04
I created a cube that have only one dimension Employee name and measure has a colmn name Amount.
My amount measure is keep ccoming blank even there are some employee who have data beside the null.
Also the Total for all Employees also coming Blank.

What I need to do to fix it.
Please help


Thanks
Tanweer

thussain
Starting Member

7 Posts

Posted - 2005-07-13 : 18:40:01
ooops Imean Measure are showing blank ion the cube editor data window
Go to Top of Page

thussain
Starting Member

7 Posts

Posted - 2005-07-13 : 19:29:23
ooops Imean Measure are showing blank ion the cube editor data window
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-07-13 : 20:40:11
Double check the Joins between fact table and dimension table(s) in the cube editor.

rockmoose
Go to Top of Page
   

- Advertisement -