Question:
Hi,
I created a query on the BW stats Multiprovider to find out if the query is hitting the aggregate or cube and if so to find the # of times. I had " # of Navigations" as Key figure and with Infoccube, aggregates and query
in the rows . In the report I see "not assigned" under query column for particular Infocubes though there are queries for that particular infocubes.
Can anyone tell me what might be the problem. Also Is my approach correct?
Thanks
Answer:
hi,
instead of using the content of SAP, you might try TA rsrt, select a query and 'execute and debug'. a window open, where you should mark the first box 'show aggregates found'. press enter, then the query will be executed. depending on the query several windows should open showing the the characteristics needed for the execution and the aggregates found. see the first column, if there is a cube name, no aggregate was found, if there is something like 'F0xxxxx'. an aggregate was found for
your query.
the runtime an usage of aggregates could be checked in table rsddstat: select the user executing the query, start- and endtime.......
look at https://websmp105.sap-ag.de/~sapidb/011000358700001890502003 . in this document all the fields of rsddstat are explained
regards
Answer:
rfhaselm , thnaks for your Input . I have one more Q on the BW stats Multi provider.
Can the # of Navigations Keyfigure be used to check how many times a query is ran by a particular user or does it also include the navigations within the query once the qry is ran
Thanks