Skip to Content

slow perfomance BPC

Hi BPC Friends

We have upgraded BPC 10 NW from CPMBPC 801 SP4 to SP 11 and SAP BW 731 SP 7 to SP 16.

We are facing very bad performance in running a report, a package and publish a book

What could I check?

Thanks

Michele

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

14 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 17, 2016 at 09:36 AM

    Hi Michele,

    Check these links for performance tuning in 10 NW...

    https://blogs.sap.com/2013/07/09/performance-analysis-and-optimization-for-bpc-10/

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e08c2aa2-6c58-2e10-3588-e6ed2e7c04f8?overridelayout=true

    How much difference can you see in performance? Ask the BASIS people to check whether the Buffer size is same as previous or not?

    Regards,

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2016 at 10:32 AM

    It has to be a comment! Answer is the answer to original question!

    If you are talking about production then you have to work with basis team to do a lot of performance tests like JP mentioned

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2016 at 09:37 PM

    Hi Michele,

    Yes get a an ABAP trace to determine where the bottle neck is occuring.

    DB , Application, web.

    Also check this note:

    2193471 - BPC NW 10.0/10.1 Report Troubleshooting guide - Performance and Incorrect Results

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 02:14 PM

    Hi BPC Friends

    The basis told me:

    I have rechecked the memory and buffer parameters. Memory parameters are set to higher level and export/import, table buffer parameters can be increased but this might not bring much difference. I feel we are hitting the wrong side.

    What could I try?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 09:32 AM

    thanks.

    I was wondering could I see some improvement if instead of running the light optimise every day I will run the full optimise?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 09:52 AM

    "I was wondering could I see some improvement if instead of running the light optimise every day I will run the full optimise?" - 99% probability that no! Full optimize can improve thing only if you have a lot of dimensions etc... Also if you have a fixed technical names then full optimize will not run at all.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 10:15 AM

    thanks Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 01:03 PM

    Hi Michele,

    We too facing the same issue when we updated from CPMBPC SP 10 to SP21.

    After further analysis with SAP found that before upgrade,there were 3 processes were generated for a query execution,but now only one process is starting.(You can see it in UJSTAT.)

    We got same level of performance after we typed "parallelization=true" in Query options in "Options" tab.

    SAP is coming up with a pilot notes for our issue.

    Just check if parallelism is the root cause in your case also.

    Best Regards,

    Manohar

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 02:08 PM

    Hi Michele,

    Turn on BPC_STATISTICS in Model parameters in SPRO.

    BPC_STATISTICS ..ON.

    Then run the EPM report.

    You can see statistics in UJSTAT transaction code.

    "parallelization=true" in Query options in "Options" tab. where?

    It is in Report edit options.second tab is Options.

    Best Regards,

    Manohar

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 02:35 PM

    Have you switched on statistics to correct model?(Sorry for asking silly question).

    After that run an EPM report.

    Then you can see the statistics.

    Best Regards,

    Manohar

    Add comment
    10|10000 characters needed characters exceeded