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

Hi benniejay.guevarra ,

Please check the following real example.

For report 000 I need to provide a single row with the following filters:

With the the following formula:

=EPMDimensionOverrideRange("000";"ACCOUNT";Parametros!G4:G14)

I can get the accounts filtered in row Axis:

After removing empty and zero values the output is:

My expected output is one row with the sum of the selected nodes:

Total -> 283 812

Bellow you'll find an example of the hiearachy:

To sumup, I need to provide a sheet with several reports (a row for each combination of filters). Bellow, in green you can see what I need to deliver:

Thanks for your help,

Frederico