dbTalk Databases Forums  

Dimensions Processing Issue

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


Discuss Dimensions Processing Issue in the microsoft.public.sqlserver.olap forum.



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

Default Dimensions Processing Issue - 05-03-2004 , 02:05 PM






Hello:

I have a shared dimension that is used by three cubes.
This shared dimension also has a vitual dimension built
from it that is used by one of the cubes. When I choose to
incrementally update the dimension and its virtual
dimension in Analysis Manager, the process completes
successfully, but new members are not added to the
dimensions. As a result, the cubes that use these
dimensions fail when processing because there are keys in
the fact table that are not found in the dimensions.

If I choose to "rebuild the dimension structure" in
Analysis Mananger, both dimensions process successfully,
new members are added to the dimensions, and the cubes
process successfully.

My issue is that the dimension and its virtual dimension
are not changing in structure, and should only need a
refresh to add in new members.

Thank you for your help.

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 - 2013, Jelsoft Enterprises Ltd.