Saving Queries

Save Queries

Using the Save Query function, you can save a query that you have defined or changed under its current name.You can also save a query when you do not make any changes to the definition.You can save your query at any time.

In the Query Designer menu bar, choose Query → Save.

Save Query As...

If you want to save the query under a new technical name, in the Query Designer menu bar, choose Query → Save As.
Enter the new technical name.

This name must uniquely identify the query; the name is only allowed to occur once in the entire BW system. The technical name can be up to 30 characters in length and must begin with a letter.

Enter a Description for the query. You can save the query in your favorites or roles.

Note

With the Save As function, a copy of the query is created, which only copies the local objects of the query. The reusable objects of the query are also referenced.

Result

The query has been saved and can now be:

Displayed in the BEx Web Analyzer
Used in the BEx Web Application Designer as a data provider for Web items
Used in the BEx Analyzer as a data provider for design items