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.

UPDATE:

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:

To report this post you need to login first.

7 Comments

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

  1. 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 ?

    Thanks,

    Luc

    (0) 
    1. Marc Hartz 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.

      Regards,

      Marc

      (0) 
      1. 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.

        Regards,

        Martin

        (0) 
        1. Marc Hartz 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.

          Regards,

          Marc

          (0) 
  2. 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.

    Regards

    Chris

    (0) 

Leave a Reply