Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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:

IDDescriptionTEST_1
1AASST MANAGER
2BDEPUTY MANAGER
3CCLERK
4DCLERK 2
5EASST MANAGER
6FASST MANAGER
7GDEPUTY MANAGER
8HASST MANAGER
9IDEPUTY MANAGER
10JCLERK
11KCLERK 2
12LMANAGER
13NASST MANAGER
14ODEPUTY MANAGER
15PCLERK
16QCLERK 2
17RASST DIRECTOR
18SASST MANAGER
19TDEPUTY MANAGER
20U

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

Tags:
Former Member
Former Member replied

Hi Tej,

If you want to refer to a cell then please use below. please note that we have highlighted the single quote in red color.

Cell A3 =ASST MANAGER

=EPMDimensionOverride("000","EMPLOYEE","TEST_1='"&A3&"'")



Thanks,

Dinesh,V

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question