How to configure profiling for all the Analysis for Office workbooks on the server side?

[former_member245939]

Hello Experts,

Could you please give me an advice, how to configure profiling for all the Analysis for Office workbooks on the BW server side? Is it possibler to force Query runtime statistics to be written to the RSDDSTAT_OLAP for all AO workbooks opened by users on any PC clients?

We need to load AO workbooks usage statistics in SAP BW (like we have for BEx WBs) via datasource 0TCT_DS01.

I found only the way to set Profiling setting = "true" on the client side, so all users have to set this setting manually every time on every PC. But we need to collect statistics independantly of users.

Best regards,

Sergey

[henrikbaumann]

Hi Sergey

You can set the profiling options in the C:\ProgramData\SAP\Cof\Ao_app.config

You should set it up as:

<section name="Profiling" type="Boolean" configurationLevel="PerMachine" />

<Profiling value="True" />

This will prevent users from disabling it from the ao_user_roaming file. Depending on your organizational setup, you can include these settings as part of the installation, or your might even be able to replace this file on all users' PCs.

You can read more about profiling here: Troubleshooting in Analysis - SAP Help Portal

I don't think you can set it up from the server side.

BR Henrik

[former_member245939]

Hi, Henrik

Many thanks for your answer! Predefined config files could be the way we should use, if there is no possibility to configure on the server side.

Best regards,

Sergey.