Problems with statistics recording in Analysis for Office

[Former Member]

I have enabled profiling to record query execution statistics in SAP BW system. The statistics are being recorded but without any technical names. I have also checked the base table RSDDSTAT_OLAP. Here also the issue persists. Does anyone have idea how to solve this?

[TammyPowlas]

Hello Vivek,

Would you take a look at this note http://service.sap.com/sap/support/notes/1813352 and see if it applies?  I am not finding any other notes to assist in this area. If that doesn't work I recommend opening an incident with SAP Support.

[Former Member]

Hello Tammy,

We have implemented this note and we are able to get statistics in our system. But the problem is we can't see query technical name in it. the field OBJNAME gives event details and field INFOPROV is left blank.

I'm not sure if there's any mapping issue in this.   

[TammyPowlas]

Hi Vivek - I would submit an incident with SAP Support on this

[Former Member]

I guess that's the last and only option left with us.

[TammyPowlas]

One final idea - see the help at https://websmp105.sap-ag.de/~sapidb/002007974700000246972014E/14SP7_aaoffice_admin_en.pdf (SMP logon required) on page 31 - looks like you can set up various settings, and it also refers to a note

Good luck

[Former Member]

Many Thanks Tammy.

We have already setup events for Analysis for Office and statistics are being recorded, but the only problem is query technical names and info provider names are not being recorded. This will create problems in collecting statistics information.

Regarding SAP Note mentioned in the link, we have implemented it.