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 Costcenter-Root Level and P&L account-Root 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 Costcenter-Root 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 Costcenter-Root Level and Employee-Costcenter. Then you set a 1 for every matching pair of the two entities in this cube z.
Additionally you need a tmp-cube structured by Costcenter-Root Level, P&L account Root-Level and Employee-Costcenter. 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:
tmp-cube = cube x * cube z
The second is:
cube y = tmp-cube
At the end clear the tmp-cube. 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 How-To 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 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP