Enhance CompositeProvider with SAP HANA View
Business Example
Your finance department wants to analyze the further cost center transaction and master
data from affiliated companies that was loaded to the SAP HANA database, together with the
existing BW data.
Note:
To complete this exercise, you need the objects that you created when you
completed the Create Calculation Views Using SAP HANA Modeling exercise
1. Prepare your ZCPU CompositeProvider that it can be added to another CompositeProvider.
a) In the HANA Studio, switch to the BW Modeling perspective.
b) Navigate to your InfoArea and expand the folders structure
CompositeProvider → ZCPU. From the context menu choose Open.
c) On the General tab, select the This CompositeProvider can be added to another CompositeProvider checkbox .
d) Choose Activate BW Object.
2. Create a new CompositeProvider Composite in Composite (ZCICPU).
a) Navigate to your InfoArea. Open the context menu and choose
New → CompositeProvider, enter the name ZCICPU and description ZComposite in Composite.
b) Choose Finish.
3. Add and combine your CompositeProvider ZCPU and SAP HANA Calculation View ZCVSTAR_TD01.
a) To open the modeling environment, choose the Scenario tab.
b) In the left view of the Scenario tab, choose the Union item.
c) Choose the Add button.
d) Search for your CompositeProvider ZCPU, choose OK.
e) Choose the Add button and select the Search Scope SAP HANA View.
f) Search for your Calculation View ZCVSTAR_TD01, choose OK.
4. Create the field assignments for the ZCPU CompositeProvider

a) In the right Graphical view of theScenario tab, in the Source, highlight the
CompositeProvider ZCPU entry and drag and drop it to the Target.
b) In the Graphical view, drag the fields from Calculation View ZCVSTAR_TD01 of the
Source on the corresponding Target fields, to create the field assignments as shown in
the table.
c) Choose Activate BW Object.
5. Go to Data Preview → Reporting Preview to display the Currency and Z Cost Center
InfoProvider, in rows in SAP HANA Studio with a data preview.
a) In the ZCICPU CompositeProvider view, choose Data Preview → Reporting Preview
in top right corner.
b) Move the InfoObjects InfoProvider, Currency and ZCost Centerfrom Free to Rows
to perform a drill down.
