Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member204026
Active Participant

SAP has introduced an option to standardize the EPM formatting sheet across the environment in EPM add-in for SAP BPC 10.


Business Case

As part of implementation, to give a similar look and feel to all reports and schedules, we would like to apply the same formatting sheet to all reports and schedules across the environment.


Solution

We can use two predefined templates provided that are stored in the server at the following locations.

  • admin\webexcel\teamtemplatelibrary\reports\report_formatting_template.xslx
  • admin\webexcel\teamtemplatelibrary\input schedules\input_formatting_template.xslx


Optional Step


The two templates must have identical names (extension included) on the server and in the FPMXLClient.dll.config file located on the client computer. The two keys whose values you can modify in the FPMXLClient.dll.config file are the following

  • <add key="ReportFormattingTemplateFileName " value="Report_Formatting_Template.xlsx"/>
  • <add key="InputFormattingTemplateFileName " value="Input_Formatting_Template.xlsx"/>


Additional Note

This functionality works only provided no formatting sheet has been yet defined in the workbook, when clicking View Formats in the EPM tab of the Ribbon, the following formatting sheets are automatically generated in the workbook: the blank formatting worksheet (standard for any connection) and the two formatting sheets generated from the server.


Steps


Step 1: Create your own formatting sheet as base template.

Step 2: Save this template file in one of the following location

  • admin\webexcel\teamtemplatelibrary\reports\report_formatting_template.xslx
  • admin\webexcel\teamtemplatelibrary\input schedules\input_formatting_template.xslx

    Note: If you don’t have ADMIN team, please create the same.

Step 3: Open a new excel file.

Step 4: Click on the “View Format” option

Step 5: This will add our custom formatting tab along with the standard formatting tab.

Additional Note


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

Please refer to the latest EPM Add-in documentation for further help.