SAP BW/4HANA, SAP HANA

Implementing Mixed Modeling in BW4HANA Using Composite Provider

Back Ground :

A Composite Provider is an Info Provider, which combines data from several analytic indexes or from other Info Providers (by Join or Union), and makes this data available for reporting and analysis. UNION and JOIN operations are executed in HANA and not the application server.

The main advantage of Composite providers is that: BW Info Providers can be combined using the JOIN operation allowing us to create new scenarios not possible or very expensive with standard techniques. When we hear the word Union, what strikes our mind immediately is a Multi provider. SAP still suggests the usage of Multi provider in case your requirement is just to use Unions. This is because the OLAP engine is well suited for this operation.

Composite providers however can be used on top of Multi providers to execute Join operations with Multi provider as one of the data providers. This gives us additional flexibility and even one additional level of modeling thus allowing us to create new scenarios that were not possible before.

Implementation Scenario :

While implementing the below steps I have follow the below steps –

1. Login to SAP HANA studio on main car.

SAP BW/4HANA, SAP HANA

2. Click on window->perspective->reset perspective – and then click on “Yes”

SAP BW/4HANA, SAP HANA

3. Click on open perspective icon

SAP BW/4HANA, SAP HANA

4. Click on BW Modeling and click on ok.

SAP BW/4HANA, SAP HANA

5.Right click on the free space ->new ->project –

SAP BW/4HANA, SAP HANA

6. Select BW Project and click next –

SAP BW/4HANA, SAP HANA

7. The Double click on “BW4HANA” and then click on next the login credential will be appeared .Provide username and password.-

SAP BW/4HANA, SAP HANA

8. We can see that the project has been created . Then will will add attach HANA System by right click on “Attach HANA Systems ” –

SAP BW/4HANA, SAP HANA

9. Right click on repository ->new ->infoarea ->

SAP BW/4HANA, SAP HANA

10. Provide name and description and click on finish to create an infoarea –

SAP BW/4HANA, SAP HANA

11. Go to Data sources -> ODP-SAP -> EHP7 -> SAP -> SAP application components<-sales and distibution ->sales master data ->double click on sales organisation (0SALESORG_ATTR (EHP7)

SAP BW/4HANA, SAP HANA

12. Right click on sales organisation data source –

SAP BW/4HANA, SAP HANA

13. Click on explore data flow –

SAP BW/4HANA, SAP HANA

14. Drag and drop open ODS view onto workspace –

SAP BW/4HANA, SAP HANA

15. Join a link between sales organisation and newnode1 –

SAP BW/4HANA, SAP HANA

16. Rearrange the flow and rename the node noewnode1. After Giving the name, select master data at semantics, select data source (BW) as source type and click on next –

SAP BW/4HANA, SAP HANA

17. Select the object shown and click on finish.Then click on master data.Then we can view the source fields and characteristics and key figures –

SAP BW/4HANA, SAP HANA

18. After clicking on the activate BW objects we can see that we can see that the object has been created –

SAP BW/4HANA, SAP HANA

19. Right click on SALESPERSON and click on explore data flow . The design pane will be open . Then right click on SALESORG1 and click open –

SAP BW/4HANA, SAP HANA

20. Click on data preview<-analytics list UIBB and query panel opens up.Now, we can view the output data using query panel.

SAP BW/4HANA, SAP HANA

21. Right click on the same infoarea (IA_MAY5) -> select composite provider.Provide the name and description for composite provider and click on finish.

SAP BW/4HANA, SAP HANA

22. Click on checkbox of External SAP HANA View<-click on scenario.Then Right click on table ->select join with –

SAP BW/4HANA, SAP HANA

23. Search for SALESORG1 object and Drag and drop the object at the union . Then we can see the source table –

SAP BW/4HANA, SAP HANA

24. Now go to Data sources ->ODP-SAP -> EHP7 – >SAP ->SAP Application components -> sales and distribution ->sales master data ->sales document header data.

Then Right click on sales document header ->click on “Explore data flow” and Drag and drop open ODS View onto the workspace.

SAP BW/4HANA, SAP HANA

25. Link join between sales documentation and new node and arrange the nodes in a proper manner –

SAP BW/4HANA, SAP HANA

26. Provide details and click on next –

SAP BW/4HANA, SAP HANA

27.Select the object that is shown below and click on finish.

28. Go back to the composite provider and drag and drop salesheader1 onto the union –

SAP BW/4HANA, SAP HANA

29. On drag and drop of salesheader1 onto union, we see that it adds to the source –

SAP BW/4HANA, SAP HANA

30. Right click on salesorg1 and click on create assignments for individual attributes one by one –

SAP BW/4HANA, SAP HANA

31. Click on check for BW Objects and then click on activate BW Object –

SAP BW/4HANA, SAP HANA

32. Do the data preview: click on Analytics List SQUIBB to check the data.

SAP BW/4HANA, SAP HANA

Now the implementation is complete.

Leave a Reply

Your email address will not be published. Required fields are marked *