EPM Input template

[former_member246680]

Hi all,

I have a lot of dimensions linked to each other in input schedules and my requirement is as follows, I will give examples:

Plan on the following 5 segments: WBS, Cost Center(CC), GL, Functional Area (FA), Fund (FD). In the input template:

Select CC (in context), this should populate all WBS elements linked to that CC in the rows. FA and FD are linked to the WBS, so once a WBS is populated in a row, it should inturn populate FA and FD in the same line. GL for that line should be selected from the hierarchy (from the available GL accounts). Please see picture below

Many thanks

Jordan

[former_member186338]

In general when you select CC then WBS will be defined using EPMDimensionOverride by WBS property matching CC.

FA and FD will be related to WBS property in memberselector.

But I do not understand the logic of GL selection "GL for that line should be selected from the hierarchy" - what do you mean???

[former_member246680]

Hi Vadim,

Thank you, the EPM dimension override works.

"GL for that line should be selected from the hierarchy" - we have a hierarchy for GL and user wants to select it in the input schedule. Is it advisable to use a drop down or some EPM function for this selection in the column for GL? When i i put the input schedule becomes too big

Regards

Jordan

[former_member186338]

Sorry, but any "drop down" can be done only in 100% static report. No way!

You need another property to match WBS with account!

[maleodillet]

Use CopyRange on the Colunms to populate the properties from WBS for the 2 colunms FA, FD and $Anchor$ the CopyRange formula of WBS colunm to the CC cell selection.

[former_member186338]

And what is the issue? You can link member to the property of another member.

[former_member246680]

Hi Vadim,

Its difficult to see it being achievable. If I select CC, WBS will be populated as property of CC in the rows, then FD and FA also need to be populated as properties of WBS. It becomes "property of another property".

Soes this mean for every subsequent dimension I have to select "dimension property" in the relationship?

Regards

Jordan