EVPRO() in BPC 7

[Former Member]

Hello there,

I have one dimension with 5 hierarchies, when i use the evpro() function i always get the hlevel of the first hierarchie, how can i do for get the hlevel of the second hierarchie?

Thanks,

[PatrickFavre]

Hi,

You're right. You can't retrieve HLEVEL property for other hierarchies. The HLEVEL information comes always from the 1st hierarchy. This is by-design. EVPRO function is not designed to use hierarchy specific information. HLEVEL is a technical property, which is actually not maintained by the user.

I guess you're using HLEVEL in reports for enabling conditionnal formatting? If it's the case, I mean you can build your own property and use it in the report, instead if HLEVEL.

For you information, I know that this change in EVPRO behavior has been escalated as an a enhancement request for future releases of the product. But actually, I think there is no workaround available.

Hope this helps.

Kind Regards,

Patrick

[sorin_radulescu]

I think you have to try to specify also the hierarchy when you are specifying the member.

I mean account.H1.member.

Regards

Sorin Radulescu