Hyperion Planning (MOSC)

MOSC Banner

Business rule Tuning

edited Jan 7, 2016 11:43PM in Hyperion Planning (MOSC) 7 commentsAnswered ✓

Hi ,

Need a help on tuning the below script as this take around 2 hours to execute.Did atmost all the workaround but no luck

---------------------------------------------------------------------------------------

//ESS_LOCALE English_UnitedStates.Latin1@Binary

/* Start Template:SET commands*/

SET UPDATECALC OFF ;

SET AGGMISSG ON;

SET CALCPARALLEL 3;

SET CALCTASKDIMS 2;

/* End Template:SET commands*/

/* Clear */

FIX(

    "Actual"

    ,"FY15"

    ,"P01"

    ,"Value"

    ,@RELATIVE("Profit & Loss",0)

    ,"Co_0052"

    ,@relative("All Profit Centres",0)

    ,@RELATIVE("SessionYear",0)

    ,@RELATIVE("Activity",0)

    ,@RELATIVE("Product",0)

    ,@RELATIVE("SalesType",0)

    ,"LocalCurrency"

)

/* subledgers are not integrated so not needed */

    "ActualVersion" ==  @sum("GL_Primary" ,"GL_Adjustment");

/* "ActualVersion"  = "GL_Primary"  + "GL_Adjustment";*/

ENDFIX;

-----------------------------------------------------------

Database dimension details

* I brought Activity below Year dimension to desing the hourglass model but that was taking more than 2 hours.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center