1 / 11

Leveraging SAP BI Reporting

CBS Reports: Frquent changes to reporting formats. No standardization of reports many times as there are bank specific customizations.<br>

isabelfabiano
Download Presentation

Leveraging SAP BI Reporting

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. Leveraging SAP BI Reporting Framework To CBS reporting issues © Nelito Systems Ltd. 2013

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

  3. How Will We Resolve Issues Ease of customizat ions Flexibility in report formats Frequent changes to formats Ease of version control Non Bank Specific Customiza tions availability of report designer Report Designer Value added features Ease of deployme nt Deployme nt Pain points Maintainin g versions SAP BO with Web Intelligence challenges No value added features Limitations to DB Design Report Printing /Export / scheduling Ease of building static reports Address pain points of existing DB design SAP Crystal Reports Common Data Repository 3 © Nelito Systems Ltd. 2013

  4. Design Approach Common Data Repository - Improve DB design for better reporting such as Overdue , Product Balances will calculate and stored in EOD - Baseline for BO universe OLD CBS DB CDR RBI Reports Static Reports Other Like Letter Transactional , Day to day , Jotting,Maste rs AcId Br Code Br Code Br Code AcId AcId Overdue Overdue Overdue Balance Balance Balance Ac Name Ac Name Ad-hoc Reporting RBI All Master data data data All Master All Master Inspection, audit reports, Bank Specific Gender Gender Gender Int Rate IntRate Rate Int Hardware requirements - 4 core processor, 16 GB RAM for SAP BI and DI - 4 Core processor, 8 GB RAM, Microsoft SQLServer VS 2012 stadardEdition Meta data Version control 4 © Nelito Systems Ltd. 2013

  5. Implementation Approach Go Live Support & Training (4 weeks) SRS & Design (6 to 8 weeks) Development, unit Testing (8 to 10 weeks) Project Initiation ( 1 week) UAT (4 weeks) Activities • Go Live activities • Post Production Support • Training / Knowledge Transfer Activities • Perform User Acceptance Testing • Defect analysis and fixing Activities • Develop ETL process • Deploy BO Universe • Unit Testing for ETL • Develop Crystal Reports • Create Test plan • Write test cases 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 Deliverables • Crystal Reports • Adhoc reports • Test plan and test cases • Release plan for SIT Deliverables • Integration test results • SIT test report • Release plan for UAT Deliverables • Scope document • Design document • Development plan Deliverable • Project kick off presentation Req. from Bank • Support regards to environment availability • Signoff on reports • SIT signoff Req. from Bank • Timely support for clarification on requirements and design and review meetings • Signoff on requirement and design document. Req. from Bank • Readiness for UAT Environment before UAT starts 5 © Nelito Systems Ltd. 2013

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

  7. 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 Ad-hoc Reporting- WEBI Universe 7 © Nelito Systems Ltd. 2013

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

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

  10. 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 in- memory technology 10 © Nelito Systems Ltd. 2013

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

More Related