Get Free Trial
Get Free Trial

Format cell default values need to be set

Answered
Nagaraj Chatiri asked 7 days ago

Hello Team,
When I connect to MDX cube and display the data in BI, there is an option to format cells to display few columns in specified format. 
Current Default settings of the format cells is attached in screenshot. 
 
Expected Default settings on clicking the format cells is 
Thousand separator should be comma (instead of space)
decimal places should be 2 (instead of 3)
 
Thanks
Nagaraj
 

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 4 days ago

Hello, Nagaraj,
 
Thank you for your question.
 
Please, check out the number formatting tutorial by following the link below:
https://www.flexmonster.com/doc/number-formatting/.
It will allow you to set default formatting for your table.
 
Find out an example we made for you: https://jsfiddle.net/flexmonster/8bgzkavL/.
 
Also, our team kindly suggest you using getReport method (Save button on the toolbar) to get information about current report properties.
 
We hope it helps.
 
Best Regards,
Illia

Public
Nagaraj Chatiri 3 days ago

Hi Team, 
Formatting is already done on server level in the cube, that works properly without doing anything when we connect cube in excel but does not work in flex monster, please let me know how to get it working in flex monster.
 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 2 days ago

Hello, Nagaraj,
 
Thank you for your feedback.
 
We kindly recommend checking out the useOlapFormatting property of the options object.
 
Setting its value to true allows receiving already formatted values from the cube you are working with.
 
Please, find out more about the options object and its properties by following the link: https://www.flexmonster.com/api/options-object/.
 
Regards,
Illia

Please login or Register to Submit Answer