Any comment on my Summary:
-
My understanding is that, in dealing with forecasting during modeling
a) One approach will be to create a new Cube, infobjects for Forecast data in addition to the cube for the actual data. That makes it 2 Cubes.
Advantage:
if you have huge amount of data having several cubes may serve as a kind of physical partitioning - improved performance.
Disadvantage
To compare the data in the actual and forecast, the two Cubes will have to be united with a Multiprovider; more DB space because of redundant storage of characteristics in the similar cubes.
b ) a Second solution will be to keep to a single Cube, i.e combine the actual and forecast, and differentiate the actual and forecast with a new characteristic (like 0Version) and set different values for actual, plan, forecasted data.
(By the way, will we have to create a new dimension for this additional characteristic)?
1
Not very sure of this message So Use the logical partition by Multi provider concept -- By "multi provider", is it referring to b) (above) or on a different subject and referring to partitioning the single cube in a)