Skip to Content
0

EPM Input template

Jan 17 at 10:30 PM

72

avatar image

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

input.png (25.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Jan 17 at 11:23 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Maleo Dillet Jan 19 at 02:39 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 19 at 03:24 PM
0

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???

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

You need another property to match WBS with account!

0