dbTalk Databases Forums  

Shared Dimension

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


Discuss Shared Dimension in the microsoft.public.sqlserver.olap forum.



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

Default Shared Dimension - 03-09-2005 , 09:21 AM






Hi All,

This might sound like a newbie question but please bare with me. We have a
cube that has dimensions that are specific to the cube and then shared
dimensions. The cube is set to process automatically via a DTS package,
however when the cube processes, it only processed the dimensions that are
specific to the cube and none of the shared dimensions. Why is this, I have
checked the cube package in DTS and made sure everything is set to Full
process.

Please help!!!

Thanks
K




Reply With Quote
  #2  
Old   
Ohjoo Kwon
 
Posts: n/a

Default Re: Shared Dimension - 03-09-2005 , 10:54 AM






If you modify the definition of the shared dimension and process the cube,
it involves reprocessing the dimensions before cube processing. But if not
and only some records are updated or added to the dimension tables, you have
to reprocess them separately with proper options before cube processing.

Ohjoo Kwon


"Kathy" <roo (AT) roo (DOT) com> wrote

Quote:
Hi All,

This might sound like a newbie question but please bare with me. We have a
cube that has dimensions that are specific to the cube and then shared
dimensions. The cube is set to process automatically via a DTS package,
however when the cube processes, it only processed the dimensions that are
specific to the cube and none of the shared dimensions. Why is this, I
have
checked the cube package in DTS and made sure everything is set to Full
process.

Please help!!!

Thanks
K






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

Default Re: Shared Dimension - 03-10-2005 , 02:29 AM



Thank you so much - I suspected something along those lines

"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote

Quote:
If you modify the definition of the shared dimension and process the cube,
it involves reprocessing the dimensions before cube processing. But if not
and only some records are updated or added to the dimension tables, you
have
to reprocess them separately with proper options before cube processing.

Ohjoo Kwon


"Kathy" <roo (AT) roo (DOT) com> wrote in message
news:xsadncxOc6fGibLfRVn-tw (AT) is (DOT) co.za...
Hi All,

This might sound like a newbie question but please bare with me. We have
a
cube that has dimensions that are specific to the cube and then shared
dimensions. The cube is set to process automatically via a DTS package,
however when the cube processes, it only processed the dimensions that
are
specific to the cube and none of the shared dimensions. Why is this, I
have
checked the cube package in DTS and made sure everything is set to Full
process.

Please help!!!

Thanks
K








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.