SIGADW Configurations

To configure SIGADW environment, access the menu Main, submenu Configuration. You can configure:

Identification:

Identification of current Data Warehouse.

• Name: Name of current Data Warehouse.
• Description: Description of current Data Warehouse.
• Icon: Icon of current Data Warehouse.

 

Error:

Notice in case of error.

• Name: name of the person notified.
• E-mail: e-mail of the person notified.

 

View:

view of data and queries.

• Maximum Records: maximum number of records viewed.
• User for access through URL: It defines the user used in the access through URL (external to SIGADW). This user must have privileges of access to queries that are viewed externally.
• Query update time (in minutes): interval of time in which queries are automatically  updated.
• Display QBE (Browser): This option enables you to choose YES to display QBE (Query by Example) in all system browsers, or NO not to display it.
• Apply filter automatically (Browser): By selecting DO NOT APPLY, searches are still made when the button apply is activated; APPLY, search is made when you finish entering filter expression; APPLY AND OPEN SEARCH AREA acts the same way as the option apply, but the typing area of ​​the search is already displayed and expanded.  
• Display cube update date on the query: Sets whether to display the cube information updated date in queries. This information is displayed in the upper right corner of the table or chart.
• Sort indicators in when assembling the queries: The indicators are shown in alphabetical order in the indicators area, facilitating the assembly of the queries.

 

Table:

table properties (query)

• Filters/Selection: It specifies the behavior of filters and selection in table execution.

Possible Values:

• Do not Display Filter: It displays query normally, keeping filters in background.
• Display Filter, if not applied: If the query has filters, and filters have not been applied yet,        filters are displayed before executing the query.
• Display Selection, if there is no filter: If the query does not have filters, the selection filter is displayed before executing the query.
• Row Color: It specifies the color standard used in table execution.
• Use Panel: It specifies the type of panel to be used in the access to queries. Possible Values: Simple or Double.
• Excel Integration: It specifies the use of integration of table execution with Microsoft Excel®.
• Display Navigation: It indicates if paging controls must be displayed in table queries. Standard (defined in SIGADW configurator by Administrator), No or Yes, in the query footer.
• Size of Drill Down columns: Enables the administrator of SIGADW to define how the size of Drill Down columns that the table queries have (if any) will be calculated. You can now leave AUTO (default), set a FIXED size or HIDE column until the user perform the Drill Down.

 

Maintenance:

It specifies SIGADW behavior when it is in maintenance.

• Allow Access: It indicates if users must be allowed to access SIGADW.
• Release Estimation: It indicates an estimation concerning the time maintenance is concluded.
• Notify Users: It indicates if users are notified about the maintenance period in the login.

 

Options:

Several Options

• Display Messages: It indicates if SIGADW messages must be displayed for users.
• User actions log: It indicates if the user log must be created.
• Import/Export Log: Indicates whether to log information generated in the directory DWLOGS when performing an import/export in SIGADW. The generated files can be identified by initials IMP to import log and EXP to export log.
• Notify Export: It indicates if notifications must be made when there is export.
• Use System register: It indicates if System user register must be used.
• Monitor users online: It indicates if on-line users must be monitored. This indication of on-line users can be viewed in user register.
• Schedule Synchronization: It schedules synchronization of user register of the System.
• Connections: Allows configuration of the Protheus server to be used as data source for importing Protheus user list.

QBE (Query-by-Example)

QBE (Query-by-example) is a resource that facilitates the creation of search expressions in SIGADW. Expressions created with QBE help can be used in some points of SIGADW as browsers, Filters and Selections.

QBE resources and automatic search in browsers facilitate searches of information displayed in system browsers.

• Note:

With QBE and automatic search in browsers, searches made in browsers by using the option Selection do not follow the search rule called Equal To anymore because they start considering the search rule called Contain.

Either the presentation of QBE in browsers or the automatic search is optional.

Procedures of Use

1 . In the menu Main/Configuration/View, two new options are displayed:

• Display QBE (Browser): This option enables you to choose YES to display QBE in all system browsers, or NO not to display it.
• Apply filter automatically (Browser): It enables you to choose: 1. DO NOT APPLY, searches are still made when the option Apply is activated;2. APPLY, search is made when you finish entering filter expression;3. APPLY AND OPEN SEARCH AREA, it works as the same as APPLY option. However, the area for search entry is already displayed in a expanded way.

2. Choose one of the possible combinations between the presentation of QBE in browsers and the automatic application of filters. To develop this documentation, choose YES to Display QBE (Browser) and APPLY to Apply Filter Automatically (Browser).

3. Access a browser: the icon of QBE is displayed next to the name of each column.

4. Click the icon of QBE and create a filter expression to be applied to the column selected. By clicking Apply, the filter defined is automatically applied, regardless of the option chosen in Apply filter automatically (Browser).

5. Activate the icon Selection, the area to do filters is expanded.

6. Enter a filter expression. By finishing the entry, the filter expression is automatically applied.