Need help: Dimensional column has assoc with more than 1 level
726765Oct 13 2009 — edited Oct 14 2009Hi,
I am trying to have multiple drill paths for a single dimension. For example, the Date dimension should be navigable by the following hierarchies:
DateDimension
+---- Calendar Year
......---- Calendar Quarter
............--- Calendar Month
..................-- Day
+---- Calendar Year
......---- Day
So, in other words, in Answers I should be able to add 'Calendar Year' to my report, display results, and then click down the path Calendar Year -> Calendar Quarter -> Calendar Month -> Day OR Calendar Year -> Day.
However, when I model this in the Admin tool, it allows it, but then I add the column in Answers and get a runtime error:
+[nQSError: 14064] Dimensional column [column name] has associations with more than one level+
This is possible in BO and other tools. If it is not possible in Oracle BI EE, then one alternative would be to have two separate versions of 'Calendar Year' added to the report in Answers, each with their own drill path.
Any ideas???
Thanks for any help you can provide.
Matt Warden
Balanced Insight, Inc.