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)
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.
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.
Thank you for your feedback.
We kindly recommend checking out the
useOlapFormatting property of the
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/.