1 / 21

TRACES DataWareHouse State of play

Explore the current status and future plans regarding the TRACES Data Warehouse, including issues and advancements in BusinessObjects and QlikView reports. Learn about data validation, activity logs, and upcoming changes in the BI environment.

edwardparker
Download Presentation

TRACES DataWareHouse State of play

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. TRACESDataWareHouseState of play Working Group 2 October 2013 Sanco BI

  2. From 6th july • Data dictionary, From CVEDP to … • BusinessObjects reports with facelifts and naming convention • BusinessObjects – Reporting platform scale • BusinessObjects Reports • BusinessObjects – Issues • BusinessObjects – Validation • QlikView • QlikView - Issues • QlikView - Validation • BusinessObjects / QlikView – Availabilty • BusinessObjects – Activity • QlikView – Activity

  3. BusinessObjects – Short future • BusinessObjects reports – Near future • QlikView • QlikView – Current environment before the step • QlikView – One step further… • QlikView – The future 'Combined model' (2) • QlikView - SANCO BI request / proposal

  4. From 6th July • Data dictionary ,From CVEDP • to CED, CVEDA , CVEDP, IMPORT, INTRA Release Date : 2/7/2013 Release Date : 29/10/2012 Release Date : 29/10/2012 Release Date : 18/1/2013 Release Date : 18/1/2013

  5. From 6th July • BusinessObjects reports with facelifts and naming convention • CED : 12 • CVEDA : 8 • CVEDP : 8 • IMPORT : 6 - Data dictionary under review (SB2116) • INTRA : 28 • Data dictionary under review

  6. From 6th July • BusinessObjects - Reporting Platform scale • Activity : from 10920 (6/7/2012)  16084 logins (28/09/2013) • Concurrent users : from 77 to 94 + 22%

  7. BusinessObjects - Issues23 from TRACES team, SANCO Apps support, IT system)

  8. BusinessObjects - Validation Reports in the starting blocks

  9. BusinessObjects / QlikView – Availabilty • From 6th of july : 452 days elapsed • BusinessObjects : 11 days off 97,5% • QlikView : 3 days off 99,3% • 25/04/2013 SB1823 : Power supply maintenance. • 18/10/2012 SB1330 SB1425 : Upgrade to new release (V11 SR2). • 07/09/2012 SB1323 : IT problem, technical account locked.

  10. QlikView – Issues29 with your feedback for improvement

  11. QlikView - Validation CVEDA_Rolling V3.1 CVEDP_Rolling V2.1 INTRA_Rolling V2.1

  12. BusinessObjects – Activity

  13. QlikView – Activity

  14. BusinessObjects – Short future Next week System upgrade will be implemented (new DB server) DataWareHouse site will be unavailable QlikView remains active

  15. BusinessObjects reports – Near future • CHEDPP • With the data dictionary

  16. QlikView – Current environment before the step • ‘Rolling’ dashboards : 4- 1 report / certificate type- 18 months of data- Respective sizes: 11 MB 158 MB 199 MB 201 MB

  17. QlikView – One step further… 'Combined model' • - 1 report with ALL certificates types- All years : 9 years • - Average size (CED not included): 53 MB (1 to 189) for 88% 905 MB (224 to 1570) for 12% 2 reports with 1,5 GB, 2 reports with 257 MB and 224 MB • Reach the limits of In Memory computing

  18. QlikView – The future combined model • Prototype V0.7.4.0 - global view

  19. QlikView – The future combined model • Prototype V0.7.4.0 – dynamic sheet labels

  20. QlikView – SANCO BI question • Server license limit upon the number of reports • SANCO BI analyze: How many years to freeze?

  21. Questions?

More Related