Skip to Content
Author's profile photo Aneesh Kumar R

Creating a Query Using Eclipse Based Query Designer

Its now possible to create a query using Eclipse Based Query Designer – now available with BW Modeling Tools 1.6

The intention of this document is to show how to create a simple query using the Eclipse based query Designer

(1) Invoke the context menu on a BW project and select “New” -> “BW Query”

 
  /wp-content/uploads/2014/12/d1_598645.png
 
 
 

(2) “New BW Query” dialog comes up, where we can give the name and description of the query

/wp-content/uploads/2014/12/d2_598670.png

   Note: When creating the query itself, it’s possible to have the query in the project explorer “Favorites”, for the BW
             project, by selecting the “Add to Favourites” option – as done in the screenshot above

(3) Select “Next” in the “New BW Query” dialog, and there is an option to select the info provider on which this query should be built

  

     Key in the name of the info provider, select the desired info provider from the matching info providers and select “Finish” in the “New BW Query” dialog

/wp-content/uploads/2014/12/d3_598676.png

(4) After “Finish”, the native Eclipse Query editor comes up – the screenshot below shows the “General” tab selected

/wp-content/uploads/2014/12/d4_598677.png

Note:

     (a) Observe that there are 5 tabs – General, Filter, Sheet Definition, Conditions and Exceptions

   

     (b) There is an “InfoProvider” view also available – which has the characteristics, Key figures, and Reusable Components

(5) Navigate to the “Sheet Definition” tab and drag and drop the desired characteristics and key figures from the info provider
view to the rows and columns in the “Sheet Definition” tab – as seen in the screenshot below

/wp-content/uploads/2014/12/d6_598678.png

(6) Save the query and check the preview of the query using the “Show Preview” button at the top right

/wp-content/uploads/2014/12/d7_598679.png

(7) Observe that the query results will be seen in the “BW Reporting Preview” view

/wp-content/uploads/2014/12/d8_598681.png

We can enhance this query to have restrictions, conditions, exceptions etc……..

Assigned Tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      gud and thaks aneesh.U created it so fast 🙂

      Author's profile photo Roland Kramer
      Roland Kramer

      Hi, See also the first Guidance Document - SAP First Guidance - Implementing BW-MT for BW-... | SCN

      Best Regards Roland

      Author's profile photo Martin Chambers
      Martin Chambers

      Man, that's really complicated!

      I wonder whether it would be better to wait until the next support package?

      Regards,

      Martin

      Author's profile photo Roland Kramer
      Roland Kramer

      Hi,

      With 7.40 SP09 which is released, everything is much easier ...

      Best Regards Roland

      Author's profile photo Former Member
      Former Member

      Hi dinesh,

      can we use this feature with 7.4 SP08?

      thanks

      Mirana

      Author's profile photo Martin Chambers
      Martin Chambers

      Hi Aneesh,

      Thanks for creating this document.

      Unfortunately, the screenshots have lost a lot of their resolution, making it quite hard to distinguish any details.

      Perhaps you could consider publishing screenshots showing only the important details?

      Author's profile photo Aneesh Kumar R
      Aneesh Kumar R
      Blog Post Author

      Hi Martin,

      you should be able to click on the screenshots which will then enlarge them. please let me know if this is not possible

      Author's profile photo Martin Chambers
      Martin Chambers

      Thanks! Yes it works.

      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran

      HI Aneesh Kumar R,

      Thanks a lot for sharing. wonderful document.

      BR

      Prabhith

      Author's profile photo Former Member
      Former Member

      Thanks. 

      Would you comment on your BW sp level?  7.4sp5 or higher is required?

      Author's profile photo Aneesh Kumar R
      Aneesh Kumar R
      Blog Post Author

      Yes, please use BW 7.4 SP09

      Author's profile photo Goutam Khandelwal
      Goutam Khandelwal

      Aneesh, thanks for sharing the doc

      Author's profile photo Former Member
      Former Member

      Great Effort!!

      Author's profile photo Loed Despuig
      Loed Despuig

      Hi,

      Thanks a lot for sharing! 🙂

      Loed

      Author's profile photo pramod k
      pramod k

      Thanks for sharing .

      Are there any  advantages of using Eclipse based query designer to regular bexquery designer  ?  or its just different way to design a query  with more ease ?

      Can we create user exit variables , Heirarchy variables in Eclipse based query designer ?

      Can we interchangeably use query designer to do any modifications to query created In BW modeling tools in eclipse ?

      _ Pramod

      Author's profile photo Jameel Ahmed Shaik
      Jameel Ahmed Shaik

      HI ,

      we are on Project, we have BW on HANA.

      On top of Composit provider we have created many BEx Queries (Classic BEx Query designer tool )

      Client is asking as to use the Eclipse-based UI for designing the BEx Query’s.

      As I told we are on project, Creation will take time.

      I want to Migrate my BEx query to Eclipse-based UI .

      Please let me know the possibilitys.

      Author's profile photo Jameel Ahmed Shaik
      Jameel Ahmed Shaik

      I think it is possible from BW 7.4 SP13.

      Author's profile photo Former Member
      Former Member

      How great would it be if we could copy RKs and CKs!