NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "By using this optional step it is possible to change the Staging area after the generation. This can be valuable in several use cases, for example: * If the Staging area shoul..."
By using this optional step it is possible to change the Staging area after the generation. This can be valuable in several use cases, for example:
* If the Staging area should only contain a subset of the {{IMSMANG}} database e.g. only Land with status ''Closed''
* If sensitive data (e.g. victim names and addresses) should not be included in the Staging area
* If data has to be processed for reporting purposes e.g. complex calculations of square meters
* If it would facilitate reporting to concatenate fields e.g. victim family and given names
* If it would facilitate to add fields from other items e.g. Accident date to Victim table
* If additional database SQL views are necessary, also for reporting and analysis purposes
If you would like to use Ordnance data, link items and/or use multi-select fields then you need to create SQL views.
{{Note |
Contact your [[Management Consulting Team | GICHD IM advisor]] for help in developing SQL statements according to specific requirements.
{{NavBox Business Intelligence}}
[[Category:VIE]]
* If the Staging area should only contain a subset of the {{IMSMANG}} database e.g. only Land with status ''Closed''
* If sensitive data (e.g. victim names and addresses) should not be included in the Staging area
* If data has to be processed for reporting purposes e.g. complex calculations of square meters
* If it would facilitate reporting to concatenate fields e.g. victim family and given names
* If it would facilitate to add fields from other items e.g. Accident date to Victim table
* If additional database SQL views are necessary, also for reporting and analysis purposes
If you would like to use Ordnance data, link items and/or use multi-select fields then you need to create SQL views.
{{Note |
Contact your [[Management Consulting Team | GICHD IM advisor]] for help in developing SQL statements according to specific requirements.
{{NavBox Business Intelligence}}
[[Category:VIE]]
