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)
Thanks
Nagaraj
⋅ November 11, 2019
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
⋅ 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.
⋅ 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/.
Regards,
Illia
