Structuring Bill of Material in BPC

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.

Regards

Bhagyesh Ravange