Skip to main content
R
Ranvir06
Newcomer
July 12, 2023

Common Column Header for multiple columns

  • July 12, 2023
  • 2 replies
  • 0 views

Dear Community,

Can we have common column header for multiple columns. For example, we have same entity name for different columns, and we want to merge and center those column headers for multiple columns. Below is the attached cube view and desired output image.

Ranvir06_0-1689146861844.png

Desired Output:

Ranvir06_1-1689146944803.png

Any solution to this will be very helpful and thankful.

      2 replies

      J
      OneStream Employee
      JackLacavaOneStream Employee
      OneStream Employee
      July 12, 2023

      EDIT: now available for all modes in version 8.2

      In PDF Reports this works like you want, as long as you have one column with two nested dimensions, e.g.

      JackLacava_0-1689153905191.png

      In Data Explorer and Excel, it will also work from version 8.2.

      This is unfortunately a common issue. You might want to upvote (kudo) this IdeaStream post:

      https://community.onestreamsoftware.com/t5/Productivity/Ability-to-Merge-and-Center-Headings-across-Columns-in-a-Cube/idi-p/12541

      See also:

      https://community.onestreamsoftware.com/t5/Reporting/Cube-View-Excel-Column-Headings/td-p/21819

       https://community.onestreamsoftware.com/t5/Platform/Option-to-center-CubeViewData-Explorer-Column-Headers/idi-p/5494

        M
        MatthieuR
        Contributor
        October 17, 2024

        Hi JackLacava , wanted to try this new functionality (I'm on 8.2.2) but this is not working as expected.

        See screenshot of my set up in CV and what it gives as rendering, Direct Manufacturing label is not centered as I would expect it to be

        MatthieuR_0-1729148376051.png

        MatthieuR_1-1729148398146.png

        MatthieuR_2-1729148413004.png

        Looking at video from 8.2 release, it should work

        MatthieuR_3-1729148454237.png

        Is it a bug or am I missing something in the configuration for it to work ?

        Thank you

         

         

         

         

        J
        OneStream Employee
        JackLacavaOneStream Employee
        OneStream Employee
        October 17, 2024

        Yeah, I have a feeling we have a regression there 😢 can you get in touch with Support please... 

        Terms & ConditionsAccessibility statement