Hi Bex Gurus,
I have created a product BOM hierarchy on 0material info Object. Here is what I need to present the hierarchy for the material usage on this BOM hierarchy structure :
On Bex:
Product Hierarchy Request Qty
================= ===========
PC001 100
CPU-300hz 100
RAM-512M 200
MotherBoard-ABC 100
USB-001 100
Serial Port1 100
lines in the cube:
Lines in the Cube:
PC001 100
CPU-300hz 100
RAM-512M 200
MotherBoard-ABC 100
USB-001 100
SerialPort1 100
But in fact BEX will show:
- at level PC001, KF(Request Qty) has the aggregated value: 700= 100100100200100+100
- at level MotherBoard-ABC, KF(Request Qty) has value: 300
How can I suppress the aggregation at high level nodes with sub nodes here? As it doesn't make sense to say you only have 100 CPU but after adding other parts to make more than 100 PCs.
Any suggestions or work around?