Does Dimension Override has any Limitation

[Former Member]

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

[Former Member · Accepted solution]

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)

[Former Member · Accepted solution]

Hi Tej,

try this:

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

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

Andy

[Former Member · Accepted solution]

Hi Andy,

It is giving same result.

What if i want to reference my member is reference to another cell like

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

In this reference cell, we cannot use your suggested formula

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

Regards,

Tej

[Former Member · Accepted solution]

Hi Tej,

If you want to reference to a cell then you don't need ""

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

Andy

[dinesh_veluru · Accepted solution]

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

[Former Member · Accepted solution]

Hi Dinesh,

Thanks for the help. It worked perfectly.

Regards,

Tej

[Former Member · Accepted solution]

Hi Dinesh,

Can we get the list of Dimension Properties as drop down?

We have similar functionality using EPMDIMENSIONPROPERTYVALUES.

I tried EPMDIMENSIONPROPERTY, but it is asking for destination Range, if i gave one cell, EPM is bringing only the First property.

I want to get the Dimension properties as drop down, is there any EPM function available?

Regards,

Tej

[dinesh_veluru · Accepted solution]

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