Export ASO and BSO outlines out of EPBCS application for use in on-prem Essbase 21c
Summary:
Export ASO and BSO outlines out of EPBCS application for use in on-prem Essbase 21c
We have an archiving requirement where we want to export all of the ASO and BSO cube outlines, and all of their data, from our EPBCS application so that we can build just the Essbase cubes in our Essbase 21c museum. In legacy Planning, this was relatively easy, but, without direct access to the back end Essbase server associated with our EPBCS application, we're trying to figure out how to accomplish this.
I have opened our PBCS snapshot file and was able to extract the ASO otl file from it, as a test. However, what I am finding is that not all member formulas are retained in that outline and it seems that some data storage attributes aren't retained as they appear within the PBCS Dimension editor. Most notably in our Account dimension.