Context
In a CompositeProvider, you
can combine all the data that you want to view in your query. You can use all
central BW InfoProviders assigned to the workspace as data providers, as well
as your own data assigned to the workspace as local providers.
- Insert the query that you want to
enhance with a local provider.
The query must belong to the
same workspace as the local provider.
- Select a cell of crosstab.
- Choose
or
in the
Data Source
group.
Note If you want to add measure data to a
query, we recommend adding it as data records.
The
Define Composite
Provider Settings dialog appears.
- Select a local provider from the
list.
You can specify whether the
local providers for all dimensions in the query should be listed, or jus for
one dimension that you select in the drop down list.
If you select a local
provider, the data source details are displayed.
- Press
Next.
In the
Details
dialog, you can enter a description and technical name for the new
CompositeProvider and the new data source (composite provider query).
The technical name of the
composite provider has the same predefined prefix as the local provider. The
technical name of the composite provider query starts with the predefined
prefix containing the elements $ and the workspace prefix.
If you add a local provider
to a composite provider, you cannot change the descriptions and technical
names. These can only be assigned when the first local provider is added to a
query.
- Press
Next.
In the
Target
Location dialog, you can specify whether the CompositeProvider
should be inserted into the current workbook sheet or a new one. You can also
specify that it should not inserted into a sheet.
- Press
OK to
create the CompositeProvider.