how city of chicago saved 200k$ upgrading to bi4.2 using 360suite

How City of Chicago is migrating to SAP Business Objects 4.2 with 360 SuiteSID #Sebastien Goiffon, GB&Smith Dariusz Zyskowski, City of Chicago

Presentation slides for all ASUG BI + Analytics Conference sessions can be found at:

http://bit.ly/bia16slides

-or- Receive a flash drive with all slide decks if you complete 8 or more

session evaluations in the mobile app.

PRESENTATION MATERIALS


TELL US WHAT YOU THINK

TAKE THE SESSION SURVEY:

Be sure to complete the session evaluation on the “ASUG BI + Analytics” mobile app.

Download the app from iPhone App Store or Google Play.

HOW CITY OF CHICAGO:

• Prepared for 4.2 migration using 360 Suite• Boosts their SAP Business Objects environment with 360

reports and other features• Implements incremental backup & audits their deployment

with GB&SMITH’s 360 Suite

Dariusz Zyskowski, BI Manager City of Chicago

BUSINESS OBJECTS AT THE CITY OF CHICAGO

• Since 2000 (5x, 6x, XI R2, 3.1, 4.2 – in 2016)• Primary reporting tool for the city (311, 911, Police,

Fire, W2’s, Purchase Orders, Invoices)• 1500 users• 90 PROD universes• Webi, Deski, Rich Client, Crystal• 96,000 reports (18,000 Deski) – 130K before 360• Two clustered PROD servers + TEST + DEV• ~800 reports scheduled daily

360VIEW, 360PLUS, 360EYES AND 360BIND

1. Content analysis to prepare for 4.2 migration- Intelligently remove additional 25K reports (especially DESKI)- Audit/migrate only valid and used universes- Analyze and delete unbound users- Automatic converted/migrated report comparison using BIND

(cost saving of over $200,000 in consulting fees)

2. BO environment audit and management- Real time view without running a Webi report- Easy access to many AUDIT reports- Back up (Recycle Bin) and disaster recovery- Multiple BO environments comparison and content transfer- Maintain clean and unclogged environment

360VIEW, 360PLUS, 360EYES AND 360BIND

4.2 Migration Challenges• How do you prepare and conduct a successful BO migration with VERY

limited resources?• How to mitigate risks related to migration (time consuming analysis,

migration and conversion efforts, regression testing, post migration assistance)

• Can you trust RCT with fully converted Deski reports? (answer: no way)• Business owners’ cooperation• Our solution: 360 products which automated many of the above tasks

CONTENT ANALYSIS TO PREPARE FOR 4.2 MIGRATION

Program jobs run in Webi


42 reports

4 universes

CONTENT ANALYSIS TO PREPARE FOR 4.2 MIGRATIONOut of the box reports

360eyes DASHBOARD - 03 Recycle Licenses360eyes DASHBOARD - 02 CMS through time360eyes DASHBOARD - 04 Universes360eyes DASHBOARD - 01 CMS

360eyes CMS - 06 Connections detail360eyes SECURITY - 08 Right details360eyes CMS - 05 Overloads summary360eyes CMS - 07 Users by Last Logon Time

360eyes CMS - 16 Universe and Document Relationship

360eyes CMS - 14 Document and Instance size360eyes CMS - 17 User Group Membership360eyes CMS - 11 Universe Security Matrix360eyes CMS - 19 Compare Universe Security360eyes CMS - 18 Compare Folder Security360eyes CMS - 13 Document Scheduled Jobs360eyes CMS - 10 Folder Security Matrix360eyes CMS - 12 Unjustified Explicit Rights

360eyes REPORT - 30 Compare documents360eyes REPORT - 31 Track duplicated reports360eyes REPORT - 42 Track non-empty documents360eyes REPORT - 40 Report Documentation360eyes REPORT - 41 Number of documents per universe360eyes REPORT - 52 Impact Analysis (SQL DP)360eyes REPORT - 51 Impact Analysis (SQL Universe Object)360eyes REPORT - 50 Impact Analysis (Universe object)

360eyes REPORT - 60 Last documents use360eyes REPORT - 61 Universe usage rate360eyes REPORT - 62 User actions list360eyes REPORT - 63 User activity360eyes UNIVERSE - 71 Compare universes

360eyes UNIVERSE - 70 Universe Documentation360eyes UNIVERSE - 72 Unused universe objects

360eyes COMPLIANCE - 81 Users through time360eyes COMPLIANCE - 80 User List360eyes COMPLIANCE - 82 Users deployed licenses360eyes COMPLIANCE - 84 Server Info360eyes COMPLIANCE - 83 Users deployed licenses through time360eyes COMPLIANCE - 85 Recycle Licenses


BO environment dashboard – number of reports, report type + universes

360BIND – CONVERTED/MIGRATED REPORT COMPARISON

• Automated regression testing after Deski report conversion (fully converted) and/or migrated Webi reports

• Totals and pixel to pixel (image) comparison via two XML outputs• With over 100,000 reports to migrate – no need to beg users to validate

their reports • Minimum implication or solicitation of end users• Enormous time and cost saving benefit (estimated over $200,000 in consulting fees)

360 BindWebi migration/Deski conversion


• Future Business Objects upgrades, updates or patch installation

• Universe modification testing• Any other update such as database or OS

360 BindFuture post migration use


3.1 Reports schedule

Deski/Webi XML/Excel

exports

3.1 BIND 4.2 BIND

4.2 Reports schedule

migrated Webi reports/conve

rted Webi versions

XML/Excel Files for comparison


Data Comparison


Image/Charts Comparison

REAL TIME VIEW WITHOUT RUNNING A REPORT

REAL TIME VIEW WITHOUT RUNNING A REPORT - USERS

REAL TIME VIEW WITHOUT RUNNING A REPORT

• Add a user• Insert• Remove• Delete• Group Membership• Bulk User

Management• Excel Output• Purge Inboxes

• Copy/Move/Shortcut• Delete• Excel Output• Purge Webi

Users Objects Universes

• Copy/Move• Delete• Excel Output

Security• Same capabilities as in CMC• Immediate Excel report on

any group/user and rights matrix

UNIVERSES CHANGE – MASS REPORT UPDATE

Update/Change universe name – mass report update feature

REAL TIME VIEW WITHOUT RUNNING A REPORT – AUDIT

BACKUP AND RECOVERY (RECYCLE BIN)

1. Sizable empty DB for back up content2. Empty folder on a server/NAS/SAN with plenty of disk space3. SMTP server properties for Email notifications4. Schedule backup jobs

• Small BO installations – on a root level• Large BO installations – several jobs (universes, users, reports)

5. Run every day

Prerequisites:

BACKUP AND RECOVERY (RECYCLE BIN)

BACKUP AND RECOVERY – HOW TO RECOVER A DELETED REPORT

1. Select object type tab and click on the Recycle Icon

2. Enter search parameters

3. Deleted report is found in the recovery DB (if it was part of a back up job that run before it was deleted)

4. Import deleted report back to PROD – including any instances if necessary5. Report is back in its original location

DISASTER RECOVERY OF ENTIRE BO ENVIRONMENT

MULTIPLE BO INSTALLATIONS COMPARISON AND CONTENT TRANSFER

Ability to log into more than one BO environment for side to side comparison and content transfer

MULTIPLE BO INSTALLATIONS COMPARISON AND CONTENT TRANSFER

Content transfer – drag and drop

360 - CONCLUSION

• Much better understanding of our BO environment• Easier and more intelligent object clean up process• Great help in preparation and cost saving for 4.2 migration• Immediate access to Audit data• Simplified disaster recovery and recycle bin features

Challenges• Initial 360 job run time (next runs are incremental)

• Few not very intuitive options (document retrieval, content transfer)

• Make time to read install and user manuals (well worth it)

• Better 360 View interface

Benefits

Presentation slides for all ASUG BI + Analytics Conference sessions can be found at:


-or- Receive a flash drive with all slide decks if you complete 8 or more

session evaluations in the mobile app.

PRESENTATION MATERIALS


REMINDER: TELL US WHAT YOU THINK

TAKE THE SESSION SURVEY:

Be sure to complete the session evaluation on the “ASUG BI + Analytics” mobile app.

Download the app from iPhone App Store or Google Play.

how city of chicago saved 200k$ upgrading to bi4.2 using 360suite

Software