1 person found this helpful
The ability to perform consolidations and translations via FDM is built into the HFM adpter natively. This functionality can be switched on in the integration options in the adapter and control over what is and isn't consolidated can be controlled through the the definition of validation entity groups. Take a look in the FDM administration guide for more information.
1 person found this helpful
1) check CONSOLIDATE Action script in the HFM adapter for triggering HFM consolidation/translate using HFM adapter API functions
2) If you want to use HFM API in FDM scripts you will have register HFM libraries in the FDM app server. In any case your syntax is for VB api and FDM uses VB script so you will have to adjust your code.
This is just an example:
Set oClient = CreateObject("Hyperion.HFMwManageApplications")
If oClient Is Nothing Or Err.Number <> 0 Then
I would recommend to use HFM adapter functions as they are used in adapter action scripts.
You are right, the Validation Entity Groups functionality allow us to perform the consolidation in HFM after the Batch Load process is complete.
The issue we have will be to maintain the list of Entities into the Validation Entity Groups related to our LOCATION (we have a lot of Entities ...)
Our HFM admin already maintains All Entities into HFM Entity Dimension. By using the parent Node in HFM for Consolidation (via VB Scripts in FDM) we will avoid to maintain the Validation Entity Groups in FDM.
If we cannot launch VB Scripts to connect to HFM via FDM, we will use this FDM functionality.
Thanks for your helps.
Great news...I am now able to consolidate our main HFM Entity Node without having to manually entering all of our Entities (that are part of our Data Load text file) into the Validation Entity Groups. This functionality makes FDM a great tool for our HFM application without having to develop any VB Scripts.
Good to know that the 'out of the box' functionality meets your requirements. Can you mark the thread as anawered now.
i am trying to consolidate the entities in HFM for an independent scenario (not tied in FDM).
but i use that scenario for validation rule.
i have 3 scenarios in HFM, all these scenario's are in sync with metadata
- ACTUAL_DIF (this is difference between ACTUAL & ACTUAL_CP)
i am loading data into ACTUAL through FDM.
i pull data from ACTUAL_DIF into the check report for couple of accounts, based on entity classification (as FDM location has Multi-entities, but uique to that each locations).
is there a way to Consolidate ACTUAL_DIF scenario through FDM for each location (respective entities) submission.
Please help me out, i am new to FDM and i need the details
this question is already answered so you should open a new thread.
can you please give me a idea, how did you trigger the consolidate using the custom script. i am trying wit the EVENT script.
as i have to consolidate one more scenario on the fly during the submission. can you please give me a sample script.
also if you used the HFM API's, please let me know. how you imported those i nthe FDM