Skip to Content

Hello Everyone,

Here I would like to showcase, how to ignore worksheets from Analysis Office processing and improve the initial loading performance.

Consider the scenario of AO workbook, which is quite slow in opening and has lot of worksheets with excel formulas and excel functionalities.

In such cases, lot of time is spent by AO, analysing all the worksheets in order to find out, if there are SAP formulas or data related to datasource.

If we mark all the worksheets, which do not contain any AO functionality as “Non-COF”, we can improve the loading time of workbook. This can be done under the “Components” tab of Display panel.

Let’s consider the AO workbook which has two worksheets, wherein first worksheet contains the Data source(from BW or HANA) and the second worksheet just refers the first worksheet and uses some excel formulas and functionalities to get the expected results.

Sheet1 -> Contains the Data source

Sheet3 -> Contains the excel formulas and functionalities

Please note that, by default, when the data source is added to any worksheet, it will be treated as Analysis Sheet Type. In this case, Sheet1 is having a data source from BW, and hence it’s marked as Analysis Type

Capture1.JPG

Let’s say “Sheet3” is not marked as “Non-COF Worksheet”, and marked as “Analysis”(which is default).

Capture2.JPG

Open the AO workbook and refresh it. Check the AO Logs by opening the .glf file.

Capture3.JPG

You can see that the data presented in Sheet3 is taken into consideration by AO, for processing.

Capture4.JPG

Let’s look into the other scenario, say “Sheet3” is marked as “Non-COF Worksheet”.

Capture5.JPG

Open the AO workbook and refresh it. Check the AO Logs. You can see that AO skips that worksheet and hence time spent for this checking would be cut-off, and the loading performance would be improved.

Capture6.JPG

Hope this helps.

Regards,

Murali

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Timur Zaynashev

    That is pretty informative. I have similar case, but with EPM plug-in, not with AfO plug-in.┬áDo you know how to make Worksheet Type = “Non-COF” for EPM plug-in by default?

    AutoActiveEPMSheet parameter = “false” in the FPMXLClient.dll.config file is not working. All new Excel workbooks are started as “EPM Workbook” by default. It decreases performance a lot.

    Many thanks in advance.

    Regards,
    Tim

    (0) 

Leave a Reply