Skip to Content
0
Former Member
Sep 22, 2005 at 12:34 AM

Follow-up 1: Hmm! An issue ... u0093How to handle Forecasting when modeling

28 Views

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)