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

Format cell default values need to be set

Nagaraj Chatiri asked on November 8, 2019

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)

3 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 11, 2019

Hello, Nagaraj,
Thank you for your question.
Please, check out the number formatting tutorial by following the link below:
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,

Nagaraj Chatiri November 12, 2019

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.

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 12, 2019

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/.

Please login or Register to Submit Answer