Question

Business Intelligence - Repeating data on each row in cubes.

  • 6 April 2022
  • 6 replies
  • 41 views

Userlevel 2
Badge +3

How to ensure that data is displayed on each row instead of suppressing duplicate data.

So in the example hereunder I want to have “AVE” on 10 times instead of 1 time.

Who can help?


6 replies

Userlevel 7
Badge +19

Hi Marco,

I believe the GUI does this automatically when using Cubes to display data. It deduplicates data and groups it like in the picture. Alternatively you can combine fields into one field using expression fields.

Userlevel 2
Badge +3

When I combine fields into 1, it is no longer possible to drag and drop the individual columns. Is there no option to put the deduplication off?

Userlevel 7
Badge +19

Hi Marco,

This is not possible but I do miss the reasoning behind why you would like duplicate information in your cube? 

Userlevel 2
Badge +3

I don't really have a reason for myself, but my client finds it very useful when he exports the cube to Excel. That's why.

Of course I can make a view for it, but a cube gives more flexibility in sorting and drag/drop of fields.

Userlevel 7
Badge +19

Ah, that makes sense. I do sadly have to say it is not possible to deduplicate the dimensions in the Cube. 

Userlevel 2
Badge +3

Is it an idea for coming releases?

Reply