210 likes | 219 Views
TRACES DataWareHouse State of play. Working Group 2 October 2013 Sanco BI. From 6th july Data dictionary, From CVEDP to … BusinessObjects reports with facelifts and naming convention BusinessObjects – Reporting platform scale BusinessObjects Reports BusinessObjects – Issues
E N D
TRACESDataWareHouseState of play Working Group 2 October 2013 Sanco BI
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
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
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
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
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%
BusinessObjects - Issues23 from TRACES team, SANCO Apps support, IT system)
BusinessObjects - Validation Reports in the starting blocks
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.
QlikView - Validation CVEDA_Rolling V3.1 CVEDP_Rolling V2.1 INTRA_Rolling V2.1
BusinessObjects – Short future Next week System upgrade will be implemented (new DB server) DataWareHouse site will be unavailable QlikView remains active
BusinessObjects reports – Near future • CHEDPP • With the data dictionary
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
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
QlikView – The future combined model • Prototype V0.7.4.0 - global view
QlikView – The future combined model • Prototype V0.7.4.0 – dynamic sheet labels
QlikView – SANCO BI question • Server license limit upon the number of reports • SANCO BI analyze: How many years to freeze?