Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

We have a client that had two cubes but they only want to load the GL data to stage once

Originally posted by Michael Malandra

6/8/2017

We have a client that had two cubes but they only want to load the GL data to stage once. The first cube would have workflows that Import data from the GL to stage. How would I build the workflow profile to validate stage data and load to the second cube?

Cubes
Dimensions
Extensibility
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    Originally posted by Eric Osmanski

    The way I can think of is to have the Process step on the WF kick off a DM job that extracts and loads the data into the other Cube. However, the document attached has extracting Cube data, so you would need to write a BR to extract the Stage data instead. There is an example in GolfStream of an extender BR to extract Stage Data.