We are using BPC 7.5 M SP3 and have a user defined Dimension named COSTCTR. This Dimension has 3 hierarchies in it - PARENTH1, PARENTH2 & PARENTH3. There are members in the dimension that belong to all 3 hierarchies, but sit at different levels (HLEVEL) in each of the 3. We have reports that add spacing to row headers using the REPT() function, and we use EVPRO() to look at the memberID's HLEVEL to come up with the number of spaces to insert.
The issue is that EVPRO() seems to be looking by default at HIR=H1 by default. Can anyone tell me the syntax I would use in the EVPRO() function to point the MEMBER parameter to one of the other hierarchies (HIR=H2 or H3)? I have tried syntax like "COSTCTR.H2.<member id> (with brackets around each) and COSTCTR.H2.<member id> (with brackets around each) and that doesn't seem to work. I'm not sure if my syntax is wrong or if this formula by design can only pull the HLEVEL property from the 1st hierarchy. Any help would be eternally apprecated.
Thanks,
Todd
Edited by: Todd Paulauskas on Nov 3, 2010 3:49 PM