Skip to main content
S
Sabaritha
September 25, 2023

Introduce a Blank row in-between members in Tree Expansion

  • September 25, 2023
  • 2 replies
  • 1 view

Hello All,

I have a reporting requirement, where I need to introduce an empty row between two Sub-Business units. These business hierarchies are displayed using .Tree expansion. In between the Tree hierarchies is it possible to introduce “Blank Rows”. Please let me know. Thank you.

    2 replies

    P
    PeterFu
    September 26, 2023

    Hi Sabaritha,

    You can try E#None:Name(" ") in the row you want to show blank (:Name(" ") will make sure no text is shown). Then you can format that row a bit different if you want to show the blank row as a "separator" row.

    Peter

    S
    SabarithaAuthor
    September 26, 2023

    Thank you Peter! I am aware of this method of introducing blank row. What I want to achieve is when I am using .Tree to display the hierarchy, will I be able to introduce blank rows in-between the hierarchy members which is getting dynamically displayed.

     

     

    J
    JackLacava
    September 26, 2023

    You can't do that with standard filters, no. You could create a custom Member List in a Finance Business Rule as explained here, and place your "A#None" strategically in that list, but it's a bit of work and I'd do it only if you plan to use it in multiple reports. Otherwise, the solution shown by ChristianW is probably the best approximation.

    C
    ChristianW
    September 26, 2023

    Hi Sabaritha

    This will only work if you embed a blank member in the hierarchy of the members. Then you can use a conditional formula to format the blank row accordingly. But I have to admit, I'm not a big fan of changing the metadata for reporting purposes.

    Without changes to the hierarchy, and keeping the drillability in takt, this is the best I get:


    ChristianW_0-1695721106627.png

    The dimension with the tree command needs to be in the second (or 3rd, or 4th) expansion level and then the you can hide the first expansion level by using this setting:


    ChristianW_1-1695721267376.png

    The result will look like this:


    ChristianW_3-1695721663231.png

    If you use conditional formatting smart, you will still be able to create a nice-looking cubeview.

    I hope this helps and cheers

    Christian

    Terms & ConditionsAccessibility statement