Creating a New Query
User Queries
In the user's desktop, choose the menu Query Maintenance. Click New.
To create user queries, the final user (not an administrator) must have the privilege of query creation. |
Creation process of user query is started, that follows all steps for query definition.
Enter:
| • | Name: name of the query (compulsory). |
| • | Description: description of the query (compulsory). |
| • | Group: future implementation in SIGADW. |
| • | Allow Access through Excel Integration: Integration with Microsoft Excel® that enables you to log in through a plug in to generate a query (see Excel Integration Topic). |
| • | Allow Access through URL: It allows access through URL, in which you can generate a query by entering only a valid address in the browser (see Topic of Access through URL). |
| • | Allow Access through Off-line Panel: future implementation in SIGADW. |
| • | Public: to make this query available for other users (whose access must be previously given by the administrator), define it as Public. Otherwise, it is only available for the person who created it. |
| • | Group Only: to make the query available only for the group the user belongs to, leave the option Group Only selected. |
In the page above, you can copy definitions from a query that already exists to the query that you are creating.
To copy chart or table information that is defined in the origin query to this new query, select the query to be copied in the field Available Queries and click Next.
To define all elements of the new query manually, choose the cube from which this query uses information. Choose if you want to define a chart or a table first. This definition of table or chart is the last step to be followed.
After filling out fields, click Next to proceed with the definition of query attributes.
Pre-defined Queries
Only administrator users can create pre-defined queries. |
Click the menu Queries and then Pre-defined. Note that the action New exists, that must be clicked to define some items, such as:
Enter:
| • | Name: name of the query (compulsory). |
| • | Description: description of the query (compulsory). |
| • | Group: future implementation in SIGADW. |
| • | Allow access through Excel Integration: Integration with Microsoft Excel® that enables you to log in through a plug in to generate a query (see Excel Integration Topic). |
| • | Allow Access through URL: It allows access through URL, in which you can generate a query by entering only a valid address in the browser (see Topic of Access through URL). |
After filling out fields, click Next to proceed with the definition of query attributes.
In the page above, you can copy definitions from a query that already exists to the query that you are creating.
To copy chart or table information that is defined in the origin query to this new query, select the query to be copied in the field Available Queries and click Next.
To define all elements of the new query manually, choose the cube from which this query uses information. Choose if you want to define a chart or a table first. This definition of table or chart is the last step to be followed.
In the next stage, attributes of a query are defined.