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 fields 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 fields 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.