Skip to Content
avatar image
Former Member

Dimension Member property

I have a report with a number of Dimensions in the Rows. The 1st dimension however should impact the 2nd by only allowing the display of Members where a property matches the Member shown in the 1st column. I was hoping that the use of EPMMemberOveride will result in the contents of table 1 however it can’t seem to handle using a member derived from the report. What I am currently getting is displayed in table 2. Where the entity is simply replicated giving every possible combination. Basically I can’t have Paris under Entity “GB”. Was considering using a Local member however the placing is restricted so can’t seem to get it displayed right after Entity

Entity Location Currency( local Member)

GB London GBP

GB Manchester GBP

GB Derby GBP

Eur Paris EUR

Eur Dublin EUR

Table 1



Entity Location Currency( local Member)

GB London GBP

GB Manchester GBP

GB Derby GBP

GB Paris EUR

GB Dublin EUR

EUR London GBP

EUR Manchester GBP

EUR Derby GBP

EUR Paris EUR

EUR Dublin EUR

Table 2

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Nov 02, 2017 at 07:40 AM

    You have to select property relationship for the 1st dimension to 2nd dimension.

    For example I have COST_CENTER dimension with a property BPC_COMPANY_CODE. And I have COMPANY_CODE dimension:

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2017 at 12:47 PM

    "Location member when called from the EPMAxisOveride somehow ignores any configuration made in the Relationship Options." - incorrect idea!

    Use EPMDimensionOverride for dimension 2 (City) using property!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2017 at 03:38 PM

    Full sample with a real report:

    COMPANY_CODE dimension is defined by property relationship.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2017 at 10:37 AM

    Hi Vadim,

    Thanks for the sample. To be fair though your test is not definitive as you are over riding with identical paramaters.

    May I impose upon you to try the following.

    1 ) Create a simple report.

    2 ) Perform an Axis Overide.

    3 ) Then by using a "Dimension over ride" or a "relationship selection" get the new Dimension from AXIS overide to be impacted by the property of another dimension

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, but look on my sample once again!

      "To be fair though your test is not definitive as you are over riding with identical paramaters." I am not overriding with identical parameters!

      I am overriding only COST_CENTER dimension using property BPC_COMPANY_CODE containing COMPANY_CODE member related to the particular COST_CENTER member.

      For COMPANY_CODE dimension any override is prohibited, I am setting the relation of this dimension to the property BPC_COMPANY_CODE of the COST_CENTER dimension!

      Don't use axis override!!!!!

  • avatar image
    Former Member
    Nov 02, 2017 at 12:42 PM

    Hi Vadim,

    Thanks for the suggestion. Under normal circumstances it would work I think, however here I'm also using an Axis Overide as the dimensionality of my Schedule changes dynamically.

    I can only assume that my failure to implement your solution is because the Location member when called from the EPMAxisOveride somehow ignores any configuration made in the Relationship Options.

    What do you think?

    L

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2017 at 02:59 PM

    Vadim,

    The reason I'm using AxisOveride is that I have to display dimensions depending on a user selection from a drop down. If "Location" is selected that the Rows includes this dimension. An alternative selection will result in "Location" being replaced by a different dimension

    DimensionOveride however already presumes that the dimension is in the report - effectively allowing only the change of the members.

    AxisOveride does give me the Dimension change I require however looking at the syntax which is

    =EMPAxisOveride("000",TRUE,"LOCATION", LONDON;PARIS;MADRID)

    What I need is something like

    =EMPAxisOveride("000",TRUE,"LOCATION", "Any location with property = ENTITY")

    sorry I meant

    =EMPAxisOveride("000",TRUE,"LOCATION", "Any location with property = ENTITY.ID")

    where Entity.id is the id of the entity dimension

    This way, when Entity is shown in the 1st column, only locations related to it will be shown in the "Locations" column adjacent to it

    Lucy ( really appreciate your help )

    Add comment
    10|10000 characters needed characters exceeded

    • Have to repeat the same:

      Use:

      =EPMDimensionOverride("000","LOCATION","LOC_PROP_ENTITY=GB")

      Where

      LOC_PROP_ENTITY - is the property of LOCATION dimension containing ENTITY

      You can have multiple ENTITIE selected:

      =EPMDimensionOverride("000","LOCATION","LOC_PROP_ENTITY=GB,LOC_PROP_ENTITY=EUR")

      For the first column the member is delivered by property relationship like in my first answer!