Using Constant Selection for MultiProviders

Using constant selection, you can resolve problems with MultiProviders.

Example 1: The MultiProvider has an InfoCube with the actual values and an InfoCube with the plan values. If the calendar month characteristic is contained in the plan InfoCube but not in the actual InfoCube, then if you drilldown by calendar month, all the data under the initial value # (not assigned) is displayed. You can define a constant selection for calendar month= # (not assigned). This means you select the year plan value as a constant - regardless of the filter. The value is displayed in every row (in other words, for every month). You can now divide the year plan value by 12. This means you can perform a plan-actual comparison for individual calendar months, even though the plan InfoCube only contains year values.

Example 2: The MultiProvider has two InfoCubes with data on price and quantity for various products and the corresponding sites. InfoCube 2 also contains the characteristic Customer. Therefore, if you drilldown by customer, all the data from InfoCube 1 under the initial value # (not assigned) is displayed. This example is explained in more detail in the next section.

The characteristic Customer is contained in InfoCube 2 but not in InfoCube 1. Therefore, when you drilldown by Customer, all the data from InfoCube 1 under the initial value # (not assigned) is displayed. The query on the MultiProvider would look like this: