In a CompositeProvider, you can combine all the data that you want to view in your query. You can use all central BW InfoProvider that have a BWA index (InfoCubes, InfoObjects as InfoProviders, analytic indexes, VirtualProviders, queries as InfoProviders etc.) and are assigned to the workspace as data providers, as well as your own data (in the form of uploaded Microsoft Excel/CSV files, uploaded query results or uploaded data from DataSources). If you are using an SAP HANA database, you can also use DataStore objects that SID generation has been activated for.
For information about the graphical view, see: Graphical View
If the table is too large, and the headings are no longer legible, you can modify the display: Open the context menu in the table preview and choose User Settings More… . You can hide columns and restrict the number of rows (the rest is displayed using a scrollbar).
More information: Union / Inner Join / Left Outer Join
For fields that are not assigned, not assigned is displayed in the Field of CompositeProvider column. In this column, you can select a suitable CompositeProvider field from the drop-down list box. If you have selected a field, the assignment is displayed immediately in the graphical view below. The provider to be joined is displayed on the left, and the CompositeProvider on the right.
If you do not want to assigned a field but still want to add it to the CompositeProvider, choose Standalone Field.
Once you have made all required assignments, press Apply.
More information: Extended Checks
Cut left (LEFTSTR)
Cut right (RIGHTSTR)
Cut middle (MIDSTR)
Fill left (LPAD)
Fill right (RPAD)
Concatenate
If you choose concatenate, you can also define a constant. To do this, just enter one character string and leave the second one empty.
During the calculation, note the differences between the internal and external display. More information: External and Internal Display of Characteristic Values
Once you have selected a calculation, the parameters for the calculation are displayed together with an example. Enter the parameters and press OK. Select the calculated characteristic to use. This will be added to the list of CompositeProvider fields. Choose Return to CompositeProvider Modeling.
Further information about key figure multiplication: Union / Inner Join / Left Outer Join
Standard: All fields in the CompositeProvider are added to the query as free characteristics or key figures. This query cannot be changed in BEx Query Designer. It changes automatically when the CompositeProvider is changed.
If calculated or restricted key figures have already been defined on one of the InfoProviders that belongs to the CompositeProvider, you can select this InfoProvider when defining the standard query.
Reference: Select a BEx query that you want to reference. A referenced query can be any query based on the assigned MultiProvider or one of the InfoProviders being used. As soon as an InfoProvider is used in the CompositeProvider that is contained in the assigned MultiProvider, it is only possible to select queries that are based on the MultiProvider.
Changes to the referenced query have an immediate effect on the transient query. The referenced query can only contain fields that are also contained in the CompositeProvider however. If it contains other characteristics in the free characteristics, these are removed in the reference query.
This allows you to use calculated key figures from the referenced query for example.
Choose Continue.