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

[OSAdmin]

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?

[OSAdmin]

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.