OBIEE Admin Tool 12c: Import Essbase BSO alternate hierarchy

Carsten Weber

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

Christian Berg-0racle

Hi Carsten,

What are the settings for the database object and the connection pool over which you do the import?

I've had some issues which were "resolved" (read: worked around) by changing the Essbase version to 11.1.2.3 instead of .4 in the connection pool.

Carsten Weber

Hi Christian,

we had already set up the version 11.1.2.3.500 within our connection pool:

I also just installed a newer version of Oracle BI Administration Tool (12.2.1.3.0) and I also did not have any success - eventhough Oracle listed this kind of error:

10. Re: OBIEE 12C and Essbase 11.1.2.4 integration issue
3292571 17.07.2018 13:27 (als Antwort auf: 3292571)

As per Oracle SR, Solution is to use OBIEE 12.2.1.3 Admin Tool as OBIEE 12.2.1.4 Admin tool is not certified with imports from Essbase Version 11.1.2.4.X per Per BUG 27376664 and certification Doc ID 1109260.1

Best regards

Carsten

Christian Berg-0racle

Hi Carsten

I pretty much feared you'd get this answer :-(

Robert Angel

Hi Carsten,

Essbase with OBIEE - not what it could / should be - which as a hybrid EPM / OBIEE person disappoints me greatly!

Can you; -

1. back up your cube

2. Keep a copy of your rpd "as is"

3. delete the time hierarchy that is appearing in the DB from Essbase

4. import the cube in OBIEE

5. Copy the original time hierarchy onto your new rpd from your backed up rpd

6. Restore Essbase to your back up

7. Test

I have done this previously and had success;-  though not with your precise version combination  - so no guarantees I fear

Carsten Weber

Hi Robert,

thank you very much for your advice.

I might try this later on. Until now I will just add a new separate dimension within my BSO-cube which stores the data as follows (without using shared member option):

+ ISO_CALENDAR

          + ISO_Year

               + ISO_Week

                    + Day

I know this is not the perfect way of creating a business model but it solves my problems on a quick basis.

Best regards

Carsten