Is it possible to do What-if analysis on Bom Component Quantity ? As Users wanted to do what if analysis for Gross Die per Wafer. We tried creating one measure for GDPW and use the if condition in BOM Custom Roll up for eg. if (isNull("GDPW"),Component_Qty,"GDPW") but it is not working for What-if Analysis. Do i need to change something in On-Change formulae in BOM Custom Roll up.
If the component quantity is a function of parent and child, then you cannot load it into a measure in either parent or child. There is no easy what-if support. YOu will have to use uploadable report and use batch calculation for supporting this.
We are able to load the GDPW for Die level (only one stage )and we have a condition to validate if the measure is null it will take the component_Quantity or else it will take the 1/GDPW measure value. we are doing it for 3 purposes :
1. To get the Accurate value of GDPW which is equal to 1/Component_Quantity (GDPW will be accurate only if we get 30 decimal places value in calculation)
2. As part of information provided to Users as they wanted to see it.
3. To do What-if Analysis (if Possible).
We could have use 'todouble' for the accuracy but we were thinking of what if analysis, and user visibility also.So far calculation is coming nicely but it would be appreciated if you can give pointers for the risk involved in keeping GDPW as measure.
Edited by: Lokesh Rathi on Sep 21, 2011 6:38 AM