Skip to Content
0
Former Member
Nov 09, 2011 at 06:46 PM

BEx Query data formating with Hierarchy

36 Views

Hello,

I am working on BEx Itemized cost structure report of with details on BOM

components, BOM quantity, Component costs and corresponding weight

details.

I am running into an issue with the report when a component used more

than once as a child component in BOM explosion as it is showing the both levels together insted

of showing corresponding child node/component display which throwing

off the numbers in report

My cube data is

Component Level BOM_qty Comp_cost

1004025 3 1EA 20 usd

1004105 5 1 EA 30 USD

1004021 4 999 kg 100 usd

1004021 6 9.2kg 5 USD

Error Query layout

Component_Hierarchy Level_of_componet BOM_qty Component_cost

1004025 3 1EA 20 usd

1004021 4 (child of node 3) 999 kg 100 usd

1004021 6 (child of node 5) 9.2kg 5 USD

1004105 5 1 EA 30 USD

1004021 4 (child of node 3) 999 kg 100 usd

1004021 6 (child of node 5) 9.2kg 5 USD

Correct layout should be like below (only show corresponding child for the parents not all of them)

Component_Hierarchy Level_of_componet BOM_qty Component_cost

1004025 3 1EA 20 usd

1004021 4 (child of node 3) 999 kg 100 usd

1004105 5 1 EA 30 USD

1004021 6 (child of node 5) 9.2kg 5 USD

I am getting this error when i have component used more than once in my BOM structure and it throwing off my reports aross the report.

I can take the level out of the report, But it will show aggregation of the qtys and cost ( It is not the expected outcome)

I am getting the aove problem when i add the level into the report as it is not inteligently not showing the right child node at right parent level...

Please let me know if you have any thoughts arounds this and i would reallu appreciate your help for a quick response...

Thanks,

Sri