Skip to Content
avatar image
Former Member

Analysis workbooks are slow to open

Hi ,

Can you please help me with the below information.

We are using BOBJ Analysis version 1.4 . Users are creating workbooks connected to several to data sources (Bex) and these workbooks are saved and reused. But they are reporting issues saying workbooks are taking long time to open ,load and refresh. so when we checked the scn sap , we found out that style sheets are the reason for poor performance.

Can you please let me know why style sheets are copied in workbooks because we dont have any and is there any way we can avoid style sheets.

If I download the macro to remove style sheets does it have any other impact on workbooks.

Thanks,

Bharathi.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2015 at 05:54 AM

    Hi Bharathi,

    My understanding is that this is an Office Issue. What we found was that our users had to migrate workbooks so they would copy a sheet from another workbook to the new workbook which will result in the styles that exist in the original workbook being copied into your new workbook.

    We have used the style remover on a few hundred workbooks with no impact that we have picked up yet.

    Hope that helps you.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2015 at 01:52 PM

    Hi Bharathi,

    I tried this macro in a compeletely new workbook and from my point of view, I would agree with Michael to use it on migrated workbooks... otherwise you just lose the original style of the datasource temporarily.

    When you have the checkbox activated "Apply Default Formats" the formats will be back after the next refresh ... just test it and you will see 😉

    Since you said your users complain about the load and refresh performance, you could use one of those two options "Statistics / Client Profiling" to find out what consumes most of the time:

    Analysis for Office Profiling (AO statistics)
    http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=430671542

    Advanced Client Profiling
    http://scn.sap.com/docs/DOC-53580

    Be aware that the log will be increased everytime you execute any action.

    If you want to compare logs for the same repeated steps, then you need to close your workbook and re-open it. Then you can start with a clean log again.

    Best regards,

    Martin

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2015 at 07:03 PM

    Hello Bharathi - as requested before, please state which SP of 1.4 you are using; please try using the latest SP as the performance is always improved with each SP.

    Add comment
    10|10000 characters needed characters exceeded