🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Questions about grid & charts

Javier González asked on November 18, 2019

I have a couple of questions about the way the data is displayed on the grid and on the charts. We are using MSAS OLAP cubes as datasource, so:

  1. Is it possible to remove a mid-level in a hierarchy so it is not shown? We have some dimensions configured with different levels such as Year > Quarter > Month > Week. We would like, for example, to remove the Quarter and just have the Year > Month > Week visible both in the grid and the charts. I know we can “see” from one level to everything that is below it, for example Month > Week, but we want to be able to “avoid” mid-levels.
  2. Is it possible to group mid-levels with the same values? Again, with the same example as in 1), we have Year -> Quarter -> Month -> Week. We want to be able to compare the evolution of the measures within the same levels (like, comparing July of this year to last year’s and the one from two years ago, for example). Something as shown in the attached image.



3 answers

Vera Didenko Vera Didenko Flexmonster November 18, 2019

Thank you for your questions.
We would like to explain that both points (points 1 and 2) can’t be achieved with only a single hierarchy.
This is because at the moment it is not possible to omit mid-levels in a single hierarchy. 
We kindly suggest adding separate hierarchies like Date.Year, Date.Quarter, Date.Month, etc.
An example of such a structure can be seen on our MS Analysis Services demo (through the Fields List > Date > Calendar): http://www.flexmonster.com/demos/connect-msas/
Taking the above suggestion into consideration, the desired outputs can then be achieved:
1) It is possible to just select the fields you would like to display on the grid (this way unwanted ones will be omitted). By placing them in the rows section in the slice one after another, you can define in which order the data will be aggregated.
2) The desired chart output can be achieved due to separate level fields being present.
We have prepared a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/fas8m75z/
Please let us know if you have any questions.
Best Regards,

Javier González November 20, 2019

Ok, with point 2) I was already afraid that the suggested solution was the only way to achieve what we want, but I wanted to ask you anyway in case there was another way of doing it.

About point 1), do you plan to add this feature in the future? We have changed the component we were using until now (a very old one: Microsoft Web Components) for yours, and our customers could do this before. It’s not critical but it would be nice to know if you have plans to change this (allow removing mid levels in a hierarchy).

Thank you Vera.

Vera Didenko Vera Didenko Flexmonster November 21, 2019

Thank you for your reply. 
Please kindly note that at the moment such an option is not included in our road map.
Here is why we suggest using the approach suggested above.
You are welcome to write to us in case of further questions.
Best Regards,

Please login or Register to Submit Answer