Hyperion Planning (MOSC)

MOSC Banner

Planning: When adding a list of custom dimension members to the calculation it take long time

edited Dec 11, 2017 8:24AM in Hyperion Planning (MOSC) 8 commentsAnswered

Hello,

We have a problem with performance for our rules, when ever we add custom dimension to the calculations, it take longer time:

Ex: this script is taking 1:30 minutes to push down drivers using the Target version:

FIX(

@RELATIVE("YearTotal", 0),&SecondYear,

@REMOVE(@RELATIVE({RBBSP_Entity}, 0), @LIST(@UDA("Entity", "notactive"))),

"Budget","Target",

@REMOVE(@RELATIVE({RBBSP_COA}, 0), @LIST(@UDA("Chart of Account", "notactivecoa"))),

"No Attribute Value","SAR",

"1_ST", "0_CS1", "0_CS2")

"F700" = "YearTotal"->&SecondYear->{RBBSP_Entity}->"Budget"->"Target"->{RBBSP_COA}->"No Attribute Value"->"SAR"->{RBBSP_Strategy}->{RBBSP_Custom1}->{RBBSP_Custom2};

ENDFIX;

But when i define Relative Level0 members of custom1 dimension (

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