BPC 10.1 Is it possible to change the default EPMformatingSheet?

[Michael_Houle]

I would like to change the Default formatting sheet numbers to be financial with commas, decimals, and parentheses around negatives. I know how to use the formatting sheet but would like to change the default sheet globally. Any help is appreciated.

Thanks,

Michael

[former_member186338 · Accepted solution]

Hi Michael,

Please read help: 28 Dynamic Formatting: Pre-defined Templates for Planning and Consolidation Connections

Vadim

[Michael_Houle · Accepted solution]

Thank you Vadim,

This gets us closer than saving a template to the server and hoping that the users remember to use it.

Now, we only have to train the users to select the proper sheet from the Edit Report dropdown to get the ad hoc reports to get them formatted correctly.

Have you ever tried to replace the default formatting sheet in the FPXMLClient config file?

For Others with this issue visit:

Http://scn.sap.com/docs/DOC-57092

This contains the information from the SP16 upgrade document that Vadim referred me to.

If I find a way to replace the default EPMFormattingSheet I will reply to this thread.

Thanks Again!

[former_member689646 · Accepted solution]

Hi

I followed the steps from the help guide and i'm able to get the new formatting sheet.

Now i would like to have my new formatting sheet by default, without the need of changing it everytime i create a report.

Anyone done this? Any hint?

I also tried to use Save as Default button but it's not working.

Thanks

BR

Sílvia

[former_member186338 · Accepted solution]

silviamarques

Please as a new question if you want some answer!