Skip to Content
avatar image
Former Member

Exclude category from the sap bex report ? Performance ?

Hi,

we need to exclude from PO category from the BI report. Its a document type. Do we have any performance impact if we exclude one document type from the BI report ? Instead we can goahead with the include type, but we never know what document type's will be added in future, for this we need to remodify the report everytime the business add a doc type.

Please provide your input will the exclusion in the global filter cause any performance issue ? We cannot do it in the cube/dso as there are multiple report's on the same MP and we need this doc type on only a couple of report's where as its not needed in other reports.

This cube where we have the doc type is used in many flows...so except the global exclusion in the Bex query, is there any other alternate solution ?

Please suggest.

Thanks

DR

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 15, 2016 at 01:31 PM

    Hi Daniel Ray,

    Alternative is:

    1. Create one custom table with fields called variable, Low, option and sign
    2. Maintain values which you want restrict in BEx report
    3. In Report create customer exit variable
    4. Read variable values from custom table which is created in step 1 and use variable wherever you required (in another reports)
    5. When new doc types comes just update in custom table, no need maintain in all reports wherever you used same variable in another reports.
    6. This way you can achieve performance instead of exclude

    Regards

    Nanda

    Add comment
    10|10000 characters needed characters exceeded