Question:
Howdy
When running a report via the web you have the option to change the scaling and rounding via properties but I cannot find this facility when running the report in Excel.
Can someone please advise whether the same scaling and rounding properties are available within excel as part of the Bex addon or do I need to use the excel functions manually to achieve the same result as the web?
Regards
E
Answer:
Click the change button -> local query -> right-click appropriate keyfigures -> choose properties. Users can then save the workbook as a favorite to retain the settings.