Skip to Content
0
Former Member
May 27, 2010 at 09:02 AM

Realignment on Info cube

47 Views

Hi Experts,

I need your suggestion to reduce time to realign Info cube. I am explaining in detail...

Due to customer requirement we are creating one Snapshot cube where we are extracting 13 month data for each snapshot day i.e. once in month. Customer want some reporting on this data.

Now we have 12 snapshot data in snapshot cube i.e. 12 X 13 = 156 months data & we have almost 200K CVCs.

Now before start of forecasting cycle we need to realign the snapshot cube data & for that we are having 1000-1500 steps in realignment every month. So it takes more than 3 days to perform realignment on cube & due to this report is getting delayed.

Can anyone suggest an appropriate method to reduce time to realign cube?

Thanks in Advance...

Regards

Sujay Joshi