cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with 0TCT_DS01

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Sujit, even i feel that the delta should have worked with the 'olap' entry checked, but it was not the case. It works fine with 'Others'. Will check the note and revert. Thanks.

Former Member
0 Kudos

Hi, this is resolved. i needed to maintain entries in table RSTCTEXTRACT against 'others'. closing. thanks.