Cold data to be archived in cube?

[former_member197527]

Hello,

I have a MP with 2 cubes. One cube has got data from 2011. Am on 7.3 BW

Now I need to archive the old data before 2016 April 1st. Query also need to see only new data.

Can I consider partitioning the current cube or SPO on existing cubes? Technically possible? If so, what's the impact on MP?

Or should i create another cube for data before april 2016 and load new data to the current cube?

Which one is better with faster and accurate results? Kindly suggest

[Former Member]

The best way will be to use NLS for cold data. You can also access the data in reports if required from NLS.

regards,

Anupama

[former_member197527]

I thought of it as well but wasn't sure of how to correlate my requirement. Can you pls suggest

[Former Member]

If you already have NLS in place then you can create a 'Data Archival Process' and schedule a daily load to the NLS. This will move the extra data from your cube, keeping just the required data, in your case the fiscal year's data.

regards,

Anupama

[former_member197527]

Thanks for the update. We dont have an NLS as of now. pls guide on this w,r.to triggering

[Amit_Tewatia]

check the url below for SAP NLS first guidance:

Regards,

Amit T