Skip to main content
Solved

Business Intelligence - Repeating data on each row in cubes.


Forum|alt.badge.img+7

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?

Best answer by Sebastiaan Meijerink

@Marco Kleiweg At this point exporting the cube to excel is still on the backlog for Universal. However I will add this as a requirement to the export story. Maybe even as an option box the user can tick.

View original
This topic has been closed for comments

Mark Jongeling
Administrator
Forum|alt.badge.img+23

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.


Forum|alt.badge.img+7

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?


Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi Marco,

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


Forum|alt.badge.img+7

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.


Mark Jongeling
Administrator
Forum|alt.badge.img+23

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


Forum|alt.badge.img+7

Is it an idea for coming releases?


Mark Jongeling
Administrator
Forum|alt.badge.img+23
Marco Kleiweg wrote:

Is it an idea for coming releases?

This is not possible with the component we use in the Windows and Web GUI.

Not sure the Universal GUI component can do this. @Sebastiaan Meijerink; do you happen to know this is achievable in the Universal GUI? 


Forum|alt.badge.img+1

Hmmm. No the grouped row items will not repeat. It might be possible, but what I get from the discussion is that the issue is that it isn't repeated when exporting to Excel. I would suggest that we try to solve the actual problem and not change the behavioure of this component. 

Am I right in stating that the issue is not that it is visually represented this way, but that it isn't repeated when exporting to Excel?


Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi @Marco Kleiweg,

Could you reply to Sebastiaan's question? We are looking to hear from you.


Forum|alt.badge.img+7

The issue is indeed that it isn't repeated when exporting to Excel.


Forum|alt.badge.img+1

@Marco Kleiweg At this point exporting the cube to excel is still on the backlog for Universal. However I will add this as a requirement to the export story. Maybe even as an option box the user can tick.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings