Set up a query

Procedure

From the Basic settings view of tSAPBWInput, fill the Table Name field with the table name. In this scenario, table name "Measures" is for demonstration only.
Fill the Query area with the query script. In this example, we use:
```
"SELECT 
T1.\"[0D_CO_CODE].[LEVEL01]\" AS company, 
T0.\"[Measures].[D68EEPGGHUMSZ92PIJARDZ0KA]\" AS amount 
FROM 
\"0D_DECU\".\"0D_DECU/PRE_QRY4\".\"[Measures]\" T0, 
\"0D_DECU\".\"0D_DECU/PRE_QRY4\".\"[0D_CO_CODE]\" T1 "
```
Information noteNote:
Due to the limitations of the supported SQL queries, the query scripts you use must be based on the grammar defined in the jdbc4olap driver. For further information about this grammar, see jdbc4olap User Guide.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!