Hello, dear experts
I am looking for good advice.
We use cube RT_c01 for collecting info from material movements. This cube is used for getting current stock figures as well. Unfortunately this cube is growing to quickly - more then 1.000.000 records per year.
To improve performance we would like to create new cube to collect data for next financial year. The questions are:
- will be possible to have a multi cube be able to compare figures for both years
- should we do stock initialization for new cube
- how about compresions
- any other sugestion
~85% reports are running for current year and only rest 15% collecting data from old cube (select, compare, etc)
Many thanks in advance