dbTalk Databases Forums  

How to make provate dimensions available across partitions ?

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


Discuss How to make provate dimensions available across partitions ? in the microsoft.public.sqlserver.olap forum.



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

Default How to make provate dimensions available across partitions ? - 11-19-2003 , 10:30 PM






I have a cube like the following:

SALES_CUBE
SALES_CUBE partition created from FACT_TABLE_AMERICAS
SALES_CUBE_EUROPE partition created from FACT_TABLE_EUROPE

I have created some private dimentions on the default partition
(SALES_CUBE). These are created FACT_TABLE_AMERICAS as the reference.
How do I make it available to the other partition SALES_CUBE_EUROPE ?

Thanks a lot.

Reply With Quote
  #2  
Old   
mangaraju venuturupalli
 
Posts: n/a

Default Re: How to make provate dimensions available across partitions ? - 11-20-2003 , 09:49 AM






I will try to make my question more elaborate:

The private dimension that I had created with FACT_TABLE_AMERICAS
as the basis, is a dimension called CURRENCY and it has values USD.

But the second fact table has more values for this Currency column
(EUR, GBP etc). So, when I try to process the cube, both the
partitions are being processed against the same set of dimensions
(only USD).

How do I handle this situation ? I need make the entire set of values
(USD, EUR, GBP) available to all the partitions in the cube.

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.