Combing data from two Entity Trees
I use board 10.5 + webclient.
I have data in Cube X that I need to transfer to Cube Y.
Entity Costcenter  Root level has 450 entities that match to 50 entities in Employee  Costcenter.
I use a Select in the dataflow for the PL account to only write in 1 certain account in the PL.
When I know excute the dataflow the data gets multiplied by 22, And instead of putting it on the matching entitie. It will put the outcome on all entities.
How can I avoid this?
CUBE X:
CUBE Y:
Answers

Hi Robbin vw,
if I understand you right you have a cube x structered by Employee and a cube y structered by CostcenterRoot Level and P&L accountRoot Level.
If you now select one P&L account and do the dataflow from cube x to cube y you get the sum of cube x on all CostcenterRoot Level on the selected P&L account.
The missing link is the connection between the structure employee and structure Costcenter. You need a cube where you set this connection. This cube z can be structured by CostcenterRoot Level and EmployeeCostcenter. Then you set a 1 for every matching pair of the two entities in this cube z.
Additionally you need a tmpcube structured by CostcenterRoot Level, P&L account RootLevel and EmployeeCostcenter. In a dataflow all source cubes will align to the target cube before calculating and if a stucture is missing you get the sum of the source.
So your first dataflow is:
tmpcube = cube x * cube z
The second is:
cube y = tmpcube
At the end clear the tmpcube. That´s it.
Hope it helps
Dietmar
1 
Thank you for the solution!
0
Categories
 All Categories
 2K Forums
 1.8K Platform
 159 Academy
 324 Resources
 1 Board Knowledge Base
 50 Best Practices
 49 HowTo Guides
 19 Board Advocacy Program
 191 Blog
 4 Groups Hub
 4 About Groups
 New Community Members
 DACH
 Japan
 4 Community Captains
 1 About Community Captains
 2 Meet the Community Captains
 1 Topics & Thought Starters
 Learn from the Board Captains
 Release Notes
 Academy
 2 Board Academy
 8 ILT/VILT Course Catalogue
 13 eLearning Course Catalogue
 4 Academy Forum
 1.2K Idea Exchange
 337 Partner Hub
 94 Support
 14 FAQ's
 Customer Support Portal
 54 Support Articles
 BEAP