Structuring Bill of Material in BPC
I have come through one issue in which I want Load Bill of Material Master Data.
Bhagyesh Ravange replied
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.