1 / 17

TRACES DWH

TRACES DWH. Traces Datawarehouse reports issues (2) Traces Datawarehouse Working Group of 5 may 2011, requests (3) … and our works in progress (BO XI prompts ;CVEDA, CVEDP, INTRA) (4-9) DWH Architecture overview, new servers (10) New BO XI interfaces (11) Technical issues in progress (12)

wgalindo
Download Presentation

TRACES DWH

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TRACES DWH • Traces Datawarehouse reports issues(2) • Traces Datawarehouse Working Groupof 5 may 2011, requests(3) • … and our works in progress (BO XI prompts ;CVEDA, CVEDP, INTRA)(4-9) • DWH Architecture overview, new servers(10) • New BO XI interfaces(11) • Technical issues in progress(12) • DWH dashboards,Existing dashboards (test)(13)CED, main page, selection pages and report(14-16) • Questions and answers(17) Friday18 november 2011 State of playof the Datawarehouse reports SANCO A4, Sanco BI

  2. TRACES DWH Traces datawarehouse reports issues INTRA Ad’hoc report V9.4 empty column titles, quantity too high 14/11/2011 (SB591) solved CVEDAand CVEDP SCWH011 Laboratory tests V8 multiple test values displayed 08/09/2011 (SB483) workaround applied and will be fixed with TRACES V5.30 CVEDP SCWH003B Quantity V8 no direct cncode input available 07/09/2011(SB466) will be fixed with TRACES V5.30 INTRA SCWH13 Ad’hoc V8.0 refreshing destination impossible 12/07/2011 (SB410) V9.4 (selection of origin and destination LVU) V9.5.(origin and destination postal codes)INTRA SCWH005A and 005B V8.0 refreshing time too long 12/05/2011 (SB348) V8.01 provided SANCO A4, Sanco BI

  3. TRACES DWH Traces Working Group requests TRACES Working group requests implementations (SB376)  categories status report (SB415), already available in the current datawarehouse site second phase (updates within reports BOXI)  CVEDA, new prompts 'For import or admission' (SB434),  new prompts 'Animals certified as' (SB435),  new prompts 'Consignment purpose' boxes 18,19,20 (SB436),  CVEDP, new prompts 'Veterinary approval numbers' box 10 (SB438),  new prompts 'Consignment purpose' boxes 17,18,20 (SB437),  INTRA, new prompt 'Departure dates' box15 (SB439),  new prompt 'Animals/Producst certified as' box25 (SB441),  Within all the reports, labelling when no data available (SB433),  New field, Creation date (SB383), will be included with TRACES V5.30 CVEDA, new version of all CVEDA reports (SB583) from TRACES V5.30 within BOXI server  CVEDP, new version of all CVEDP reports (SB584)  INTRA, new version of all INTRA reports (SB582) SANCO A4, Sanco BI

  4. TRACES DWH … our works in progress : categories status report SANCO A4, Sanco BI

  5. TRACES DWH … our works in progress : CVEDA (SB435), (SB434), (SB436), SANCO A4, Sanco BI

  6. TRACES DWH … our works in progress : CVEDP (SB438), (SB437), SANCO A4, Sanco BI

  7. TRACES DWH … our works in progress : INTRA (SB439), Note : V9.5 will include (SB441), SANCO A4, Sanco BI

  8. TRACES DWH … our works in progress : INTRA V9.4 versus V9.5 SANCO A4, Sanco BI

  9. TRACES DWH … our works in progress when no data available … (SB433), SANCO A4, Sanco BI

  10. TRACES DWH DWH Architecture overview, new servers SANCO A4, sanco bi team

  11. TRACES DWH New BO XI interfaces SANCO A4, sanco bi team

  12. TRACES DWH Technical issues in progress… SANCO A4, sanco bi team

  13. TRACES DWH DWH Dashboards, existing dashboards (within DG SANCO test server) Document with Qlikview documents views will be available on CIRCA SANCO A4, sanco bi team

  14. TRACES DWH CED, Main page SANCO A4, sanco bi team

  15. TRACES DWH CED, Part I Part II SANCO A4, sanco bi team

  16. TRACES DWH CED, Report SANCO A4, sanco bi team

  17. TRACES DWH Questions and answers ? SANCO A4, sanco bi team

More Related