1 Reply Latest reply on Feb 22, 2016 1:08 PM by patrick.byrne.0

    Comparing Actual vs Plan from Cube

    Pouger Ann

      Have been trying to compare Plan vs Actual from an ESSBASE CUBE that is being updated in real time by business users.

      I have a dimension named SCENARIO which has "Actual" and "Plan" and a measure of "Net Profit" across Dimension(s) "Periods", "Companies", etc.

       

      For Example

       

      Tried Several Options:

      1) Created TWO Data-Sources  --- (But will not let me join TWO CUBES)

      2) Created Calculated Fields --- Net Profit(Actual) --->  IIF([Dimension SCENARIO]='Actual',[Net Profit],0)   --- Will not let me address Dimension in Calculated Field when using CUBE.

                                                   Net Profit(Plan) --->  IIF([Dimension SCENARIO]='Plan',[Net Profit],0)   --- Will not let me address Dimension in Calculated Field when using CUBE.

      3) Created two Sheets (Actual and Plan) --- Could not Lookup() another Sheet

       

      Thanks for any suggestions.

       

      Phil Fremon