Epcm cube exports: best method (archiving)

Summary:

For archiving purposes, we are looking for the best method to get cube data into a txt file.

Content (please ensure you mask any confidential information):

The general request from the client was to be able to go back 10 years into unrestated data, ideally via an "live" ad-hoc analysis via Smartview.

We considered following options but found some challenges:

• EPCM: 35 of the possible 40 attribute dimensions are already in use for the current year model, so supporting sufficient dimensionality changes from year to year is not possible. So using the other free ASO cubes inside EPCM do not seem to be the answer here.