Skip to Content

EPM Input template

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 17 at 11:23 PM

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

    Add comment
    10|10000 characters needed 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

  • Jan 19 at 02:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 03:24 PM

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

    Add comment
    10|10000 characters needed characters exceeded