Skip to Content

Structuring Bill of Material in BPC

Hello Experts

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

Regards

Bhagyesh Ravange

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 27, 2014 at 09:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 19, 2014 at 06:58 AM

    ok, thanks for letting us know.

    Andy

    Add comment
    10|10000 characters needed characters exceeded