Show TOC

Editing Queries with the BW Modeling Tools (New)Locate this document in the navigation structure

As of versoin 1.6, you can use the BW Modeling tools to define queries for InfoProviders in order to analyze the data in your BW system.

You can do this if you are using a SAP HANA database.

You can choose from the following functions:

  • Create structures in the row and column axes of the query
  • Select characteristics of the InfoProvider for the row and column aexes of the query or as free characteristics (including usage of characteristic hierarchies)
  • Select key figures of the InfoProvider as structure elements for the row and column axes of the query
    • Create restricted key figures for the current query
    • Create formulas, i.e. calculated key figures, for the current query
  • Use resuable restricted and calculated key figures, as well as variables
  • Define the properties of characteristics, structures and key figures
  • Create static and dynamic filters
  • Currency and unit conversion
  • Create conditions
  • Create exceptions
  • Preview the query
  • Transport
  • Generate SAP HANA views

Note that the following functions from BEx Query Designer are not supported in the BW Modeling tools Version 1.6:

  • Create reusable components
  • Create and use reusable filters
  • Create and use reusable structures
  • Variables Editor
  • Cell Editor
  • Using the query for BW Integrated Planning.
Related Information