dbTalk Databases Forums  

Empty cells in 2005 Analisys Server cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Empty cells in 2005 Analisys Server cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Inna
 
Posts: n/a

Default Empty cells in 2005 Analisys Server cube - 05-08-2006 , 11:02 AM






Hello All,

I have a question related to Analysis Server 2005:
I don't see any data when I browse the cube. During the process I get SQL
query which Analysis Server run against SQL Server and it shows me select
from fact table which includes 20 million records. No join with any
dimensions table.
When process succeed data is not there. I try to get SQL which includes join
to dimension tables so I could see what is missing, but I failed to find it.
May be I should check some schema optimization or something like that, but I
have no idea where to find the answer.

Please help
Thanks
Inna



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.