Now that Oracle Enterprise Data Management Cloud Service (EDMCS) has been officially released, I wanted to re-iterate that at this time, these are the only EPM Automate commands that are available (18.01):
You’ll notice that there are no commands available for any EDMCS processing of any kind: imports/exports/committing requests, etc. This means that all processing and application maintenance will need to be done by a user at this time.
Things that you can automate and schedule: backups, restores, moving files in and out of the application inbox/outbox, logging in and out, generating provisioning reports, and sending feedback.
The EPM Automate functions available for all Oracle EPM Cloud products can be found here.
Are you interested in EDMCS? Let me know your thoughts or questions by sending me a note to hyperionbarbie@gmail.com. And check out my intro to EDMCS here!
oraclebarbie.com 
Hi Kate,
Could you please brief me about the use of copysnapshot, importsnapshot and exportsnapshot? I mean when do we require of this.
Regards,
Swapna
Hi Swapna,
The copysnapshot, importsnapshot, and and exportsnapshot are all commands that are used for all Oracle EPM Cloud products (PBCS, EPBCS, FCCS, ARCS, PCMCS, etc.). It is a way to manage the application objects for backup locally to a server. Typically, in addition to the Oracle maintenance window, we set up a nightly backup of the application, using “exportsnapshot” and save it.
You can also automate loading the snapshot back into the application if you wanted to clear and create a new one, or copying it. These snapshots also come in handy for migration purposes from TEST to PROD, or vice versa.
The descriptions and more information can be found in the EPM Automate documentation: https://docs.oracle.com/cloud/latest/epm-common/CEPMA/toc.htmv
Remember, these commands can be used for any Oracle EPM Cloud application, not just EDMCS.
Hi Kate,
Could you please assist me on the below query,
A member in DRM can act as child and parent in two different target systems ?.
Suppose I have member called A1234 and this member should be a child in one target system and same member should be a parent member in other target .
Do we need to create alternate hier or is there any other process to achieve this.
Please let me know your updates..
Hi di,
My thought on this is to build the tree in DRM with the most levels needed for all systems (so the level below A1234 should be included). Typically, the way we filter out the data is by usage of Membership properties, which can be either defined by a user or use some type of logic to derive. Typically, Membership would consist of “Base Member” “Parent Member” and “Not Applicable” options. I usually create a Membership property for each end system, so you can have one target system with A1234 marked as a Parent and its children marked as “Base Member” but in another target system, A1234 can be marked as “Base Member”. A1234’s children would be marked as “Not Applicable”
Then, create a global query that filters out any Membership that is “Not Applicable” and attach it on the Filter tab of the Export.
Where it does become a little hairy is if you have different Data Storage type properties depending on target system. If this happens, I would recommend also having Data Storage be based off of membership; since a lot of times parent values in the Account dimension should be marked as “Dynamic Calc” vs. “Store” to increase performance.
Hope this helps,
-Kate
Hi Kate,
I would like to automate the export process. For instance, in EPBCS, FCCS , PBCS where we create jobs in the outbox and run them through epmautomate exportmetadata command, whereas in EDMCS , I could not see any job concept here. So could you please tell me how can we automate export metadata from EDMCS.
Thanks!
Hi Sam, great question! EDMCS currently does not have epmautomate commands for exports – it is on the roadmap for November. Im currently having my clients that have multiple cloud application and EDMCS do manual pulls until we can use epmautomate.
There is scripting available if you use the REST API and other tools (like curl), but these would be custom and much larger level of effort.
Hope this helps!
Thanks Kate!
Hi Kate, is there any update on EPM Automate commands to Export Metadata from EDMCS as of today?
Hi,
No there are still no new epmautomate functions for EDMCS at this time. REST API would need to be used for exporting metadata.
Hi,
As I’m very new for EDMCS, My concern is that how we connect to different systems LIKE EDMCS and EPBCS, or EDMCS and FCCS. I got proper metadata file which is fine for different Systems but i want to connect it automatically is it possible ??
Hi Abhishek,
I’m a little confused by the specific ask, but if the system you are connecting to EDMCS does not have a delivered cloud adapter, in current state you’d have to build a custom integration path to get the metadata file into or of EDMCS into the target application.
For example, if you are doing EDMCS to on-premise Hyperion Planning, you’d have to download the metadata files from EDMCS to the Planning server, and then run the Outline Load Utility to get them into the Hyperion Planning application.
Hope this helps!
-Kate
Hi Kate,
I am new to EDMCS, Can you please help me on below question.
Can we automate the EDMCS dimensions export to GL cloud using EPM automate.
If yes can you please prove me the EPM automate commends.
or else what is the other way to automate exports
Hi,
No you cannot use EPM automate at this time to automate exports to Oracle GL cloud ERP. You will need to use the EDMCS rest api and scheduled processes in ERP to process each segment load.
Can you please explain How to to use EDMCS rest api and schedule process. to automate edmcs dimensions to GL.
if we use rest API i think we have use rest api through OIC integration right.
Is there any possible way without OIC.
Hi Kate,
Thanks for you reply
Where we will run the rest API commends.
we have to OIC integration to run EDMCS rest API? is there any other way with out OIC
We typically will run REST API calls via CURL and write a script. The Oracle documentation provides the commands you’d need to run.