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...
You can set this indicator, if you want to upload a file containing realignment steps from
the application server. A field then appears in which you enter the file name.
(more or like an SAP directory using al11 tables)
If you want to upload a file from your PC, enter the relaignement table and choose
Utilities > Import File.
R. Senthil mareeswaran