BPC 10.1 Embedded - No data records found for distribution

[raghuvara_bhat]

Hi,

We have bult an input ready query on Aggr. Level and this Aggr. level is on a Multiprovider which has a RT cube and another non RT cube.

The Aggr. Level doesnt contain all the fields from RT Cube as it is created based on the level at which user will plan.  The issue we are facing is (while testing in RSRT as well as Analysis Office 2.2) -

a. KFs in the plan query are NOT turning input enabled if "No Disaggregation" is selected from Planning properties.

b. KFs will be planning enabled if other properties are selected in "Planning" property; however, we face an error message "No data records found for distribution" while Recalculation or Saving the data.

Please let me if anything could be changed in query or data model which will mitigate the issue.

Regards,

Raghu

[gregor_dieckmann · Accepted solution]

Hi Raghu,

a. is a feature. I suggest that you read the documentation when a structure element configures in the query designer can be input-ready at run time of the query, cf.

Input-Ready Queries at Runtime - Using the SAP HANA Database - SAP Library

b. Disaggregation is the 'inversion' of aggregation, so obviously the system has to read all records that contribute to the aggregated value to do the distribution. The message just says that no records were found to do the disaggregation. So you have to set up the data model and the query in such a way that all records needed for disaggregation exist. Check note 994853 (attached PDF document) for very detailed information about how disaggregation works.

Regards,

Gregor