How to Group Columns by Cube in Data View Layout

govindakarisma · 2025-06-02T04:24:42+00:00

There was an error rendering this rich post.

Hi everyone, I have question about data blocks Detail by Month

As shown in the attached screenshots, the columns for Q Ovun (PO) and Q Ovun (GR) in the Data View are currently sorted by month, which results in an alternating pattern (e.g., Q Ovun (PO) Apr.25, Q Ovun (GR) Apr.25, Q Ovun (PO) May.25, Q Ovun (GR) May.25, etc.).
However, this is not the desired layout.

In the Layout's Data Blocks configuration (please refer to the second screenshot), the Q Ovun (PO) and Q Ovun (GR) values come from different cubes (CUBE_Q_OVUN_PO and CUBE_Q_OVUN_GR respectively), both detailed by month.

What I would like to achieve is for the months to be grouped per cube. For example:

Q Ovun (PO) Apr.25, Q Ovun (PO) May.25, ..., Q Ovun (PO) Dec.25,
Q Ovun (GR) Apr.25, Q Ovun (GR) May.25, ..., Q Ovun (GR) Dec.25

Is there a way to configure the layout so that the columns are grouped by cube first, then sorted by month?

Thank you in advance for your guidance!

Find more posts tagged with

Screen Design

Accepted answers

Helmut Heimann

Hi @govindakarisma ,

you could put an algorithm between the two cubes in the layout and hide that block.

That would result in this

Best,
Helmut

govindakarisma

Thank you very much for your clear explanation and solution.

I’ve tried your approach in my environment by placing a hidden algorithm block between the two cubes, and it worked perfectly! The layout now displays the columns grouped by cube as expected

All comments