Leveraging SAP BI Reporting Framework To CBS reporting issues Š Nelito Systems Ltd. 2013
Pain Areas for CBS Reports Frequent changes to reporting formats No standardization of reports many times as there are bank specific customizations Non availability of report designer
Version control for reports becomes a challenge in the midst of changes Database design may have limitations that has impact on generating reports Deployments of the reports may have challenges
Non availability of value added features in reporting framework 2 Š Nelito Systems Ltd. 2013
How Will We Resolve Issues
Non availability of report designer
Deployme nt challenges
No value added features
Frequent changes to formats
Pain points
Ease of customizat ions
Flexibility in report formats
Bank Specific Customiza tions
Report Designer Ease of deployme nt
Maintainin g versions
Ease of version control
Value added features
SAP BO with Web Intelligence
Limitations to DB Design
Address pain points of existing DB design
Ease of building static reports
Report Printing /Export / scheduling
SAP Crystal Reports Common Data Repository 3 Š Nelito Systems Ltd. 2013
Design Approach Common Data Repository
OLD CBS DB
CDR
- Improve DB design for better reporting such as Overdue , Product Balances will calculate and stored in EOD - Baseline for BO universe
RBI Reports Static Reports Br Code Br Code
Ac Name
Int Rate Int Rate
AcId AcId
Balance Balance
Other Like Letter
Transactional , Day to day , Jotting,Maste rs
Ad-hoc Reporting
RBI Inspection, audit reports, Bank Specific
Overdue Overdue
All Master All Master datadata Gender Gender
Hardware requirements
Meta data
Version control
- 4 core processor, 16 GB RAM for SAP BI and DI - 4 Core processor, 8 GB RAM, Microsoft SQLServer VS 2012 stadard Edition 4 Š Nelito Systems Ltd. 2013
Implementation Approach Project Initiation ( 1 week)
SRS & Design (6 to 8 weeks)
Activities • Project Kick-Off • Resource onboarding
Activities • Document scope • Understand CBS DB Design and pain points • Design for CDR • Design of BO Universe • Design of ETL process • Review and signoff on the design
Deliverable • Project kick off presentation
Deliverables • Scope document • Design document • Development plan Req. from Bank • Timely support for clarification on requirements and design and review meetings • Signoff on requirement and design document.
Development, unit Testing (8 to 10 weeks) Activities • Develop ETL process • Deploy BO Universe • Unit Testing for ETL • Develop Crystal Reports • Create Test plan • Write test cases
Deliverables • Crystal Reports • Adhoc reports • Test plan and test cases • Release plan for SIT Req. from Bank • Readiness for UAT Environment before UAT starts
UAT (4 weeks)
Activities • Perform User Acceptance Testing • Defect analysis and fixing
Go Live Support & Training (4 weeks) Activities • Go Live activities • Post Production Support • Training / Knowledge Transfer
Deliverables • Integration test results • SIT test report • Release plan for UAT Req. from Bank • Support regards to environment availability • Signoff on reports • SIT signoff
5 © Nelito Systems Ltd. 2013
Report Writing Tool - SAP Business Objects Enterprise 4.x Web Intelligence:- Web based ad-hoc reporting tool allowing multiple data point and dimensional analysis feature. It also acts as self service reporting as it has excel friendly analysis options.
Solution Highlights Interactive and intuitive web-based Interface
Quickly answer a business question Data lineage- Keep track of any data modification Combine multiple sources within an analysis Offline and online query and analysis
Reusable objects sorting, filtering, changing the layout, sectioning, turning to chart, adding column, cell, variable, formula, chart, report, drilling, setting alerters,…
More interactive options like ,
6 © Nelito Systems Ltd. 2013
Static Reporting – Crystal Reports Crystal Reports for enterprise :- A pixel perfect static reporting tool which can connect many backend sources like RDBMS, OLAP, XML etc. and Universe. Solution Highlights – Can view in any browser
Work on prebuild Universe Interactivity with dynamic drill down , charts , graphics and even videos Less Learning curve Static Reports- Crystal Reports
SAP Universe
Ad-hoc ReportingWEBI
7 © Nelito Systems Ltd. 2013
BI Intelligence for all Executives: Performance Management XCelsius Scorecards and Dashboards
Analysts: (Webi) Query and Analysis Ad hoc query and reporting Interactive analysis
Information consumers: Operational Reporting Crystal Report Receive reports Refresh, prompt
Business Intelligence - SAP Business Objects Enterprise 4.x Dashboards:- Flashy and glossy way of representing data and meant for the power users. Also provides what if capability.
Solution Highlights – Bank performance status in on glance Interactive visual models – Present complex business clearly and dynamically Personalize dashboard – Present the data decision makers need in the most useable form for each viewer Secured data access- Maintain control in each dashboard
9 © Nelito Systems Ltd. 2013
Business Intelligence - SAP Business Objects Enterprise 4.x Explorer:- Self service BI providing answers to your business questions in most optimized fashion. It is 360 degree data exploration tool.
Explore all your data …. Automated relevancy and chart generation Highly visual data exploration – No data knowledge require Accelerated the version with inmemory technology
10 © Nelito Systems Ltd. 2013
THANK YOU Get in touch 205-208 Bldg 2, Sector 1 Millennium Business Park Navi Mumbai 400 710 Tele: (+91-22) 6713 5555, 6713 5600
Fax: (+91-22) 6713 5503
© Nelito Systems Ltd. 2013