BI 7.0 Configuration Steps

Configuration Steps:
To configure the BI Administration Cockpit follow the steps below:
1. Go to transaction SPRO.
2. Click ‘SAP NetWeaver’ dropdown.
3. Then select ‘Business Intelligence’ dropdown.
4. Click ‘Setting for BI Content’ dropdown.
5. Then again select ‘Business Intelligence’ dropdown.
6. Now Click ‘BI Administration Cockpit’.
7. Here you follow sequence of steps as shown under ‘BI Administration Cockpit’ dropdown as follow:

Activate the new technical content in SAP NetWeaver BI.
Assign the BI Administrator Role.
Control Updating of Statistics.
Schedule Technical Content Process Chains.
Connect BI system and Portal.
Install Business Package’ BI Administration 1.0’.
Set Up Call to BI Administration Cockpit.
Additional information on the individual steps can be found in the configuration IMG. There are some stander process chains which have to be scheduled in order to transfer BI Statistics Data to the new Technical Content.
SAP



In SAP NetWeaver BI7.0 Query Runtime Statistics is split into two major parts:
Front End and OLAP Statistics: Runtime of BI front end application and Runtime of query in OLAP processor.
Data Manager: Runtime for retrieval of data from BI InfoProvider or the BI Accelerator.
The key feature in Query Runtime Statistics is ‘Statistics Detailed Levels’. It allows level of detail of statistic data collected for certain BI object. The main InfoProvider for query runtime monitoring is 0TCT_MC01 which contain aggregated information on query runtime. InfoProvider 0TCT_MC02 gives detailed statistics of query runtime where as 0TCT_MC03 is used for query performance tuning at data manager level.
SAP


Data Load Statistics
This gives an overview of length of the load process and process chain, as well as length of number of data records from InfoPackages and data transfer process.
0TCT_MC21 contain Process (Chain) statistics.
0TCT_MC22 contains DTP statistics.
0TCT_MC23 contains InfoPackage statistics.


Data Load Status
This feature gives following information
Process Status
Process chain Status
Process Status
Process Type Selection


BI Object Request Status
Infocube Status
DataStore Object Status
Master Data Status
PSA data Status

InfoProvider Request Status
Infocube Correctness
Aggregate Rollup
DataStore Object Correctness
DataStore Object Activation
In technical content 0TCT_MC11 InfoProvider collects Object Request Status and 0TCT_MC12 contains Process Status
All these feature help us for ‘Easy administration for complex Enterprise Data Warehouses’. These are important to someone like me who is on production support project as valuable time can be given to the trouble shooting activity.