on 12-10-2010 9:11 AM
Hi Experts,
I'm trying to exclude an WBS from a Cost report, using the multiple selection but it's not working.
I would like to see all the planned cost of the project excluding all those cost under a specific WBS.
Can anybody help me? Thanks!
Hi,
Which report are you using?
Why don't you use filter to exclude that WBSE.
You need to give in WBS element range first and then WBSE that you don't want in report under exclude single values.
Regards,
Harsh.
Edited by: Harsh Saxena on Dec 13, 2010 12:06 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm using report "S_ALR_87013533 - Plan/Actual/Commitment/Rem.Plan/Assigned"
I first tried by introducing the project definition on the project field and using the multiple selection on WBS Element field to exclude a single value.
As it wasn't working I tried to select all the WBS Elements of the project selecting a range and exclude the single WBS Element but still doesn't work, all WBS Elements of the project appear on the report.
>
> As it wasn't working I tried to select all the WBS Elements of the project selecting a range and exclude the single WBS Element but still doesn't work, all WBS Elements of the project appear on the report.
Hi,
It is working at my side. The WBSE i excluded is not shown in report.
Just give the WBSE range and exclude the single WBSE, and do not put anything in project definition field.
Regards,
Harsh.
Hi Harsh Saxena,
I already tried but is not working.
I don't know if maybe is because of the mask I'm using... "L-0000000-XX-00-00-00-00".
I've even tried to only use the "No equal to" single value with all the other fields empty and it is still appearing!
Edited by: mforman on Dec 14, 2010 9:20 AM
Hi,
I have tested it, and have some finding, let me share with you:
Suppose we have following heirarchy:
TAD-AZ10-01.01
TAD-AZ10-01.02
TAD-AZ10-01.03
TAD-AZ10-01.03.01
TAD-AZ10-01.03.01.001
TAD-AZ10-01.03.02
TAD-AZ10-01.04
TAD-AZ10-01.05
TAD-AZ10-01.05.01
TAD-AZ10-01.05.01.01
I have checked and found that in SLR reports:
Case 1: if we want to exclude TAD-AZ10-01.03.01.001, then we have to
put the range as TAD-AZ10-01.01 to TAD-AZ10-01.05 &
exclude as TAD-AZ10-01.03, TAD-AZ10-01.03.01, TAD-AZ10-01.03.01.001
o/p will be:
TAD-AZ10-01.01
TAD-AZ10-01.02
TAD-AZ10-01.03.02
TAD-AZ10-01.04
TAD-AZ10-01.05
TAD-AZ10-01.05.01
TAD-AZ10-01.05.01.01
Case 2: if we want to exclude TAD-AZ10-01.05, then we have to
put the range as TAD-AZ10-01.01 to TAD-AZ10-01.05 &
exclude as TAD-AZ10-01.05
o/p will be:
TAD-AZ10-01.01
TAD-AZ10-01.02
TAD-AZ10-01.03
TAD-AZ10-01.03.01
TAD-AZ10-01.03.01.001
TAD-AZ10-01.03.02
TAD-AZ10-01.04
Means: In SLR reports if we want to exclude single WBSE then its parent should also be excluded.
Exception: If the larger limit value of the range is excluded (in eg:TAD-AZ10-01.05), then it will be excluded including its complete below hierarchy.
In, CN41we have to follow same above process but it will give case 1 o/p as:
TAD-AZ10-01.01
TAD-AZ10-01.02
TAD-AZ10-01.03
TAD-AZ10-01.03.02
TAD-AZ10-01.04
TAD-AZ10-01.05
TAD-AZ10-01.05.01
TAD-AZ10-01.05.01.01
Whereas, In CN41n, simply give the project definition and use multiple selection to exclude the required WBSE, and it will be excluded from the report. Nothing else is needed.
Well, i also didn''t know this until now.
Regards,
Harsh.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.