Hi Experts,
Is there any kind of restriction for Composite Providers not allowed to have classical DSOs as a source of data ? I have checked help.sap.com, all pre-requisites it mentions are:
1. Only Cumulative fields
2. SID ID generations should be checked.
I am trying to build a composite provider on top of Billing Items DSO and Billing Conditions DSO. For both the DSOs the key fields are cumulative and SID generation is active during reporting.
When i build the join condition and composite provider through BWMT i get the error Billing Items DSO is not allowed.
I am on BW 7.4 SP15 and SAP HANA 1.0 SP12
Thanks for your help.
I was able to resolve the issue. The SID Generation setting needs to be changed to "During Activation" instead of "During Reporting".
I used only advanced DSO with SID generation [Activate data option selected] in composite provider. Are you sure, we can use classic DSO in Composite provider ?