Skip to Content

Animated by the blog series about the new “Easy Query”-feature, I even wanted to see this on a real system. You can start reading here: Easy queries on SAP NetWeaver BW.

First off all, I had to upgrade my BI-Toolset to 7.20, Patch level 600. After this, I could see the new flag enabled:

So, I try to make my first query…After saving this, I get some errors and with it some more informations: 

  1. You cannot have any characters in your columns
  2. You must have a bgRFC-Destination called QD_EQ_LOCAL

and

The first point has been solved very easy;-) Just clear your structure…

The second point was a little bit more difficult to find:

Start Transaction SBGRFCCONF and Configure your Inbound bgRFC-Destination

After that, I could save my query with EQ-flag set.Within the Transaction EQMANAGER I could see all the informations and est the new query. By the way: Every time you change your query, you have to regenerate your query.

My first EQ runs perfectly (within some deficits with my displayed values ;-)):

My next steps will be to look after the EQ interfaces and how to integrate them in different scenarios.

After all, I like the EQ-approach for simple queries which will be used for different participants who do not want for analyze in deep. Through the generated but identical interface, you can easy build your application around this framework.

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

    1. Hendrik Brandes Post author
      Hi Alex,

      I think, that EQ might be used in mobile scenarios, but I think, the real power belongs to its generic interface: When you are using EQ, it will be very easy to integrate it within every context, you like to – e.g. WebDynpo, Mobile, RFC, SOAP…

      Have fun!
      Hendrik

      (0) 
  1. Christoph Thiemann

    Hi,

    does anybody know how to create a transformation with query as a source? I created a query as an “easy query” and i am able to start it in “easy query manager”. But I cannot select anything at “source” of type “query” at creating a transformation in rsa1. I didn’t find any information. :-/

    (0) 
    1. Hendrik Brandes Post author

      Hello Christoph,

      which is the SP-Stack you are trying to use this feature? At least SP8 for NW730 is necessary to use query as source for a DTP.

      As far as I know, it is not limited to Easy-Queries.

      Kind regards,

      Hendrik

      (0) 
      1. Christoph Thiemann

        Hello Hendrik,

        you are right. “Easy Query” has nothing to do with it. 🙂

        I found out that you have to set option “use as InfoProvider” in RSRT. Then you are able to select query as source.

        Regards,

        Christoph

        (0) 
  2. Yilmaz Alpdogan

    Hello Hendrik,

    I could save my query with EQ-flag set. I saved the query and the message is “…is configured as an easy query. Only change if necessary.” So, there is no problem with query.

    Within the Transaction EQMANAGER,  I cannot see any query. Do I need to configure or set something else ?

    Regards,

    (0) 
    1. Martin Mayer

      Hello Yilmaz,

      If EQManager is empty no EQ’s have been generated. Did you do the setup for EQ?

      Check the notes. E.g. note 1944258 contains a setup-Report.

      regards, Martin

      (0) 

Leave a Reply