With this transaction, you can specify for which objects runtime statistics are to be recorded in the BW system. You can select from queries, InfoProviders, Web templates, and workbooks. You can only select on or off for InfoProviders, Web templates, and workbooks. For queries, you can also select the level of detail for the statistics.
When a new object is created, it always has the default setting D. If you retain or revert to the default value for this setting (D), the system writes statistics in accordance with the setting you made for the default value for the runtime object. You can set the default value in the menu under Extras -> Change Default. The default value always applies to the objects on the current tab page.
To change the settings for individual objects, proceed as follows:
- Select the required objects in the ALV table (you can make a
preselection by choosing Filter and Sort). - Select the required settings in the dropdown list boxes for these
objects. - Confirm your selection by choosing Replace Values.
- The changes are displayed in the list and the changed records are
marked as changed in the last column. - Once you have made all your changes, save the settings by choosing
Save.
Description:
- Query:
- Query times in the front end and calculation layer, and from aggregation layers are recorded.
- InfoProvider:
- Statistics data for maintenance
Delete:
By choosing Delete Statistical Data, you can delete data from the statistics tables. By selecting an Up To time, you can also delete just part of the data. If no such time is specified, a TRUNCATE command is executed for the statistics table; this command quickly removes all data from the tables.
If an Up To time is specified, references to a number of tables might need to be resolved; this means it can take some time to delete large amounts of data. Packages, however, are always deleted completely and then committed. You can therefore always restart without having to duplicate your work. The deletion is performed in a dialog process.
You can also schedule the deletion of statistics data by using program RSDDSTAT_DATA_DELETE and execute the deletion in the background.
