on 07-30-2010 7:24 AM
Hi All,
I am using a Purchasing Variance Report which has material as the variable . i have material material , budget price , actual price as columns i also have plant in the free characteristics.
When i run the report it display all the information but when i restrict the plant the budget prices disappear..
Can someone help me as to how to restrict the plant under the material i.e i have material 400000 in plants xy01 , xy02 and xy03 but i want to view the material details only for xy01 and xy02...
Hi,
May you check in the budget data is maintained against plants in your cube.
In many of cases budget data is maintained at country/Sales org level not at Plant/Location level. So there are chances that your plant characteristics in blank in cube where ever budget qunatities are available in records.
I hope it will help.
Thanks,
S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
I now have plant included in the budget infocube , now the functional people have given me the plant , material and budget values, but theres a problem again...
If a material is available in one plant then the budget value , actual value & Variance values come fine
but the there are 3 plants so for the other 2 plants the budget value is what is given but the actual value is empty so there is a differnece in the variance values.
How do i filter out the plants for which the actual values are null.
Hi,
Do you want to filter for all materials on plants xy01 and xy02 or only for material 400000? You can always drilldown on plant followed by applying a filter for xy01 and xy02. If it is only for material, you can further filter on material 400000. If you need to hardcode for plants xy01 and xy02 alone at all times, you can apply a global filter/characteristic restriction on plant in your query.
--Priya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.