dbTalk Databases Forums  

create local/global cube with parent child dimension

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


Discuss create local/global cube with parent child dimension in the microsoft.public.sqlserver.olap forum.



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

Default create local/global cube with parent child dimension - 06-07-2004 , 02:56 AM






Hello

I will create local cube files with a parent child dimension.
CREATE global CUBE [Budget]
STORAGE 'c:\Budget.cub' FROM [Budget]
(MEASURE [Budget].[Amount], DIMENSION [Budget].[Account],
DIMENSION [Budget].[Category], DIMENSION [Budget].[Store],
DIMENSION [Budget].[Time]

When I make as Select on the cube File
select
Account.members on columns,
category.members on row
from budge
I can see, that there are not all values available. Many values show
the value #ERR (Doubleclick on #Err shows the message
"Unable do display cell Properties. Cube Salse is not available..."
But the cube Sales is never referenced by the cube Budge

What's wrong? Is it a problem with the parent child dimensio
Account

Advice plesase

Thanks in advance
Michael

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.