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

●