Quick preview of the data in a cube

Stefan Hering · March 2023

To get a preview of the data in a cube we have to create a screen containing an appropriate dataview.

In order to get a really quick preview of the data in a cube it would be helpful to have the option of saving one or more views of the cube data as part of the analysis of a cube (screenshot below).

It should be possible to display one or more entities of the cube in these views either in the columns or rows. For an entity not displayed in the rows and columns one element can be selected in a pager on top of the view. This pager should offer the option to select an element from the complete tree.

Philipp Schumacher · March 2023

Great Idea! I had something similar on my mind:

Sometime I want to quickly check, for example, how a mapping cube is populatet. In that case it would already be super helpful to be able to pop into the layout editor directly from the cube list - similar to the procedure debugger window - and take a quick look instead of having to take the detour with navigating to a capsule, creating a screen, adding a dataview etc.

Hamza Mesbahi · March 2023

I think that's a great suggestion, too. I think that would save a little bit of time from having to, as Philipp mentioned, navigate to a capsule to create a preview screen there. Sometimes, when you come accross a new application — as part of a new phase, for example—then this would make it easier to get a preliminary idea of what data the cubes contain.

Michael Williams · March 2023

I like this idea.

Similarly I think it would be good to be able to select several cubes to compare and then clearly see the dimensions of each cube, highlighting where they differ.

Kassam Varvani · March 2023

This is standard functionality in tools like Cognos TM1. We should definitely have this!

Daniel Borghs · June 2023

With regards to performance it might make sense to have the overall cube sum and allow further analysis by drilling into this sum? OR a persistent but very simple "check" layout could be defined by makers. I don't know if it would make sense to define complex layouts and selections because at this point you are basically building a screen which could also be done in a data verification capsule with similar-ish effort.