cancel
Showing results for 
Search instead for 
Did you mean: 

EPMDimensionOverrideRange for Dimension

frederico_lapa
Explorer
0 Kudos

Hi,

I’ve been trying to use the function EPMDimensionOverrideRange for dimension Account with hierarchy nodes in a report without success. I’ve prepared two examples: in the first example I’m getting the expected results, but in the second example some nodes are missing.

Example 1 – works fine:

Formula: =EPMDimensionOverrideRange("000";"ACCOUNT";Parametros!E4:F6)

Where ranges are:

Looking at the editor all the selections are correct because there are no other hierarchy nodes between:

Example 2 – the result is not correct:

With a new range: from H11201110 to H11202200 I was expecting the same result above - H11201110, H11201210, H11202100, H11202200.

Formula: =EPMDimensionOverrideRange("000";"ACCOUNT";Parametros!E4:F4)

The new range is:

Looking at the editor the selections are not correct because it only considers the low and high hierarchy nodes and nodes H11201210 and H11202100 are missing:

Does anyone know how to properly use this range function?

My version is: 10.0 SP 38.

Thanks,

Frederico

View Entire Topic
frederico_lapa
Explorer
0 Kudos

Hello nikhil.anand and benniejayfguevarra,

Thanks a lot for throwing some light on this topic.

I've already tested both of your suggestions, but I didn't manage to solve the issue.

In both situations the selected member didn't change in the editor.

Test with formula =EPMDimensionOverride("000";"ACCOUNT";H17):

Test with formula EPMDimensionOverride("000";"ACCOUNT";H18):

My syntax should be missing something... I've already tried many variations, but I coudn't found out the issue.

Any ideas?

Thanks,

Frederico

benniejayfguevarra
Participant
0 Kudos

Hi Fredirico,

The only available member elationship in page axis is Member only. You have no choice but to enumerate it. Please also note there is a limit to the number of members in the page key.

Thanks,

Bennie