Exclude selections in the Report

[Former Member]

Hi Experts,

When i designing a report, i need to restrict data with the company code. In our business there are more company codes.

My scenario is except 5 company codes i need to allow all the company code data. If i use the exclude selection it will hit the performance of the report.

without using the exclude selectons how do i proceed.

Thanks,

[Former Member · Accepted solution]

I don't think for 5 or 6 exclusions will cause performance issue of report.

We are using 15 exclusions in one of the business requirement and we never faced the issue with the performance.

To many exclusions will leads to have performance issue and it depends again.

Use exclsuions rather waiting for some other way.

Regards,

Reddy

[Former Member · Accepted solution]

Hi

Even i have gone throgh the BW query performance it is also not suggesting the exclusion selections.

Is there any alternative method of design?

Thanks

Edited by: satya prasad on Apr 13, 2010 9:28 AM

[Former Member · Accepted solution]

Hi, In that case cant you restrict the company codes that needs to be shown instead of excluding the ones?

also did you try and observe any performance issue with exclusions?

Regards,

Vineeth

[Former Member · Accepted solution]

Hi,

There are lot of company codes need to be filtered.

Thanks,

[former_member181964 · Accepted solution]

Hi,

You include the required Company Code only in all Selections.

Thanks

Reddy

[shanthi_bhaskar · Accepted solution]

i hope exlusion is the better approach in ur case...it wont reverse the performance

[Former Member]

Hi Satya,

Will any other mode of restriction for company code at the query designer level be alright?

With Warm Regards,

Vineeth