cancel
Showing results for 
Search instead for 
Did you mean: 

Exclude single WBS in a Report

fortian
Active Contributor
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

fortian
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

>

> 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.

former_member203108
Active Contributor
0 Kudos

Even it is not working for me

fortian
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

fortian
Active Contributor
0 Kudos

Thanks Harsh Saxena you've been very helpful!

Answers (0)