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. |