Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How to customize names of dimensions and measures that show up in Fields list for an OLAP source

Answered
Nilesh Wagle 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.

7 answers

Public
Vera Didenko Flexmonster 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

Public
Nilesh Wagle 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?

Public
Vera Didenko Flexmonster 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

Public
Vera Didenko Flexmonster 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

Public
Vera Didenko Flexmonster 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

Public
Nilesh Wagle 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.

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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/#!roles.
 
Please let us know if that works for you.
 
Kind Regards,
Illia

Please login or Register to Submit Answer