Forum Discussion

Sam_OS's avatar
Sam_OS
New Contributor
3 years ago

Column SubHeaders in Cube 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
    • Sam_OS's avatar
      Sam_OS
      New Contributor

      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  

  • ChristianW's avatar
    ChristianW
    Valued Contributor

    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.

  • Sam_OS's avatar
    Sam_OS
    New Contributor

    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 Sam

    • ChristianW's avatar
      ChristianW
      Valued Contributor

      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's avatar
    ChristianW
    Valued Contributor

    or even better:

     

     

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

     

     

     

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