Exporting the EPMA Shared Library with the EPMA File Generator
You might want to export the EPMA Shared Library for backup purposes or to make bulk changes to the library using the ADS file.
One thing I have noticed is that many Hyperion practitioners are comfortable exporting an application library but are sometimes confused when it comes to export the Shared Library.
The EPMA File Generator documentation (here) is a bit confusing: Oracle takes an example with an application named EPMA_1 and they add an very very important note:
So let’s try it:
First of all, make sure services are running and that you have the EPMA File Generator installed on your machine. Most of the time, the EPMA File Generator is installed on the server where EPMA is running and if you don’t have access to the server, you can download the EPMA File Generator client here.
Note that the EPMA file generator is now separated from the server installation and is now part of the ‘Clients installers’.
Open the EPMA File Generator, chances are you will find it under ‘ Start / Oracle EPM System / Performance Management Architect Client / Start EPMA File Generator ‘:
This will open this lovely EPMA File Generator window:
Go directly to the tab: From EPMA Application
The User Name must be provisioned with EPMA with the Dimension Editor and Application Creator Role at minima:
the URL for the EPMA Web service is your EPMA Server followed by /hyperion-bpma-server. In our case, it is localhost.
Enter MASTER for the EPMA Application name, yes, MASTER.
The EPMA Import File is an .ads file that will be generated by the EPMA File Generator, you will be able to modify and re-import the file. In our case, we save the file to C:Temp
You can add a dimension prefix but unless you have some very specific needs, you won’t need it.
The option to save metadata file is selected by default but you won’t need it unless you need to troubleshoot EPMA (this option will generate the xml file create by EPMA, actually, EPMA will transform the xml file in ADS in the process).
Enter the EPMA Web Services URL and you should get something that looks like this:
Click Execute and you should see the status nicely updated:
and you will find your ads file under the folder you selected earlier:
easy, isn’t it?