Leveraging SAP BI
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

Leveraging SAP BI Reporting PowerPoint PPT Presentation


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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Leveraging sap bi reporting

Leveraging SAP BI

Reporting Framework

To CBS reporting issues

© Nelito Systems Ltd. 2013


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


Leveraging sap bi reporting

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


  • Login