asked on January 23, 2024
We would like to be able (preferably via the UI) to show properties attached to a field in a non-drillable column. Something similar to what happens in excel when you add member properties in a SSAS-sourced pivot-table (see attached file - main picture).
The result we have in mind is illustrated in the attached file - inset.
We checked the docs thoroughly and found no simple solution for it and in any case nothing that a user can select directly. According to many questions on the support site, this is a shared requirement.
Best Regads,
Riccardo
⋅ January 24, 2024
Hello Riccardo,
Thank you for reaching out to us.
We recommend paying attention to the showMemberProperties property of the Options object. It indicates whether the member properties for an OLAP data source are available in the component.
In case its value is set to true, the list of member properties can be accessed by right-clicking on an appropriate cell. Chosen properties will be displayed on the grid.
You are welcome to check an example demonstrating the described functionality: https://jsfiddle.net/flexmonster/6d7fe9qm/.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
⋅ January 26, 2024
This is a GREAT feature! (as usual when talking about FlexMonster…).
I was referring to API server, though (sorry for not mentioning).
Enabling properties and this feature in the API case seems to be such a simple task…
RG
⋅ January 26, 2024
Hello Riccardo,
Thank you for the feedback.
Currently, the showMemberProperties feature is only supported for the "microsoft analysis services" data source type. However, you can still show the properties column on the grid as other columns. To prevent drilling, we suggest using the customizeCell API call. You are welcome to check the following example for reference: https://jsfiddle.net/flexmonster/up8rn0ax/.
Please let us know if it works for you. Looking forward to hearing your feedback.
Kind regards,
Nadia
⋅ February 1, 2024
Hello Riccardo,
Hope you are doing great!
We were wondering if you had a chance to check the suggested approach. Could you please confirm if it works for you?
Looking forward to hearing from you.
Kind regards,
Nadia
