Cognos data import: Difference between revisions
Ttenbergen (talk | contribs) m email now goes to Lisa, no more outlook forward from Tina |
|||
| Line 2: | Line 2: | ||
== Process == | == Process == | ||
[[Decision Support Services]] sends an automated email report to Lisa | [[Decision Support Services]] sends an automated email report to Lisa and Pagasa | ||
every morning. The data is then imported into [[CCMDB.accdb]] master on Regional server and provided to collectors via regular roll-out and news and backup. | every morning. The data is then imported into [[CCMDB.accdb]] master on Regional server and provided to collectors via regular roll-out and news and backup. | ||
=== Cognos extract via email === | === Cognos extract via email === | ||
Generally the email from [[Decision Support Services]] arrives around | Generally the email from [[Decision Support Services]] arrives around anytime between 0700-1100. This can be delayed if the ETL that feeds the process is delayed. If it will be delayed [[Decision Support Services]] will send an email to Lisa. | ||
==== Process if the email does not arrive ==== | ==== Process if the email does not arrive ==== | ||
If the email has not arrived by | If the email has not arrived by 1100, we contact [[Decision Support Services]] (see that page for contact info, it keeps changing). | ||
=== Steps to import and roll-out === | === Steps to import and roll-out === | ||