on 05-27-2015 2:13 AM
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.