Skip to Content
0
Former Member
Sep 21, 2005 at 02:21 AM

Hmm! An issue with the response to u0093How to handle Forecasting when modeling

17 Views

1. It was concluded that “if you have huge amount of data having several cubes may serve as a kind of physical partitioning - improved performance.”

2. The other option was “Or you can insert into the same cube a new characteristic, kind of KF type and set different values for actual, plan, forecasted data.“

..but this “… approach has a disadvantage – needs a multiprovider, more DB space because of redundant storage of characteristics in the similar cubes.”

Well, my concern now is on 2 above, if you combine the Cubes into a multiprovider, aren’t you defeating the advantage of the separation (like partition) which would lead to an improved performance?

Thanks