cancel
Showing results for 
Search instead for 
Did you mean: 

Virtual Provider or Composite Provider

Saurabh_Tiwari
Employee
Employee
0 Kudos

Hi,

I have created a HANA view (SPS10), and want to use the same in BW (SP05) for BEx reporting.

Option 1:

Create a virtual provider on HANA calc view --> assign to a Multiprovider --> create BEx queries

Pros: Info object navigational attributes can be used in BEx

Cons: BEx variables can not be mapped to HANA calc view input parameters, to fetch only selected data.

Option 2:

Create a Composite provider on HANA calc view --> create BEx queries

Pros: less number of layers as composite provider and BEx reports only

Cons: Navigational attributes can not be used.

Question 1-

What would be suggested - Virtual provider or Composite provider

In help.sap.com it is also recommended to use composite for better performance With SAP BW 7.4 SPS5 and higher.

Creating VirtualProviders Based on an SAP HANA Model - Modeling - SAP Library


Question 2-

In case of virtual provider, how variables can be mapped to input parameter.


Question 3-

Any better way for better performance. HANA has huge amount of data (around 20 mio records)


Thanks

Saurabh

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member194957
Active Participant
0 Kudos

Hi Saurabh,

             Better go for Hana Composite Provider, it nows supports the use of navigational attributes.

Regards,

Tharun

former_member197527
Active Participant
0 Kudos

Hi Tharun,

I heard the nav attr not possible in queries on composite provider. Can u pls confirm if this is rgt? is it not possible on BW 7.4?

former_member194957
Active Participant
0 Kudos

Hi Aditya,

                 Yes it is possible on BW 7.4 on HCPR.While creating the scenario of UNION or JOIN on HCPR , you can add the nav attributes. You can do this in the output tab in the HCPR wizard and right click on the Infoobject having nav attributes , check the nav attributes that are required.

Later you can create a Query on the HCPR . However you cannot see the nav attributes directly visible in the output until you perform a drill down operation on the corresponding infoobject having nav attrib.

Regards

Tharun