Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Structuring Bill of Material in BPC

Hello Experts

I have come through one issue in which I want Load Bill of Material Master Data.


Bhagyesh Ravange


Hello All,

It has been achieved by making following changes.

1) Under EPM - User option -> Others -> Select Force Symmetric Refresh for Large Asymmetric Axis.

2) Under EPM - Sheet option -> General -> Select Remove Empty and Zero Values.

The problem with Remove Hide was that it first Expand the Template and was hitting maximum Limit of 150000 cells of BPC limit and Excel limit of  1048576. Hence, by selecting first option error of 150000 was not coming although error of 1048576 of Excel limit was coming. By selecting Remove empty and zero values it is now working fine.


Bhagyesh Ravange

2 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question