Skip to Content
0
Sep 06, 2023 at 11:45 AM

EPMDimensionOverrideRange for Dimension

172 Views

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:

image.png

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

image.png

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:

image.png

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:

image.png

Does anyone know how to properly use this range function?

My version is: 10.0 SP 38.

Thanks,

Frederico

Attachments

image.png (100.4 kB)
image.png (27.8 kB)
image.png (59.2 kB)
image.png (31.6 kB)