Skip to Content
avatar image
Former Member

Does Dimension Override has any Limitation

Hi All,

Does Dimension Override has any Limitation?

This is my Scenario:

I have a Dimension "EMPLOYEE" with Below Properties:

ID Description TEST_1 1 A ASST MANAGER 2 B DEPUTY MANAGER 3 C CLERK 4 D CLERK 2 5 E ASST MANAGER 6 F ASST MANAGER 7 G DEPUTY MANAGER 8 H ASST MANAGER 9 I DEPUTY MANAGER 10 J CLERK 11 K CLERK 2 12 L MANAGER 13 N ASST MANAGER 14 O DEPUTY MANAGER 15 P CLERK 16 Q CLERK 2 17 R ASST DIRECTOR 18 S ASST MANAGER 19 T DEPUTY MANAGER 20 U

ASST DIRECTOR

I want to create a report with Dimension Override functionality

When the below code is used, system is working fine

=EPMDimensionOverride("000","EMPLOYEE","ID="&19)

When the below code is used, system is giving ERROR

=EPMDimensionOverride("000","EMPLOYEE","ID="&ASST MANAGER) or

=EPMDimensionOverride("000","EMPLOYEE","ID="&DEPUTY DIRECTOR)

When the below code is used, system is working fine

=EPMDimensionOverride("000","EMPLOYEE","ID="&CLERK) or

=EPMDimensionOverride("000","EMPLOYEE","ID="&MANAGER)

EPM Dimension Override Member Syntax will not accept members with " " space like ASST MANAGER, if i use ASST_MANAGER, Dimension Override function is working fine.

Is there any work around for this?

Or

All members in the Dimensions should not have any spaces?

When I run the report with Dimension Filter in edit report based on same ASST MANAGER or DEPUTY MANAGER, system is working fine.

But in Dimension Override is not giving the result?

Regards,


Tej

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 27, 2015 at 01:16 AM

    Sorry typo error:

    here are the formulaes

    =EPMDimensionOverride("000","EMPLOYEE","TEST_1="&ASST MANAGER) or

    =EPMDimensionOverride("000","EMPLOYEE","TEST_1="&DEPUTY DIRECTOR)

    When the below code is used, system is working fine

    =EPMDimensionOverride("000","EMPLOYEE","TEST_1="&CLERK) or

    =EPMDimensionOverride("000","EMPLOYEE","TEST_1="&MANAGER)

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tej,

      Yes you can get the list of properties using EPMDimensionProperty.

      For destination range give some range in the hidden cells.

      then use Data validation and populate the list/drop down using the ranges.

      PS: there is no epmfunction to direct populate the dimension properties in the drop down list

      .

      Thanks,

      Dinesh.V