Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2015 at 02:57 PM

    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.





    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2015 at 03:00 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.