Saving Queries 

Save Query

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.

If the query does not have a technical name, the system displays the Save As function automatically.

Save Query As...

...

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

       2.      Enter the new technical name.

This name must uniquely identify the query; the name is only allowed to occur once in the entire BI system. The technical name can contain a maximum of 30 characters and must begin with a letter.

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

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