Skip to Content
avatar image
Former Member

Query from master data

I am trying to create a structure to create a query as follows from 0EMPLOYEE master data. I have ceated a BI infoset with 0EMPLOYEE and using that to create this query. This query is intened to be used as the receiver query in RRI.

Sender Query (query1):

Employee Distribution by perfromace rating

Performance Rating Before_Min Below Above Total

*********************************************************************

Receiver Query (query2) : this should feed the employees used in query1 and get their attributes in a query

Employee Last_Name First_Name, Annual_Salary

A

B

....

Qns:

1, What is the best approach to get this?

2. How do I create a characteristic query for Employee (without key figures) as in qurey-2

Amy help is apprecaiated.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 21, 2007 at 12:55 PM

    All you have to do is create an InfoSet query to get the desired data from your 0EMPLOYEE InfoSet. Key figures are not required. The only trick here is to be sure you turn off the Zero Suppression in the query properties screen. Otherwise, you will get no data.

    Lastly, set-up this query as your jump target in transaction RSBBS.

    Hope this helps...

    Bob

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      It depends on whether or not you are using the same InfoObjects in the sender and receiver. If so, it will "automatically" match them up. If not, you should map them on the Assignment Details screen to indicate which ones go together (e.g. 'Company Code' to 'Sales Org').

      It may also have something to do with whether or not you are drilling down and/or filtering by 0EMPLOYEE (and/or 0SALESORG?) in the sender query. I have seen results similar to yours that I could not explain, but never have gotten around to investigating.

      Hope this helps...

      Bob