Oh my, it has been a while since my last post .. and feel that there may be more than one in addition to this one.

So recently I was working with a Planning application that SPARC’ed me to write this post 😉

Not sure how many know, but in version 11.1.2.4 there was change made to the MaxL grammar that now allows for the export of data to be made anonymous!

The MaxL export data statement includes grammar you can use to make exported data anonymous, wherein real data is replaced with generated values. This removes the risk of sensitive data disclosure, and can be used in case a model needs to be provided to technical support for reproduction of certain issues.

Here is the 11.1.2.4 Technical reference: link

ASO/BSO keyword:
export database … data anonymous

Description: Export data in anonymized format. Anonymization removes the risk of sensitive data disclosure, and can be used in case sample data needs to be provided for technical support. Essbase replaces real data values with 1, for each value in the block.

These are the railroad diagram for each ASO & BSO, and enjoy exporting data for analysis, support, performance testing, etc.