Queries
After creating Connections, Dimensions, as well as Cubes and making the necessary imports, the next step is to create management queries in SIGADW.
Each query can be composed of a chart and/or a cross table.
This cross table, that is simply called table, enables you to view the involved attributes in many ways. It is the same concept of dynamic tables of Microsoft Excel®. However, there are no limits of columns and rows.
Each query is created based on a cube. Therefore, the hierarchical structure of a query can be the following one:
| 1. | Data warehouse DW1 |
1.1) Cube X
1.1.1) Query 1
1.1.2) Query 2
1.1.3) Query N
1.2) Cube Y
1.1.1) Query 1
1.1.2) Query 5
1.1.3) Query Z
In each query, query Attributes can be applied. These attributes are:
| • | Virtual Fields: they are indicators calculated in query execution time. |
| • | Filters: they enable information displayed on the screen to be filtered. |
| • | Warnings: they enable values to be pointed out according to a condition established (valid only for the table). |
| • | Ranking: it enables values to be ordered in an ascending or descending way. |
Besides, either the table or the chart has a powerful analysis resource called Drill Down. Through this resource, you can know better the information that is being displayed, going to a lower level of analysis, giving to the user a great flexibility in management analyses.
There are two types of queries that can be created in SIGADW: pre-defined queries and user queries.
| • | Pre-defined Queries: they are queries created only by the administrator and they can be accessed by certain users, to which privileges of view and/or maintenance are given by the administrator. |
| • | Users: they are queries created by each system user. They are exclusive for this user unless they are configured as public, making them visible to everyone. |
The method of query creation is always the same, either for pre-defined queries or for user queries, as described in the following topic.