Skip to Content
Author's profile photo Marc Hartz

New Query Designer in Eclipse with SAP BW 7.4 powered by SAP HANA

SAP BW 7.4 SP9 powered by SAP HANA comes with a first version of a query designer integrated in the BW-Modelling Tools (BWMT) in eclipse. With this feature it is now possible to define not only the InfoProviders of SAP BW 7.4 (Advanced DataStore Object, CompositeProvider, OpenODS View), but also queries with specific functionality in eclipse. This enables an end-to-end modelling experience in eclipse.

With the current feature set available with BWMT 1.6 you can choose between various functions:

  • Create structures in the row and column axes of the query
  • Use reusable restricted and calculated key figures
  • Define conditions & exceptions
  • Add currency and unit conversion

At present this is a subset what BEx QueryDesigner can offer and should be used in addition to its functionality when simple queries are sufficient. We’ll further enhance the eclipse based query definition in future.


See the full feature complete Query Designer here: #BWonHANA’s New Query Designer

See a query example in eclipse below:

Blog 1 - Query.png

Blog 2 - Query.png

Blog 3 - Query.png

Furthermore a new feature of the BW query in eclipse is to generate SAP HANA views based on BW queries. (Also possible with SAP BW 7.4 SP8 with a generation report)

If a query definition can be expressed as a flat view the calculation can fully take place in SAP HANA and a corresponding HANA view can be generated. To do so the query in eclipse offers a flag to create an “External SAP HANA view”.

This will generate a HANA view based on the query definition into a separate HANA schema which allows consuming the data for example via SQL or further modelling with native HANA views.

Blog 4 - Query.png

At present the following query functions are supported to be generated into SAP HANA views:

  • Currency/unit conversion, variables, restricted key figures, global restrictions, inventory key figure (closing balance) and formulas (SAP Note 2080686)
  • All other features will either be not supported and then prevent the generation of the SAP HANA view or simply be ignored during generation
  • Please find a detailed list of offered functionalities and prerequisites here

The main use case of the HANA view query generation is to be able to leverage the possibilities of the query in regards to conversions, filter and formulas. Having this feature available allows us for example to filter at the earliest possible layer if further logic will be added in HANA or data consumed via SQL externally.

Blog 5 - Query.png

See example of a generated view according the query definition below:

Blog 6 - Query.png

This can now be used in any kind of HANA modelling or for direct SQL consumption like shown in the screenshot below:

Blog 7 - Query.png

The following video demonstrates the functionality in the system:

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Luc Boodts
      Luc Boodts

      Hi Mark,

      Great expanation !

      I was just wondering whether there are any limitations in terms of Bex query designer interoperability. Can we open queries in Query designer that were created in the Eclipse version and vice versa ?



      Author's profile photo Marc Hartz
      Marc Hartz
      Blog Post Author

      Hi Luc,

      thanks for your feedback and question. In general objects modelled in eclipse can only be changed there. The same applies for queries. You won't be able to change eclipse queries in BEx Query Designer and vice versa.



      Author's profile photo Martin Chambers
      Martin Chambers

      Hi Mark,

      are there any plans to add interoparability between queries created BEx and Eclipse soon?

      When do you anticipate that the missing functionality will be added to the Eclipse version?

      And, if I may say so, there is room for improvement for things like the formula and the cell editor.



      Author's profile photo Marc Hartz
      Marc Hartz
      Blog Post Author

      Hi Martin,

      good question, we do have the integration and enhancement of the query in eclipse on our roadmap, so yes we are working on this.



      Author's profile photo Former Member
      Former Member

      Thanks for sharing. Excting time for bw consultants

      Can't Wait to get my hands dirty with some real time business scenario.

      Author's profile photo Christian Ettenauer
      Christian Ettenauer

      Hi Marc,

      according to the fact that we are starting a BW on Hana from scratch I'd love  to use the new Query Designer as our main modelling tool instead of the existing BEX Query Designer.  So it would be great if you could provide a timeline for development of the Eclipse based Query Designer.



      Author's profile photo Roland Kramer
      Roland Kramer

      How to implement the BW-MT 1.7 tools, see

      SAP First Guidance - Implementing BW-MT for BW-aDSO

      Best Regards Roland