NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
If you would like to use Ordnance data, link items and/or use multi-select fields then you need to create SQL views.
[[Image:SAG Ordnance.png|650px|center]]<div align="center">'' Example with Ordnance and different formats of date''</div>[[Image:SAG concat.png|400px|center]]<div align="center">'' Example of fields being concatenated''</div>[[Image:SAG Link.png|200px|center]]<div align="center">'' Example of retrieving information from a linked table''</div>
{{Note | It is only the Country Structure of Locations that is flattened, other Country structure references (both system and CDFs) have to retrieved by SQL views.}}
[[Image:SAG CS flattening1.png|500px300px|center]]
<div align="center">
'' Country structure reference to where the Victim is currently living is not automatically flattened into the the Victim by the Staging Area Generator''
</div>
[[Image:SAG CS flattening2.png|500px400px|center]]
<div align="center">
'' The flattening with be done with SQL script as part of the post-processing''
</div>
Contact your [[Management Consulting Team | GICHD IM advisor]] for help in developing SQL statements according to specific requirements.
{{NavBox Business Intelligence}}
[[Category:VIE]]
