Hi guys,
fist of all I want to state my versions I am using for the upcoming scenario / question:
OBIEE: Version 12.2.1.1.0
OBI Administration Tool: Version 12.2.1.1.0
Oracle Essbase: Version 11.1.2.4.008.28
My scenario is as follows:
We have created an alternate hierarchy within our time dimension within Essbase using BSO which consists of the following generations:
+ TIME
+ CALENDAR
+ Year
+ Half-Year
+ Quarter
+ Month
Day
+ ISO_CALENDAR
+ ISO_Year
+ ISO_Week
+ Day (Shared member)
Our level zero generation is used to connect both hierarchies using "shared member" on the day level.
When trying to import this BSO cube to the physical layer within the BI Administration tool it only shows me one part of the total time dimension including all seven generations of the TIME.CALENDER part:
I am also not able to see any second time hierarchy within to physical layer to use the build-in functionality of "Convert to multi-hierarchy view" (https://docs.oracle.com/middleware/12211/biee/BIEMG/GUID-6D187B8C-EFBD-412E-88F6-22B02C424798.htm#essbase_alt_hier ):
When trying to import an Essbase cube which is ASO-model it works without any problems and I have the option to convert the time dimension to single- and multi-hierarchy view:
Does anyone know what might be the problem or what I missed to achieve Oracle BI to show my BSO-model also with an alternate hierarchy?
Best regards and thanks in advance
Carsten
