Saving Queries 

Saving Queries

You can save a query that you have defined or changed under its current name, using the Save Query function.

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

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

Saving Query As...

...

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

       2.      Enter the new technical name.

This name must uniquely identify the query; the name is only allowed to appear once in the entire BI system. The technical name can be up to 30 characters long 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 Query As... function, a copy of the query is created that 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

·        Be used in the BEx Web Application Designer as a data provider for Web items

·        Be used in the BEx Analyzer as a data provider for design items