Maximum number of Infoproviders and Infoobjects in HCPR

[former_member202517]

Dear Experts,

Currently I am facing issue with queries on Composite Provider. Its a new HCPR which contains 94 HANA Optimized Cubes. (BW on HANA)

I have performed a check in RSRV and I am getting the below error message.

Is there any limitation in the number of Infoproviders that can be added to HCPR.

Also is there any limitation in the no of elements in a Query?

one more issue which i am facing is Query contains 2 structures and KF Structure contains only 1 Direct KF and the other structure contains 2 selections rows with selection on infoprovider only. but there is no data coming. but with only 1 selection row its displaying data

I am able to see the data of HCPR by displaying the data.

where as we have a Multiprovider with same cubes but its displaying the data in query.

Request you to please share your thoughts to over come this issue.

Thanks,

[former_member202517 · Accepted solution]

Dear martin.maruskin2 , gaurav_bansal,

Thank you for sharing your views.

We have raised an SAP Ticket and SAP have provided us the below note which fixed the issue.

3046770 - Query on a HCPR returns no data back

Thanks.

[former_member688242]

Please check the following:

1. Review KBA 2118286 for the impact of this issue on performance and memory consumption

2. check the number of free characteristic present in Query.Screen Shot shared above

3. Try query pruning to limit number of underlying info provider related to Query

4. Assuming HPCR is activated try to preview the data if it gives error

5. Use 0Infoprovider to restrict data to one info provider

This will help to take further steps

[MartinMaruskin]

Hi Jagadeep,

I do not think there is a "hard" limit of number of objects that can be included in HCPR (CompProv). However you need to look at this from performance point of view. More objects are in HCPR slower the query will run on to of it. That;s why RSRT reports you it a error/warning. See below links:

Limit on cubes per multiprovider ?

629541 - Multiprovider: Parallel Processing