ID for Import
Some reports from Indicator Management System comprises a work process also mentioned in the Balanced Scorecard methodology. Thus, you can obtain the ID to import the indicators directly from DW query.
Report Name |
Parameters screen |
In the report |
||||||||||||||||
|
|
|
Procedures
| 1. | To use the methodology, replace the file sgi.jar from the directory of SGI website with the file that has the same name. |
| 2. | To enable this methodology, edit the configuration file APPSERVER.INI, which is in the folder \PROTHEUS11_DATA\BIN\APPSERVER. |
| 3. | Add the key ANALYSISMODE with value 2 in the configuration session of SGI Job. |
Example:
[JOB_SGI]
TYPE=WEBEX
ENVIRONMENT=SGITESTE
INSTANCES= 1.3
SIGAWEB=SGI
INSTANCENAME=SGI
ANALYSISMODE=2
ONSTART=STARTWEBEX
ONCONNECT=CONNECTWEBEX
ONEXIT=FINISHWEBEX
SGIPATH=\web\SGI
| 4. | In Indicator Management System, access Indicators register. |
| 5. | In field Import Code, enter the code which defines the indicator. |
| 6. | In SIGADW, prepare a query according to the model: |
Code |
Date |
Value |
Goal |
XXXXXXXX |
11/11/1111 |
100.00 |
200.00 |
YYYYYYYY |
11/11/1111 |
150.00 |
235.00 |
| 7. | Access option Data Source and register a data source which displays the SIGADW as the source. |
| 8. | In Configuration folder, select the option regarding the query in field Imp. Cd. ID Indicator. |
| 9. | Save and execute the data import. |
| 10. | The import of data can be viewed in folder Value Spreadsheet, in Indicators register. |
See Also