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

How to include attributes as parameters in a query?

Posted on Aug 01, 2006 at 09:13 PM 5 Views

Dear Gurus,

I need to create a parameter/filter in a BEx query using the attributes of 0MATERIAL like 0BRAND and 0CATEGORY. How do i do it? Thanks a lot in advance for the time and help.

Raj

Message was edited by: Raj Singh

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 05:40 AM

    Hi,

    Do you want to restrict any attribute of OMaterial .Explain your problem clearly.

    Regards,

    venkata Sharma.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 07:03 AM

    Hi Raj,

    check in TA RSD1 for 0MATERIAL if the attributes 0BRAND and 0CATEGORY are type <b>NAV</b>.

    If they are NAV you should be able to set the parameter/filter in the BEx-Query designer.

    Kind regards

    Klaus

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:07 PM

    Hi raj,

    If at all 0BRAND & 0CATEGORY are display attributes then u cannot set filter or parameter to those objects , if they are navigation attributes then u can do that after executing the query . I mean after getting the result u can drill down on the navigational attribute and set the values there .

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:14 PM

    Thanks a lot for all the answers. I set the attributes to navigable and then could filter on those in BEx.

    Thanks

    Raj

    Add comment
    10|10000 characters needed characters exceeded