dbTalk Databases Forums  

OLAP 2005 problem - please help!!!

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


Discuss OLAP 2005 problem - please help!!! in the microsoft.public.sqlserver.olap forum.



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

Default OLAP 2005 problem - please help!!! - 05-09-2006 , 07:08 AM






Hello All,

I have urgent problem with my cube: he shows empty data when I query it.
There is data in underlying table in SQL, But something happen or during the
process or during querying.
Somebody has any idea????
Please help
Thanks in advance
Inna




Reply With Quote
  #2  
Old   
Designing-Systems.com
 
Posts: n/a

Default RE: OLAP 2005 problem - please help!!! - 05-10-2006 , 02:38 PM






hi,

Either your cube is not correctly built or the query is faulty. Try browsing
your cube in Business Intelligence Studio or Server Mansgement Studio. If you
can get data there, then your query is at fault. Otherwise you need to rework
your cube.

Regards,

--------------------------------
http://www.Designing-Systems.com
Email. Support (AT) Designing-Systems (DOT) com
-------------------------------------------------

"Inna" wrote:

Quote:
Hello All,

I have urgent problem with my cube: he shows empty data when I query it.
There is data in underlying table in SQL, But something happen or during the
process or during querying.
Somebody has any idea????
Please help
Thanks in advance
Inna





Reply With Quote
  #3  
Old   
Inna
 
Posts: n/a

Default Re: OLAP 2005 problem - please help!!! - 05-13-2006 , 09:57 AM



Hello,
Thank you for your answer.
I already realized I can see data in Business Intelligence Studio and Server
Management Studio.
But I see only lowest level. And no totals. I'm speaking about time
dimension now. So when I neutralize ignore empty cells options on both of
this browsers I can drill down to lowest - day level. And then data appear.
Otherwise everythings is empty. IgnoreUnrelatedDimensions is set to true.
Dimension property IsAggregatable is set to true.
What could be wrong with my cube? I'm really stuck there and very much need
help.
Thanks in advance
Inna




"Designing-Systems.com" <Support (AT) Designing-Systems (DOT) com> wrote

Quote:
hi,

Either your cube is not correctly built or the query is faulty. Try
browsing
your cube in Business Intelligence Studio or Server Mansgement Studio. If
you
can get data there, then your query is at fault. Otherwise you need to
rework
your cube.

Regards,

--------------------------------
http://www.Designing-Systems.com
Email. Support (AT) Designing-Systems (DOT) com
-------------------------------------------------

"Inna" wrote:

Hello All,

I have urgent problem with my cube: he shows empty data when I query it.
There is data in underlying table in SQL, But something happen or during
the
process or during querying.
Somebody has any idea????
Please help
Thanks in advance
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.