Questions about OAC or OBIEE integration with Hyperion PBCS — oracle-tech

    Forum Stats

  • 3,715,959 Users
  • 2,242,917 Discussions
  • 7,845,703 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Questions about OAC or OBIEE integration with Hyperion PBCS

kalikhan
kalikhan Member Posts: 2 Green Ribbon
edited January 11 in Planning and Budgeting

We have two Oracle Cloud Services: OAC and Hyperion PBCS

I was able to import PBCS application metadata in OAC rpd's Subject Area, and am able to create report in OAC.

All the measures (or formulas) are showing up in SCENARIO dimension in OAC report.

I can add simple formula in my OAC report, as 'Calculated Item' of SCENARIO dimension - for example: Actual - Plan

where Actual and Plan are members of SCENARIO dimension.


Now I have two questions:


(1). In OAC/obiee <-> Essbase integration, after we import Essbase cube metadata there is an option to right click on cube (in Physical Layer) and then select 'Convert Measure dimension to flat measures', which then shows all the measures as a separate list. This makes oac/obiee reporting easier as all measures are separate columns. BUT after import of Hyperion PBCS planning metadata, there is no such option in rpd physical layer. All measures are part of SCENARIO dimension, which makes reporting difficult.

Is there a way to move all the measures out of pbcs SCENARIO dimension into a separate flat list in physical layer of rpd? just like we do after Essbase metadata import?


(2). In OAC/obiee <-> Essbase reporting, we can use EVALUATE_AGGR function in OAC report which then gives us the ability to use Essbase MDX syntax in OAC report column formula, if the formula is too complex to do using oac logical sql.

How can we use EVALUATE function of OAC/obiee when working with hyperion PBCS data? I would like to use pbcs Calc functions like @PRIOR to define PY_Actual in my oac report.

Tagged:

Best Answer

  • kalikhan
    kalikhan Member Posts: 2 Green Ribbon
    Accepted Answer

    Oracle Support said that both these things can only be done when working with Essbase source in RPD, but not with Hyperion Planning data source in RPD.

    So every measure that is required in OAC report, now has to be "pushed" into Scenario dimension in PBCS.

    PBCS admin will not be happy that he will have to add so many new members in his pbcs Scenario dimension.

Answers

  • kalikhan
    kalikhan Member Posts: 2 Green Ribbon
    Accepted Answer

    Oracle Support said that both these things can only be done when working with Essbase source in RPD, but not with Hyperion Planning data source in RPD.

    So every measure that is required in OAC report, now has to be "pushed" into Scenario dimension in PBCS.

    PBCS admin will not be happy that he will have to add so many new members in his pbcs Scenario dimension.

Sign In or Register to comment.