dbTalk Databases Forums  

Time dimension with multiple role-playing dimensions issue

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


Discuss Time dimension with multiple role-playing dimensions issue in the microsoft.public.sqlserver.olap forum.



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

Default Time dimension with multiple role-playing dimensions issue - 05-01-2006 , 09:38 AM






This is to follow up the previous question I posted regarding role-playing
dimension issue, and I would like to provide more details to see if anyone
knows or have seen the similar problems.

I created a time dimension (with dimension type = Time) with some other
small dimensons in a OLAP database. The time dimension has two user
hierarchies:
Year - Quarter - Month - Date and Year - Week - Date with relationship
defined between each levels. Then I derived two role-playing date dimensions
from the time dimension in my cube. When I browsed cube, the year level has
no data although anylevel under year has values.

To further investigate the root cause, I changed the time dimension to
regular type, then it worked fine. Another workaround I found is to remove
the year relationship from the week level (keep the dimension type as time).
Maybe OLAP is confused by the mutiple relationship of year to both week and
quarter in my case?

I wonder if there are any known issues regarding time-type dimension with
multiple hierarchies and multiple role-playing combinations

Thanks in advance.

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.