asked on November 6, 2019
I want to rename some or all of the dimensions and measures that show up in the list of Fields that the user can drag into the layout. I know that there is a caption property on all the objects in the Slice but that only applies to the Fields that are in the layout.
Is there a way to do the same for all the Fields from the data source that show up in the Fields list?
I am using an OLAP database as source.
Thanks.
⋅ November 6, 2019
Hello,
Thank you for writing to us.
We kindly suggest specifying the captions on the server-side for MS Analysis Services.
Would such an approach work for you?
Best Regards,
Vera
⋅ November 6, 2019
Well, we looked into that but it is a little hard. Will it be possible for your team to add support for this?
⋅ November 7, 2019
Hello,
Thank you for your reply.
We are glad to let you know that our team has taken your request into consideration.
Our development team will research possible solutions and we will notify you about results with the ETA 2nd of December.
Please let us know if you have any questions.
Best Regards,
Vera
⋅ December 3, 2019
Hello,
We are glad to announce that for SSAS and Mondrian, setting custom labels for hierarchies and measures is now supported via mapping.
This is provided in the 2.7.20 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if everything works.
Best Regards,
Vera
⋅ December 3, 2019
Hello,
We would like to provide some details regarding the mapping property.
The mapping property is part of the dataSource object and it has the following structure:
mapping: {
"UniqueNameOfFieldA": { caption: "YourDesiredCaptionForFieldA" },
"UniqueNameOfFieldB": { caption: "YourDesiredCaptionForFieldB" }
}
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/s7vndLu8/.
Please let us know if any questions arise.
Best Regards,
Vera
⋅ December 4, 2019
Vera
Thanks a lot for this update. I have verified that it works perfectly. I have one question though. I saw that there is way to hide fields from showing up in the Fields list in Elasticsearch data source but I don't see that in the Microsoft Analysis Services data source (which we use). Is there a reason for not having this support for Analysis Services? Will it easy to add this support?
Thanks.
⋅ December 5, 2019
Hello,
Thank you for your feedback.
We are happy everything works fine for you.
For the SSAS data source we recommend using an approach based on the role property of the dataSource object.
roles property is a comma-delimited list of predefined roles to connect to a server or a database using the permissions defined by that role.
More information about roles can be found by the following link: https://www.flexmonster.com/doc/configuring-authentication-process-for-ssas-xmla/#roles.
Please let us know if that works for you.
Kind Regards,
Illia