SAP Knowledge Base Article - Preview

2736027 - Excel formatting issue when "calculate parent in hierarchies" is activated in EPM report


When creating a simple EPM report without any EPMFormattingSheet in BPC 10.1 or BPC 11, the first column of data in the report, for all parents lines are align in the right.

By changing the alignment in all the report to align the data in the center and by refreshing the report, the alignment of parent line comes back to the right.




EPM Plug-in in Analysis for Office 2.7.3

EPM Add-in


SAP Analysis for Microsoft Office all versions


epm, add-in, plug-in, align, aligned, format, formatting, option, calculate, parent, hierarchy, hierarchies, data, center, right, left , KBA , EPM-XLS , EPM Excel Client , BI-RA-AO-XLA , Excel Addin , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.