So if I understood well you are trying to create a mapping which extracts data from your HFM target app...
With customization that's possible, but are you sure you want to open connection to HFM, extract data... every time the script is executed...which basically means, for every line matching the mapping criteria.
I would take out from mapping process and postpone to after map happens.
Yes, you understood right, I need to subtract target HFM app data when mapping
There are few accounts that should match this criteria, so I think performance impact would be small.
Yes, it would be better to postpone to after map event script. Still it is necessary to know how to take data from target HFM app
HFM Java Api?
Yes, tried to find good HFM Java API examples, found like this
But it does not say a much...
The main question is how to get connection to target. Or, in other words, main question is "how FDMEE knows how to connect to target application" or "where FDMEE stores target application connection information?".
I think this question is linked to question: "How FDMEE selects target application when registering it, how it populates list of target applications?"
Why not first execute a data load rule with HFM as the source to pull the dataset you need to reference into the FDMEE TDATASEG table. You can then reference this dataset in your mapping to get the desired result.
then it would be necessary to make source adapter for HFM load rule that means I need manually enter connection information, that might be good, but then I just can enter connection info righ in AfterMap event script. But, FDMEE already has target application connect info somewhere...Question is where
Not sure what you mean by ... "then it would be necessary to make source adapter for HFM load rule that means I need manually enter connection information" You don't have to do any of that in 188.8.131.52.x. You only setup EPM systems as targets, and then you can use them as either a source or target type in your import formats
that's good option , then I need to run load rule to load HFM data from aftMap jython script to select those data in other location... But I did not find how can I run rule from mapping script... only through OS command (https://docs.oracle.com/cd/E57185_01/AGFDE/submitting_a_data_load_rule.htm )...
Or, this HFM data shall present in TDATASED for all interested periods, then that's ok (assuming that, in case of wrong data in target application has been fixed, it would be necessary to load it again to appropriate location for appropriate period manually)
Thanks for advise.