on 02-14-2013 7:14 AM
Hi, we are facing issues with BI Stats data source 0TCT_DS01. there is no entry for this data source in SMQ1 and the number of LUWs in RSA7 is 0. the delta initialised successfully. What could be the issue. the full update seems to be working fine. pl assist. thanks.
Hi Saurabh,
Are you sure you solved this by putting an entry in that table for "others"? Without this entry also you will get entries being populated in SMQ1. As per me OLAP must be checked.
Here is a note mentioning the usage of the table entries. For general statistics you will only need to activate
Note 1237091 - Enhancements to Query Runtime Statistics of BI Admin Cockpit
This note says:
1)'MDX' (Default: Extraction): This step category resumes all steps called through the ODBO Interface. Technically, this corresponds to a STEPUID containing STEPTP = 'MDX'.
2)'OLAP'(Default: Extraction): This step category resumes every user interaction step that involves data access in the Analytical Engine (OLAP). Technically, this corresponds to a STEPUID containing EVENTID '3010' or '3100'.
3)'EXTN' (Default: No Extraction): This step category resumes all steps that involve data access by the Data Manager not in relation to the Analytical Engine (OLAP). Typical Examples: Data Mart Extraction or calling the Data Mart Interface from custom programs. Technically, this corresponds to a STEPUID Containing STEP = 'EXTN'.
4)'DIAL' (Default: No Extraction): This step category resumes every user interaction step that includes processing of dialog screens. Typical Example:Selecting values in a variable pop up and executing the same. Technically, this corresponds to a STEPUID containing HANDLETP = DIAL.
5)'APPL' (Default: No Extraction): This step category resumes all steps that occur in the processing of BI Applications (Frontend) that are not linked to any activity in the Analytical Engine (OLAP). Technically, this corresponds to a STEPUID containing HANDLETP = 'APPL' or 'ITEM'.
6)'OTHE' (Default: No Extraction): All other steps that can not be assigned to any of the before mentioned categories.
Regards,
Sujit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, this is resolved. i needed to maintain entries in table RSTCTEXTRACT against 'others'. closing. thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.