Skip to main content
MitPower01
Newcomer
Mar 20, 2024 3:23 PM UTC

Need a Sample BR that Copies data from a fiscal yr cube to a calendar cube

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. 

2 replies

Employee - Sage
JackLacavaEmployee - Sage
Employee - Sage
Mar 22, 2024 1:24 PM UTC

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.

    MitPower01Author
    Newcomer
    Mar 25, 2024 11:49 AM UTC

    Thank you, this will take me a while as I'm new to this.

    Terms & ConditionsAccessibility statement