Skip to Content
author's profile photo Former Member
Former Member

Search for display attributes in Web reporting

Hello,

When I execute a query in Excel, in the variable entry screen, I can search values for material, for example, using some display attributes as Colour or Size. I mean, I want to execute the report for materials whose colour is white. I can open the matchcode for Material, I select the value "white" for the Colour display attribute, and I get a list of all the materials with that colour. The report is executed for those materials.

However, when I execute the same report using Web reporting, I don't have the display attributes in the selection screen, to restrict the material. Once the report is executed, in the Navigational block, if I filter the material, there is an option called "Search for display attributes activated", where I can restrict per Colour, but only for one value.

I have two questions related to this topic:

1) Is it possible to have the functionality "Search for display attributes activated" in the variable entry screen, for Web reports, in the same way it is available in the reporting via Excel?

2) Is it possible to configure that functionality, in order to restrict several values for the display attribute at the same time (in my example, for Colours "white", "black" and "red" at the same time)?

Thanks very much for your help

Patricia

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 09:27 AM

    Hello patricia,

    Using standard functionality this is not possible.

    The only option you have is what you have already found, the Characteristic properties in the web-report.

    Regards,

    Gert van de Vreede

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 09:30 AM

    Hi Patricia,

    Looks like you have some new navigational attribute requirements, don't you think? I'm sure that would solve your issue, though maybe you're trying to avoid using navigational attributes (it is usually said that using navigational attributes is slower).

    Maybe you can do a test on BEx to check if your query is considerably slower when filtering directly by material code (by filtering on the selection screen using display attributes) or using a navigational attribute.

    Match codes on web reporting have lost some functionalities compared to BEx (such as importing a list of values from a file, for instance).

    Regards,

    David.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Patricia,

      In that case you may probably try to execute a subquery on your query.

      On the original query you can create a variable for 0MATERIAL characteristic that will be filled with the result of a query. Then, you need to create another query on the 0MATERIAL Infoprovider, where you can filter by concrete display attribute values or even use new variables that the user can fill at execution time.

      I'm just guessing some workarounds... maybe you already had a look at some. BEx was not that bad 😊

      Regards,

      David.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.