cancel
Showing results for 
Search instead for 
Did you mean: 

Flattening Dimension Hierarchy in BPC 7.5 sp15 for Netweaver

Former Member
0 Kudos

Looking for a solution to create an input schedule for the client which flattens out a dimension hierarchy and displays it left to right with the ultimate ancestor (-1) displayed at the far left and each subsequent level following until reaching the base member.  Here is the current hierarchy as displayed in the desktop client.

What the client would like to see in the report is:

The description text is a combination of the ID and the description from the dimension members.  I will not be including the ultimate ancestor in the display since it will be the same for each row.  Note that Material is the base member. The report measures will follow the flattened hierarchy display.

It would also be useful to suppress repeating cells, for example if multiple Brands are displayed then Business would not repeat until it changes to the next Business.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Maybe using properties on your dimension? You could use something like a LEVEL property and then using it on your report. Worst case you could manually create the input form with EVDRE functions (EVGET, EVSND) and using spreadsheet logic, something like:

if(EVPRO(LEVEL) = 1, "++ "&EVPRO(DESCRIPTION), if(EVPRO(LEVEL) = 2, "++++"&EVPRO(DESCRIPTION)),...)

Replacing the ++ with tabs or blank spaces, hope you get what I mean

Message was edited by: Ivan Rodriguez Just remembered that BPC has an HLEVEL property builtin, you could instead use that