Skip to main content
M
MitPower01
March 20, 2024

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

  • March 20, 2024
  • 2 replies
  • 0 views

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

J
JackLacava
March 22, 2024

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.

M
MitPower01Author
March 25, 2024

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

Terms & ConditionsAccessibility statement