03-20-2024 11:23 AM - last edited on 03-20-2024 03:18 PM by JackLacava
I need to copy data, including adj data, from one fiscal year cube to another calendar-based cube. The DM Job I tried to use does not work with ADJ data as the journals cross entities that don't exist in the target cube.
The rule also needs to include variables for entity, account. and scenario remapping.
Any sample provided is appreciated.
03-22-2024 09:24 AM
To be honest, using a Data Source of type "Data Management Export Sequence", obviously wired to a DM sequence, in my opinion is so much cleaner than any alternative. The problem you mention gets easily addressed with a sprinkle of extra Transformation Rules.
This said, if you really have to use rules, there is nothing special about going cross-cube, just reference it with the "Cb" prefix, e.g. api.Data.Calculate("A#Target = Cb#SourceCube:E#SourceEntity:A#SourceAccount"). There are ways to do mappings (the "Convert*" calls), but they are complicated to set up and rarely worth the effort.
03-25-2024 07:49 AM
Thank you, this will take me a while as I'm new to this.