Default EPMFormattingSheet

[Former Member]

Hello all,

When you create a new report, and click on the button 'View Formats', a default formatting sheet is openend. I would like to change this default formatting sheet. Does anybody know where the default sheet is stored so that I can change it.

Thanks,

Alwin Berkhout

[Former Member]

Hi Alwin,

The EPM add-in SP16 have this function but still can't work.

Per support's feedback this function will be ok in SP16 patch01 and release at Jan 2014.

[Astha_M]

Hi,

You can create multiple formatting sheets by copying the EPM Formatting sheet and can apply formatting settings from any  of the formatting sheets.

To change the default formatting sheet, the path is:

EPM Tab - Options - Formatting

In the formatting section, specify the default formatting sheet to be selected.

Hope this helps.

Regards,

Astha

[former_member186338]

Hi Alwin,

Astha's workaround is OK, I think you are unable to change the default formatting sheet, because it's hard-coded in the EPM code.

B.R. Vadim

[Former Member]

Thanks for the replies.

Based upon the reaction of Vadim, it is just not possible.

It would be a great enhancement though.

There is already an enhancement request on idea place:

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=9B553FA1-F055-41AC-B9DF-08D3F9BC684A&idea_id=2F537BCC-...
Please promote if you agree that this would be nice to have.

Alwin

[manish_jain7]

Hi Alwin,

Good idea- it is worth having 2 default sheet which can be modified for global use across solution, one for input schedule and another one for report.

Manish

[Former Member]

Hello Alwin,

You have it all in this guide

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

Regards

Gustavo

[Former Member]

Hi Gustavo,

Thank you for your reply. I already searched in this document, but it doesn't mention how to change the default sheet that is applied to new reports (perhaps I was not clear in my first question)

Kind Regards,

Alwin

[Former Member]

Just to clarify:

I know how to change the formatting sheet, but I want to change the 'default' that is applied to newly created reports. With every new report that I create, I have to make changes. I would like to change the 'default' sheet that is applied to new reports so I don't have to change it everytime, and I don't have to copy it over from other reports.

Alwin