Insert blank row at each level in BPC Report

[dipalpatel]

Hello

Is it possible to insert blank row at each level of the hierarchy in BPC Report?

I have dimension list something like below. When i select Member and Descendants for "World", i want to insert a blank row for each hierarchy level.

H1 - World

  H2 - Asia

  H3 - India

         Japan

         China

  H2 - Europe

  H3 - Belgium

         France

         Germany

Thanks in advance..

[former_member208963]

In your dimension selector (Edit report), use the MEMBER SORTING and GROUP located in the top part near Member properties.

Enable member sorting, Group by property H1 for examaple, and put a empty formula (="") after group

Regards

[Former Member]

Great Robert! Thanks for the alternative solution.... . Works Perfectly....

[dipalpatel]

Hi Robert

Thanks for the response. It does add blank row between different hierarchy level, But because of sorting, I guess it changes the sort order. Now, Report structure looks like this.

[Former Member]

Hi Dipal,

Yes it will sort the members. You can create a local member from the Local members tab and attach it to every hierarchy node! Problem is if in future any node is inserted below "World", you will have to insert a local member again for it. If its not going to change then this approach would be best for you.

JP

[Former Member]

Hi Dipal,

You can insert "Blank member" after every hierarchy level manually through Edit Report. But that will make your report static and not dynamic. You will have to select each node and then insert Blank member. OR in the report after every node insert a blank row. Again this will be static. If your hierarchy is not going to change frequently then you can use this option.

Regards,

JP