You are using an SAP HANA database or a SAP BW Accelerator.
You have already created one or more analytic indexes, either in APD or by publishing SAP HANA models in BW. More information: Creating TransientProviders on SAP HANA Models
A CompositeProvider is an InfoProvider, which combines data from several analytic indexes or from other InfoProviders (by Join or Union), and makes this data available for reporting and analysis.
A CompositeProvider created in the Analysis Process Designer can only contain analytic indexes.
Find the analytic index that you want to use in the CompositeProvider. Drag and drop it onto the modeling area.
The maximum length of the field names is 10 characters. If they are longer, the system assigns the name F001, F002 and so on. If a field name already exists, a Fnnn name is assigned. The descriptions are always taken over from the original field.
To do this, choose Constant from... from the context menu for a field that is not connected with all union indexes.
An analytic index 1 contains the Country field, whereas an analytic index 2 only contains data for Germany, without the Country field. To be able to connect all fields correctly by union, the Country field must be linked from both analytic indexes.
In the CompositeProvider, set the constant for Country to DE (Germany). This means that the field in the CompositeProvider from analytic index 2 is always filled with Germany.