Skip to main content
S
Sam_OS
Member
July 21, 2022

Column SubHeaders in Cube Views

  • July 21, 2022
  • 4 replies
  • 0 views
Hi, Please advise if we can add sub headers in CV columns, For example below the main CV Col header has Opening Balance and Cash Invested in Col1 and Col2. But for section 2 below I need the Col header to be Closing Balance and Opening Balance and for Section 3 I need the col header to be Disposal and Sale. Please advise if any user has managed to add sub headers in columns in CubeViews. Any suggestions will be much appreciated. Please note I need the header in Col/Row intersection cell and not in the Row Header. Thanks Sam Opening balance Cash invested Joint venture equity Corporate Group 82,763,441 8250000 Corporate Group 6,000 XYZ Group Limited 132,000,000 Joint venture equity 1,322,873,882 8250,000 -------------------------------------------------------------------------------------- Closing Balance Opening Balance BAA0400400 1,384,034,25, 316,131,428 BAA0400500 -74,503,772 -128,015,962 BAA0400601 518,818,000 518,818,000 Total Cost 1,828,348,482 706,933,466 -------------------------------------------------------------------------------- Disposal Sale BAA0400400 -14,059,552 14,059,552 BAA0400601 -370,000,000 -370,000,000 Net Book Value -384,059,552 -384,059,552

    4 replies

    C
    OneStream Employee
    ChristianWOneStream Employee
    OneStream Employee
    July 21, 2022

    Did you try this:

    ChristianW_3-1658415637285.png

     

    ChristianW_2-1658415551757.png

     

     

    S
    Sam_OSAuthor
    Member
    July 26, 2022

    Hi Christian, 

    Thanks for your reply. I have used the Header overrides function for other reports. What I am actually looking for is inserting a sub - header in a column/row intersection cell. For example below the yellow cells are the usual Column and Row Headers. But the user needs the headers highlighted in Blue in the report. Please advise if you come across this scenario where we can insert headers in column/row intersection cells in Cube Views. Thanks Sam Column Headers.PNG 

    C
    OneStream Employee
    ChristianWOneStream Employee
    OneStream Employee
    July 26, 2022

    Ah, ok, I misunderstood.

    Normally, a cell in cubeview is a number, but your problem can be solved using an text view member like annotation: a#cost:v#annotation is of type text.

    You can also work with a parameter based cell, you then just need a list type parameter that interprets integers as the needed labels. I.e. 1 = Closing Balance, 2 = Disposal, …

    I’m not at my notebook right now, but I will post a sample the next days.

    S
    Sam_OSAuthor
    Member
    July 27, 2022

    Hi Christian, Thanks for your reply. I already tried the Annotation option and it works only for one period. As you may be aware if we change the period the text in annotation disappears. I have attached the actual version of the CV that I am working on. I have worked out the headers in rows and columns highlighted in green. My issue is the headers in blue color in bottom two sections. Please let me know if you came across similar type of CV or if we need to use Report Designer to fix this issue. Thanks SamJV.PNG

    C
    OneStream Employee
    ChristianWOneStream Employee
    OneStream Employee
    July 27, 2022

    The Annotation doesn’t need to be stored, it can be a member formula. Then it will be the same for all periods (and all other dim members).

    ChristianW_0-1658923093090.png

     

    C
    OneStream Employee
    ChristianWOneStream Employee
    OneStream Employee
    July 27, 2022

    or even better:

     

     

    If api.View.IsAnnotationType Then
	Return api.Pov.Flow.Name
End If

     

     

    ChristianW_1-1658936577711.png

     

    ChristianW_0-1658936482441.png

    If api.View.IsAnnotationType Then
	Return api.Pov.Flow.Description
End If

    ChristianW_2-1658936941916.png

     

    Terms & ConditionsAccessibility statement