Syntax for HLEVEL for EPMDimensionOverride function

[Former Member]

Dear Friends,

What should be the syntax of pulling the HLEVL in EPMDIMENSONOVERRIDE function.  I have a report in 10.1  and in row axis I have account dimension. The expansion is created using EPMDIMENSONOVERRIDE function.

Now  I have a requirement in which I need to pull HLEVEL=4  for PNL hierarchy and I am using syntax PNL(HLEVEL="4"). But this is not working.

Kindly advice

Rahul

[former_member186338 · Accepted solution]

"I am using syntax PNL(HLEVEL="4")" - where you have found this syntax???

May be:

LDEP(4,PNL,Y)

Please read help for EPMDIMENSONOVERRIDE

[former_member186338 · Accepted solution]

P.S.

Actually if PNL has HLEVEL=1, then to get level 4 you need 4=1+3:

LDEP(3,PNL,Y)

[Former Member]

Thanks Vadim. You are BPC Guru!!

[Former Member]

Hi Rahul,

HLEVEL can be used if you have only single hierarchy in the dimension i.e only PNL hierarchy. In case of multiple hierarchies with multiple levels, Vadim's suggestion is perfect!

Regards,

JP