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 ?
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 – http://www.flexmonster.com/api/.
Let us know if you have additional questions here.
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.
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: https://www.flexmonster.com/question/prevent-to-modify-fields-options/.
Please let us know in case of any other question.