the following cases needs to be included in Query.
1.Wants to appear Project as well as WBS with and without respect of chosen profit center(Condition-WBS does and does not belongs to chosen Profit center).
2.Wants to appear WBS with chosen Profit Centre(Condition- Project does not belongs to chosen Profit center).
what are the necessary actions to be taken for this cases.
Thanks in advance.
Hello,
The key user wants a report with information on Projects and WBS. The selection is made by Profit Centre.
Let's figure out we select ES56 as Profit Centre.
On one hand, the key user wants the Projects belonging to that Profit Centre to appear as well as their WBSs, regardless of whether they belong to that Profit Centre or not. E.g.: we choose Profit Centre = ES56. Then all the following projects and WBSs should be taken into account:
Project SP.027 (ES56)
WBS SP.027.001 (ES56)
On the other hand, she also wants the WBSs with that Profit Centre to appear although its Project doesn't belong to the selected Profit Centre. E.g.: if we take the previous selection (ES56), both characteristics below should appear although the Project hangs from another Profit Centre:
Project SP.700 (ES56)
WBS SP.700.802 (ES56)
And now my question is: how can I achieve this with the 'profit centre' characteristics that exist so far? If I use the filters of 0PROFIT_CTR, ZWBS_ELEM__0PROFIT_CTR and 0PROJECT__0PROFIT_CTR, I only get the Projects and WBS directly linked to the selected division.
I need your help to solve some problem within a query.
Could you please give me a hint about this? I would be very thankful.
Edited by: S MB on May 5, 2009 2:17 PM