Examples

In this section, you can find examples of how to define queries. These show you how to use the various functions in Query Designer.

• Example of how to use exception cells

  This example shows how you can use the cell definition to define and calculate key figures.

  More information:Example: Defining a Query with Key Figures

• Examples of how to use offset variables

  These examples show how you can to use offset variables to define a query in order to compare two years.

  More information:Examples of How to Use Variables

• Example of how to define a  list of slow-moving items

  This example shows how you can use characteristic property Access Values for Result Values on Master Data to define a query in which all products are displayed that have not been sold in the past six months or have only been sold in very small quantities.

  More information:Example: List of Slow-Moving Items