Dataflow to Cube with Extra Entities

Jason Ferguson

Hello 

I currently have multiple cubes with specific data that I want to populate into a single cube.

The issue is that I want multiple cubes to flow into the single cube and be represented as different entities (e.g Opening balance, closing balance, Inputs, Outputs)

I am unable to find a way to Dataflow the 'Inputs cube' into the New cube and have all that data labeled as an 'Input' Entity

Cheers

------------------------------
Jason Ferguson
Management Accountant
Australia
------------------------------

Andrew Hodgson

Hi Jason,

If your single cube (target cube) is structured by the desired entity, then you just need to do a select on that entity before you do the dataflow - but you'd have to do that for each cube that you load to the target cube. In other words, you cannot do it in a single dataflow (I believe).

So if you have a cube representing "Inputs", then you'd need to select "Inputs" in the procedure, and then run the dataflow to your target cube. Then select "Outputs" and run another dataflow with the cube representing Outputs and the target cube.

Hopefully that makes sense.

------------------------------
Andrew Hodgson
Senior Fiannce Manager
Bankwest
Australia
------------------------------
-------------------------------------------

Jason Ferguson

Cheers that works, was applying selects in the wrong places didn't think to apply a separate step at the start of the process with the select.

Thanks 

------------------------------
Jason Ferguson
Management Accountant
Australia
------------------------------
-------------------------------------------