Report does not recognize formatting on inputable member in EPM Formatting-Sheet

[McGreger]

Dear Gurus,

When using an EPM Formating Sheet in the EPM-AddIn for Excel the formatting for "Inputable Members" is not applied to the Report. The formatting for Local Members, Blank Members, Hierarchies etc. is recognized however. I applied the formatting sheet to the report and enabled the "use as input schedule" checkbox in the sheet options. The checkbox for Member/Property Formatting and "inputable Member default Format" is enabled as well.

The EPM-AddIn documentation does not state any specifics when using the "inputable Member" formatting.

I know that i could simply copy the formatting sheet and use "base level Formatting" but i would like to create a single formatting sheet for reports and input schedules in our company as a template.

We use SAP BPC 10.0 and EPM Add-In SP19 (Build 8909) on .Net Framework 3.5

Do you have any suggestions how to fix this issue?

Kind Regards

Eric

[Former Member · Accepted solution]

HI Eric,

The EPM-AddIn documentation does not state any specifics when using the "inputable Member" formatting.

It is used normally when you want specific formatting for your base level member. In BPC you can input date (Save) data only on  the base level member not on parent level members data get aggregates on the parent level member. So "inputable Member"  formatting will apply only on the base level members.

The formatting for Local Members, Blank Members, Hierarchies etc. is recognized however.

If   you are using hierarchies level formatting and inputable Member there are might chances of conflicting formatting,

Better to use either of them and also check check which formatting you are using Row or Column.

[McGreger · Accepted solution]

Thank you for the reply,

There was one member in my pageaxis that was no baselevel. After changing the Member the formatting worked.

sadly when I uncheck the "use as input schedule" checkbox in the sheet options the formatting is still active. Seems like this checkbox only deactivates the "Save Data" Button but does not affect the formatting for "inputable members".

I probably have to go on using 2 formatting sheets - 1 for input schedules and 1 for reports.

Thanks anyway and best regards

Eric

[Former Member · Accepted solution]

Hi Eric,

Can you explain your exact requirement might be you can achieve your requirement using one formatting sheet.

Give some screen shots.    

[McGreger · Accepted solution]

Hey BPC user,

I want to use the same formatting for input schedules and reports in our company (similar baselayout).

The only difference is that within an input schedule inputable cells shall be formated with a yellow background

So when I use the formatting sheet within an input schedule the inputable baselevels have a yellow background, when using the same formatting sheet in a report the baselevels should be simply white.

I thought the epm detects that a member is not inputable when unchecking "use as input schedule" in the sheet options. That is not the case however and even in reports the base levels are shown with yellow background like in the input schedules.

Thanks for your help

Eric

[Former Member]

Hi Eric,

For more details about EPMFormatting Sheet go through below link it will be helpful for you.

Step by step guide to formatting the SAP BPC EPM Sheet

SAP EPM 10 Reporting features