fss bw operations- prc4 fullload
Post on 08-Aug-2018
223 Views
Preview:
TRANSCRIPT
-
8/22/2019 FSS BW Operations- PRC4 Fullload
1/10
PROCEDURE FOR PRC4 FULL LOADS
Document Version / Dtails : Ver 1.0 / 15-APR-11
Record of Release
VersionNo.
Created / Modified By Reviewed By Release Date Modifications Done
1.0 Kishore Kumar Challa Kush Kashyap,Venkat RamanaReddy,pawan KumarChaturvedi
15/04/2011
Project ID: Project Name: FSS BW Operation
-
8/22/2019 FSS BW Operations- PRC4 Fullload
2/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 2 of 10
Scope of Document: This document helps us to do the PRC4 FULL LOAD
History: This is a type of Business transaction for which we do full loads on specific work daysWe will perform on WD4, 5, 6, 7 and 13
Cube: GLRCC001
DSO: GWFDPC01
Data Source: 0EC_PCA_1 (Profit center transaction data)
R/3 side source system: G4P470
Date from R/3 source system is loaded to PSA of the BW data source with the help of infopackage.
With the help of transformations and DTP data is transferred from BW data source to DSO.
With the help of transformations and DTP data is brought to the cube from the DSO.
AGGREGATES:
Aggregates are built on the cube for the faster retrieval of data during the reporting process.
Rollup is done to get the new loads to be loaded into the aggregates.
Procedure for doing the PRC4 full load:
Step1: Go to RSA1 transaction in the BW system.
Step2: Find the cube GLRCC001 with the help of FIND button.
Step3: Deactivation of Aggregates
This can be done by right clicking on the cube and finding the option: MAINTAINAGGREGATES
-
8/22/2019 FSS BW Operations- PRC4 Fullload
3/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 3 of 10
Select the aggregate and deactivate it by pressing on the deactivate button.
Then the following window will come
Click on yes.
The status of aggregates will be red
In this way aggregates are deactivated.
Step4: click on the manage button of the cube
-
8/22/2019 FSS BW Operations- PRC4 Fullload
4/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 4 of 10
In the requests tab you will be finding the requests to cube for loading of the data.
Delete the request which is a full load request from the requests.
This can done by selecting the respective request and clicking on the delete button.
Step5: Activate the aggregates.
Go back to the cube and right click->maintain aggregates->select->and click on activatebutton
The follow window will appear.
Click on the start.
The status of aggregates will be green
In this way the aggregates are activated.
-
8/22/2019 FSS BW Operations- PRC4 Fullload
5/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 5 of 10
Step6: now go for the DSO GWFDPCO1 with the help of find button.
Step7: Do the selective deletions in the DSO (previous month & PRC4 & G4P470)
-
8/22/2019 FSS BW Operations- PRC4 Fullload
6/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 6 of 10
Step8: This can be done by clicking the following path
Manage->contents->selective->selection deletion
We will do deletion selections for
Business transaction type: PRC4
Fiscal period: Previous month (according to P&G calendar it is 10th month we will do for09/2011)
Source system: G4P470
-
8/22/2019 FSS BW Operations- PRC4 Fullload
7/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 7 of 10
Step9: Drilldown the DTP below of the DSO
There we can find the DTP running between the DSO and data source 0EC_PCA_1
There u can find that an info package is running between 0EC_PCA_1 and G4P470 sourcesystem.
ZPAK_4CFJWH326VZ6PCYEP69AASLPX
If we click on the info package it will show in the update tab that it is a full load
Click on the schedule and tab and start the info package.
This helps in loading the data from source system to PSA of the data source
-
8/22/2019 FSS BW Operations- PRC4 Fullload
8/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 8 of 10
Step10: click onto DTP_4D9TCHBLWTDRBB8UR6EAY2RBA which is loading the data from the datasource to the DSO
Execute the DTP by clicking on the execute button in the execute tab of the DTP
Step11:
Come to cube and drill down for the DTP DTP_4D82I8BGIUJFPN6T6WH664UIV which is loading datafrom DSO to cube and execute the DTP by pressing execute in the execute tab.
-
8/22/2019 FSS BW Operations- PRC4 Fullload
9/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 9 of 10
Step 12: Rollup the cube so that the aggregates will receive the new data loads.
We will find the rollup tab in the manage option of the cube
And provide the request id which is getting the full load and press the execute button (13)
In this way PRC4 full loads are done.
-
8/22/2019 FSS BW Operations- PRC4 Fullload
10/10
Document Title:PROCEDURE FOR PRC4 FULLLOADS
PM-03-04
Ver 1.0/04-FEB-11
Page 10 of 10
top related