Cognos data import: Difference between revisions

(6 intermediate revisions by 2 users not shown)

Line 2:

== Process ==

[[Decision Support Services]] sends an automated email report to ~~Tina~~ 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.

[[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.

=== Cognos extract via email ===

Generally the email from [[Decision Support Services]] arrives around ~~7:40 +/~~-~~1hr~~. This can be delayed if the ETL that feeds the process is delayed.

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.

~~=== Outlook Rule in Tina's profile to get data to Pagasa and Lisa ===~~

Decision Support Services ~~emails a report to Tina. The report needs to go~~ to ~~Pagasa and~~ Lisa ~~so it can be imported and rolled out; this is accomplished by outlook rule "Cognos to Pagasa" in Tina's Outlook~~.

==== Process if the email does not arrive ====

If the email has not arrived by ~~9:30~~, we contact [[Decision Support Services]] (see that page for contact info, it keeps changing).

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 ===

Once the email arrives each morning we run [[LoadCognos.bat]] (if the .bat isn't visible, it is the file of type "Windows Batch File").

The import and roll-out is generally done by the first of the following who is available:

~~# [[Data Processor]]~~

# [[Database Manager]]

# [[Data Processor]]

# [[~~Process Analyst~~]]

==== What happens in the process ====

Line 33:

Line 30:

}}

=== Newly encountered units or services ===

=== Newly encountered units or services ===

If a unit or service is part of the import that is not already in our reference tables, an email will be sent ~~to Tina and Lisa~~. Lisa will ~~inform Tina~~ what the new unit/service is about and ~~Tina~~ will add it to the master version of CCMDB.accdb ~~accordingly~~.

If a unit or service is part of the import that is not already in our reference tables, the import process will catch this and an email will be sent. The recipients of the email are hard-coded in .

Lisa will investigate what the new what the new unit/service is about is about and whether it might affect our collection process or Julie's reports. She will then either add it to the master version [[CCMDB.accdb]] herself or ask Tina to do it.

==== Newly encountered units ====

@@ Line 2: / Line 2: @@
 == Process ==
-[[Decision Support Services]] sends an automated email report to Tina 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.
+[[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.
 === Cognos extract via email ===
-Generally the email from [[Decision Support Services]] arrives around 7:40 +/-1hr. This can be delayed if the ETL that feeds the process is delayed.
+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.
-=== Outlook Rule in Tina's profile to get data to Pagasa and Lisa ===
-Decision Support Services emails a report to Tina. The report needs to go to Pagasa and Lisa so it can be imported and rolled out; this is accomplished by outlook rule "Cognos to Pagasa" in Tina's Outlook.
 ==== Process if the email does not arrive ====
-If the email has not arrived by 9:30, we contact [[Decision Support Services]] (see that page for contact info, it keeps changing).
+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 ===
 Once the email arrives each morning we run [[LoadCognos.bat]] (if the .bat isn't visible, it is the file of type "Windows Batch File").
 The import and roll-out is generally done by the first of the following who is available:
-# [[Data Processor]]
+# [[Database Manager]]
-# [[Database Manager]]
+# [[Data Processor]]
-# [[Process Analyst]]
 ==== What happens in the process ====
@@ Line 33: / Line 30: @@
 }}
-=== Newly encountered units or services ===
+=== Newly encountered units or services === <!-- linked from  VBA via [New unit or service encountered during Cognos data import], fix there if this heading is changed -->
-If a unit or service is part of the import that is not already in our reference tables, an email will be sent to Tina and Lisa. Lisa will inform Tina what the new unit/service is about and Tina will add it to the master version of CCMDB.accdb accordingly.
+If a unit or service is part of the import that is not already in our reference tables, the import process will catch this and an email will be sent. The recipients of the email are hard-coded in .
+Lisa will investigate what the new what the new unit/service is about is about and whether it might affect our collection process or Julie's reports. She will then either add it to the master version [[CCMDB.accdb]] herself or ask Tina to do it.
 ==== Newly encountered units ====