Operational Data Provisioning and Step by Step Activation Procedure for ODP Objects
Operational Data Provisioning is a technical architecture included in Latest SAP ECC systems to enable additional options in reporting.
They are,
· 1. Analytical reporting in application system itself. It consists of ODPs, BEx reports and Dashboard templates. It comes under Search and Analytics package. By activating this feature the reporting is possible in Application system (ECC).
· 2. The traditional BW - LO cockpit data sources are enhanced with direct data access. These DataSources can be replicated into SAP BW system. The setup tables has became obsolete for these data sources, so direct access is possible in query runtime.
The picture illustrates how data sources, operational data providers and analytic queries are related in the context of operational analytics architecture in the SAP EHP for SAP Netweaver 7
The ODP exposes transactional and master data including the associations to the analytic queries.
The analytic engine interprets the analytic query and exposes the result to the analytic clients.
Data is retrieved either directly from the data base via data sources or read from BWA
The configuration of operation data provisioning is done via SAP Customizing Implementation Guide (IMG). In the IMG you can activate individual standard applications and industry solutions in your ABAP-based SAP system. These applications and solutions are known as Business Function Sets and Business Functions.
The IMG structure for Search and Operational Analytics includes settings for the following use cases:
Steps
1. Run transaction SPRO
2. Click on SAP Reference IMG
4. Common settings for Operational analytics and embedded search
5. Configuring settings for Operational Analytics
After completing the SPRO setting the related DataSources needs to be activated.
To do this,
The corresponding Business functions should be activated in T-code: SFW5.
T code – RSRTS_ODP_DIS is to display the Transient providers. Before installing an ODP object it will be available in Modeled version.
When you execute it, you will get the components of the object.
It’s divided into key part, Data part, Unit and Keyfigures.
If the object is not installed then those won’t be available in F4 help of the ODP Name.
The ODP objects can be installed by two options. One is through BI content activation workbench and another is through transaction RSOR.
Activation through BI content activation workbench
For more details: http://help.sap.com/erp2005_ehp_05/helpdata/en/b6/b67adca9144852aff187a4e15426dd/frameset.htm
In the above picture the MM analytics is activated. To activate other function select the row and click on activate button. This will open a window as below.
In this window select the RFC destination, Data replication properties and effects on already active objects. While installing objects, it can be written to a transport request.
Activation through RSOR transaction
1. 1. Goto RSOR transaction. In the cases of ODP reports, we know the name of query better than the Data providers, so search for the query that you want to activate.
1. 2. In the object collection pane, choose collection mode as ‘Collect automatically’ and grouping as ‘Data Flow before’
2. 3. Select the required report and transfer the selection to object collection window.
1. 4. After collecting check whether the entire required object were collected or not.
5. Then simulate the installation. If the simulation ends without any errors proceed installing.
If an object is installed then that will be available in F4 help of the ODP name as below.
And when you execute you will get components, which constitute that ODP object.
Now the Queries will be available for reporting
The Activated report will be available as dashboards in SAP Business client.
Note: The reports can be directly accessed from RSRT Transaction and can be edited using BEx Query designer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |