Save Queries 

 Save queries

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

In the Query Designer toolbar, choose  Save Query.

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

 Save query as...

...

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

       2.      Enter the new technical name.

This name must uniquely identify the query, meaning that the name is allowed to appear only once in the entire Business Information Warehouse. 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.

Result

The query has been saved and you can now:

·        Display it in the Web browser with the Standard Web Template for Ad-hoc Analysis

·        Use the query in the Web Application Designer as a data provider for Web items.

·        Insert the query into a workbook in the BEx Analyzer

·        Use the query in the Crystal Report Designer as a data source for a formatted report