webinar: city of cape town's sap bi adventure · city of cape town’s sap bi adventure –the...
TRANSCRIPT
City of Cape Town’s SAP BI Adventure
–The Audio for this event is being streamed live to your computer.
–To listen, Please connect PC speakers or headphones to your
computer.
–International Toll : +1 (212 )444 0889
–US / CAN Toll Free : +1 (866) 651 8117
–Passcode : 696899
Zimkhita Buwa SAP BI Consultant
Lynn Van Rooyen SAP BI Consultant
TODAY:
Population: 3,7 million
Share of National GDP: 15.9 %
Rateable Properties: 933 608
Employees: 23 579
SAP Users: 19 131
City of Cape Town annual budget 2012/13:
Operating: R24,4 billion (USD 2.82 billion)
Capital: R 5,9 billion (USD 0.68 billion)
City of Cape Town at a Glance
The SAP Journey 2002 - 2012
BO Development
BOE XI3.1 SP3.1
BO Production
BOE XI3.1 SP3.1
Bu
sin
ess
Ob
ject
s
SSM Development
SSM Production
SSM7.5 SP6
Str
ate
gy
Ma
na
gm
nt
SSM7.5 SP6
Current BI Landscape
BI Connector BI Connector
Universe/MDX
BICS/BAPI
Universe/MDX
BICS/BAPI
Source
Systems Source
Systems
BW Development
BW Production
NW7.3 SPS5.0 NW7.30 SPS5.0
Bu
sin
ess
Inte
llig
ence
BI Go-Live
2006 Launch with stations demonstration each
area
Roughly 6 months
Primarily standard content
Limited Areas[Modules (FICA, CCA, PS, HR, MM)]
Business Involvement
Initial Go Live limited
PS and FICA, CO were partially Business Driven
HR and SD where created first then shown to the
business
Post Go Live
Post BI Go Live
Accounts Payable
Accounts Receivable Consumption Data
Real Estate
HR Management
Data
Greater involvement from Business
Identifying the Headache
Activated BI Technical
Content / BI Statistics
Initially activated for BI Admin
Cockpit for monitoring
process chains.
Used it for tracking usage
Front-End and OLAP
Statistics
LOW USER ADOPTION
Identifying the Headache
BI Users = 2754
Average % BI Usage = 22%
Identifying the Headache
User Responses regarding BI:
o Struggle to find reports
o Not intuitive
o Don’t know the Balanced
Scorecard methodology
o “I don’t trust the data!”
o “Those BI Reports are too
slow”
V3.5
V7.0
Measurement
5 Home-made Remedies
Product
Image
Marketing
&
Comms
Product
Endorsement
Product
Quality &
Delivery
Passion
Product Image
Objective: To re-energise the look and
feel of BI page on the portal.
o Scheduled design workshops with
relevant stakeholders to provide input
into proposed structure changes.
Outcome: Slicker Page
o Regrouping and consolidation of Tabs
for easier access.
o Migration of reports into one version
(version 7).
o Renaming of some reports (easier to
identify for end user).
Product Image
Product Image
Product Image
Marketing and Communication
Internal Marketing Drive (ERP Floor).
External Drive: Executive Management
Team
Quarterly Newsletter.
o Awareness for potential new users and
the current BI community.
o Not shy about marketing BI successes!
Communiqué on all changes
o New reports/dashboards
o Modifications to reports
Marketing and Communication
Marketing and Communication
Product Quality and Delivery
“I don’t trust the data”
Streamlining Batch Monitoring
Process.
Admin Cockpit to view
process chain status.
Send out Batch email to functional
analysts and key business
users(communication!!)
Too many aggregates on a cube
Prolonging Batch
Not effective
Aggregates
Broadcasting
Cannot run with batch
Severe performance issues when run during the day
Not effective
Time to go BIGGER
BIA Strategy
The WHAT
To Improve performance of
o Queries used in BOBJ Dashboards
o Long running and most used queries
o Ad-hoc Processes
The HOW
Rationalise existing cubes to save space while keeping
the expenditure to a minimum
o Split cubes into current and history
o BI-A enable Current Year cubes
“Those reports are far too slow”.
Results
Area Report Name Original run
time -
Aggregates(s)
BI-A run time
(s)
% Improvement
Cost Centre
reporting
R&M:
Actual/Plan/Commitments: Per
Cost Element
355.15 12.35 97%
Cost Centre
reporting
Actual/Plan/Commitments: Per
Cost Element
389.5 5.55 99%
Profit centre
accounting
Act/Plan: Rev: Per Period:
Subj Cat: Current Year
324.1 8.4 97%
Product Quality and Service
The WOW factor!
2008
Installed on UNIX platform
Struggled with installation – many issues
Slow take up due to performance issues
Published via Netweaver Portal
Enables the ability to quickly identify performance issues within the
organisation.
Deliver more timely information no more costly manually intensive
methods of disseminating information.
Extended our customer base (executive level)
Product Quality and Service
Dashboard Architecture
BW Query
Dashboard
BICS
BI 4.0
Upgrade to BI4.0 SP4
o BOBJ our future roadmap
o Do not want to duplicate our efforts by developing in old version
Benefits
o Promise of better integration with Netweaver
o Improve lag times when deploying dashboards
How far is it?
o We have installed XI4 on a separate box, but still struggling to
migrate current dashboards and Documents
Challenges?
o Working on installation on AIX box
Strategy Management
BI CONNECTOR ADMINISTRATION
TOOL
ENTRY &
APPROVAL SSM END-USER
INTERFACE
Upgrade to SSM10
Upgrade from SSM7.5 SP6 to SSM10 SP5
Moving from a Windows plaftform to AIX
New functionality:-
o 7 scorecard levels which can be freely defined by user like
o User-defined subjective assessment (user status) & associated
subjective assessment comment(which can be printed)
Up to 3 User-defined fields to provide additional context
SSM10
Operational Review - now a Briefing Book (data
can be refreshed).
SSM10
LATEST Dashboard Usage
Product Endorsement
CIO and ERP Floor Manager
o Endorses BI at all levels.
o Forward thinking and visionaries.
Executive Buy-in – councillor level
Important to have buy in at the operational level
o Functional Analysts who interact directly with the
business.
o Trainer - passionate about BI(presented value of BI in
PM at Mastering SAP PM).
HR is one of our biggest clients
o HR Strategic Managers endorse BI in the Quarterly
Newsletter.
BI Successes
Corporate Works Management
Process in PM(Average Days to
Close - Notifications).
Compilation of 78 statutory
National Treasury
reports.(Workbook)
Management Reports(Webi)
Saving in Time: Councillor
Portfolio Report.
ITSM Dashboard presented at
SAPHILA
BI Competency Centre - change management & marketing
are critical to the success of BI Implementation.
Requires continuous involvement and commitment from the
BI Team.
Tapping into the passion of others:-
o AFSUG BI SIG
o SCN
o Conferences
o SSM Customer Advisory Webinars
o Social Media(Twitter/LinkedIn)
Passion
Thank you
© 2012 SAP AG. All rights reserved. 49 Public
© 2012 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose
without the express permission of SAP AG. The information contained herein may be
changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary
software components of other software vendors.
Microsoft, Windows, Excel, Outlook, PowerPoint, Silverlight, and Visual Studio are
registered trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x,
System z, System z10, z10, z/VM, z/OS, OS/390, zEnterprise, PowerVM, Power
Architecture, Power Systems, POWER7, POWER6+, POWER6, POWER, PowerHA,
pureScale, PowerPC, BladeCenter, System Storage, Storwize, XIV, GPFS, HACMP,
RETAIN, DB2 Connect, RACF, Redbooks, OS/2, AIX, Intelligent Miner, WebSphere, Tivoli,
Informix, and Smarter Planet are trademarks or registered trademarks of IBM Corporation.
Linux is the registered trademark of Linus Torvalds in the United States and other countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are trademarks or registered
trademarks of Adobe Systems Incorporated in the United States and other countries.
Oracle and Java are registered trademarks of Oracle and its affiliates.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin
are trademarks or registered trademarks of Citrix Systems Inc.
HTML, XML, XHTML, and W3C are trademarks or registered trademarks of W3C®,
World Wide Web Consortium, Massachusetts Institute of Technology.
Apple, App Store, iBooks, iPad, iPhone, iPhoto, iPod, iTunes, Multi-Touch, Objective-C,
Retina, Safari, Siri, and Xcode are trademarks or registered trademarks of Apple Inc.
IOS is a registered trademark of Cisco Systems Inc.
RIM, BlackBerry, BBM, BlackBerry Curve, BlackBerry Bold, BlackBerry Pearl, BlackBerry
Torch, BlackBerry Storm, BlackBerry Storm2, BlackBerry PlayBook, and BlackBerry App
World are trademarks or registered trademarks of Research in Motion Limited.
Google App Engine, Google Apps, Google Checkout, Google Data API, Google Maps,
Google Mobile Ads, Google Mobile Updater, Google Mobile, Google Store, Google Sync,
Google Updater, Google Voice, Google Mail, Gmail, YouTube, Dalvik and Android are
trademarks or registered trademarks of Google Inc.
INTERMEC is a registered trademark of Intermec Technologies Corporation.
Wi-Fi is a registered trademark of Wi-Fi Alliance.
Bluetooth is a registered trademark of Bluetooth SIG Inc.
Motorola is a registered trademark of Motorola Trademark Holdings LLC.
Computop is a registered trademark of Computop Wirtschaftsinformatik GmbH.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer,
StreamWork, SAP HANA, and other SAP products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks of SAP AG in Germany
and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal
Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services
mentioned herein as well as their respective logos are trademarks or registered trademarks
of Business Objects Software Ltd. Business Objects is an SAP company.
Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase
products and services mentioned herein as well as their respective logos are trademarks or
registered trademarks of Sybase Inc. Sybase is an SAP company.
Crossgate, m@gic EDDY, B2B 360°, and B2B 360° Services are registered trademarks
of Crossgate AG in Germany and other countries. Crossgate is an SAP company.
All other product and service names mentioned are the trademarks of their respective
companies. Data contained in this document serves informational purposes only. National
product specifications may vary.
The information in this document is proprietary to SAP. No part of this document may be
reproduced, copied, or transmitted in any form or for any purpose without the express prior
written permission of SAP AG.