AnsweredAssumed Answered

Data flow from Parent to Child Entity Not Working

Question asked by hwkoh on Dec 5, 2019
Latest reply on Dec 11, 2019 by hwkoh

Hi Everyone,

 

I am faced with a problem regarding allocation of a value from a parent to a child entity which does not seem to work. Hope that someone can provide me with some insights.

 

I am trying to flow data from a parent entity called Product Group to a child entity called Product. 

Relationship: Product ---- Product Group

 

I am using the following cubes.

 

Cube A:                              Cube B: 

Month (D)                           Month (D)

Scenario (D)                       Scenario (D)

Product Group (S)              Product (S)

Profit Center (S)                 Profit Center (S)

Accounts (S)                      Accounts (S)

 

Dataflow: B=A.

 

The result that I am expecting is for whatever data is available at Product Group Level to be replicated and pushed down to the relevant Products within the respective Product Groups. However, execution of this data flow does not flow any data into cube B (I have tried running dataflow with Open Sparsity too, but to no avail). 

 

Next, I have tried changing Product entity in cube B from sparse to dense.

 

Cube A:                              Cube B: 

Month (D)                           Month (D)

Scenario (D)                       Scenario (D)

Product Group (S)              Product (D)

Profit Center (S)                 Profit Center (S)

PC Accounts (S)                PC Accounts (S)

 

Dataflow: B=A.

 

The Dataflow can be executed. However, all amounts at Product Group level are replicated and flowed into all products in the system, even to Products which are not children of that Product Group, which I do not expect to happen.

 

1) 

 

2) 

 

 

Image 1 shows that the amount 0.58 that is supposed to be allocated to products within product group F0500.

Image 2 shows that the amount 0.58 is not just allocated to products within F0500, but also other products which are not even in product group F0500.

 

I have also tested a simple dataflow of a cube of Month x Product Group to Month x Product, and the data flow works exactly like how I expected it to be.

 

Thank you in advance, if anyone could enlighten me on what is causing this behaviour.

Outcomes