Get Free Trial

¿Is there a way to show all dimensions in the same group in the fields box?

Mauel Santizo asked on May 22, 2017

Im working with ms ssas and in the olap cubes we have different measures gruops but to the client we want to show like a list of all fields that he can use, not separeted by dimensions. There is how i can do this ?

3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster May 23, 2017

Hello Manuel,
Thank you for your question. By design, the Flexmonster Pivot component Field List shows the same structure which is configured in your cube. Therefore if you want to have the fields as a plain list, you should replace your multi-dimensional fields with the one-dimensional.
As a workaround, you can write your own Field List with the different representation of the cube structure on the client side. The Flexmonster Pivot Component gives a wide variety of API calls which makes it much easier to do. For more information about the API calls please visit our documentation page –
Let us know if you have additional questions here.
Best regards,

Bill Hamill August 12, 2019

Has there been any more thought on this question? We too would like to group dimensions in the UI to help users distinguish dimensions and measures. Thanks for your feedback. 

Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 13, 2019

Hello Bill, 
Thank you for reaching us.
Currently, the best solution for such case is to implement your own Field List. Such an approach allows implementing the UI behavior you need.
The general idea of how a custom Field List can be created is provided in the following thread:
Please let us know in case of any other question.

Please login or Register to Submit Answer