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

Display only few fields in the All Fields menu

Answered
Akshay Alva asked on May 17, 2021

Hi,
 
Is there a way to show only a selected list of fields under All Fields option instead of all the elements in the csv / olap cube?
Please refer to the attached snapshot, I want the user to see only User and Year in the list under All Fields and other fields like Months, Products should not be available for selection to the user (but my olap cube will continue to contain all the elements which i will be using for some other tasks).
 
Thanks in advance.

Attachments:
Capture_AllFields.JPG

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 18, 2021

Hello,
 
Thank you for posting on our forum.
 
When connected to CSV, you can hide the field by setting its visible property to false in the Mapping Object. Please see the JSFiddle for reference: https://jsfiddle.net/flexmonster/ohgxLdp7/.
 
For SSAS, it is not possible to hide specific fields. It is required to adjust fields on the side of the cube.
 
Please let us know if it helps.

Regards,
Illia

Public
Akshay Alva May 21, 2021

Hi,
 
We are using Mondrian OLAP cube (XMLA) to populate the table.
We need to modify the list of dimensions available for the user to select (The actual cube may have more dimensions and measures, we just want to display only a subset of this when the pivot table is loaded). 
Similarly we also want to filter the available values from the dimension (eg. in the JSFiddle you shared, we want to limit the value of Country to Australia and Germany).
Basically we are looking at a mechanism to interact with the code / API which generates MDX queries in the soap request.
Or is there an alternative mechanism or some API in flexmonster.js which we can use to achieve the above desired functionality.
 
Thanks in advance.

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 21, 2021

Hello,
 
Thank you for posting on our forum.
 
For Mondrian, it is possible to use the role-based approach in order to limit access to some columns of the initial dataset. It implies configuring roles on the server-side. For each role, a different set of fields is available. Flexmonster itself provides the possibility to pass the user’s role when connecting to Mondrian. Please see the following piece of documentation for further details: Configuring Mondrian roles | Flexmonster.
 
Finally, we want to mention that we have stopped supporting the connection to Mondrian some time ago. This means that new features and further development/improvements will not be added for Mondrian. Still, it will continue to be available in the current state.
 
 
With this in mind, instead of Mondrian, our team highly recommends considering Flexmonster Data Server for connecting to your database. This tool provides an efficient way to handle large data sets from different data sources (JSON, CSV, databases). The Flexmonster Data Server is built on the custom data source API – a special protocol for connecting to any data source. Just as in Mondrian, the data is aggregated on the server-side, enabling it to handle large data volumes.
 
We would like to mention that our team is actively developing the Flexmonster Data Server, regularly introducing new features and improvements. 
Aside from being provided as an EXE, the Flexmonster Data Server is available as a DLL, making it possible to extend the provided features and add custom functionality.
 
Please see the following guide for more information about this approach.
 
Please let us know if it helps.
Feel free to contact us if any other questions arise.
 
Best regards,
Illia

Please login or Register to Submit Answer