Wiiisdom | Analytics Governance SolutionsWiiisdom | Analytics Governance Solutions
  • Solutions
    • By Initiatives
      • analyticsops-solution AnalyticsOps
      • technology-solution Embedded Analytics
      • icon-scale-analytics Scale Analytics
      • icon-regulatory-compliance Regulatory Compliance
      • icon-enable-rpa Enable RPA
      • icon-cloud-analytics Move to the Cloud
    • By Industries
      • financial-solution Financial
      • government-solution Government
      • healthcare-solution Healthcare
      • insurance-solution Insurance
    • By Technologies
      • sap-bo SAP BusinessObjects
      • sap-data-services SAP Data Services
      • tableau-software Tableau
      • power-bi Power BI
  • Products
    • wiiisdom-ops Wiiisdom Ops
      • tableau-software Wiiisdom Ops for Tableau
      • sap-bo Wiiisdom Ops for SAP BusinessObjects
      • power-bi Wiiisdom Ops for Power BI
    • 360suite 360Suite for SAP BusinessObjects
      • favicon-eyes 360Eyes
        Metadata & Impact Analysis
      • favicon-live 360Live
        Live Monitoring
      • favicon-bind 360Bind
        Automated Regression Testing
      • favicon-univ 360Univ
        Universe Management Tool
      • favicon-cast 360Cast
        Report Bursting & Scheduling
    • 360suite 360Suite
      • favicon-view 360View
        Administration & Maintenance
      • favicon-plus 360Plus
        Disaster Recovery, Backup & Promotion
      • favicon-vers 360Vers
        Versioning & Lifecycle Management
      • favicon-safe 360Safe
        License Compliance
      • favicon-init 360Init
        Project Creation
  • Resources
    • Resource Center
    • Webinars
    • Events
  • About Us
    • Our Mission
    • Careers
    • Partner Program
    • News
  • Contact Us
0 0   
By Ailsa Cartledge SAP BusinessObjects 360Suite Customer Stories May 22, 2019

Solving SAP BusinessObjects Challenges
with 360Suite Solutions
at Johnson Financial Group

johnson-financial-group-success-story

financial-icon 

Financial Services

Products Used:

360View 360Eyes

360Bind 360Cast

Family Business

Johnson Financial Group is a privately held, full-service financial services company based in Racine, Wisconsin. The Chairman of the Board, Helen Johnson Leipold, is the daughter of founder Samuel C. Johnson and a fifth generation member of the Johnson family. Today, more than 1,300 Johnson Financial Group associates provide banking, wealth, and insurance solutions to customers in Wisconsin, Arizona, and Minnesota.

Growing Pains

As Johnson Financial Group matures and evolves, it has required more sophisticated business intelligence reporting and, in 2013, the company licensed SAP BusinessObjects. Although the SAP BusinessObjects environment at Johnson Financial Group is modest in size, with about 375 users, 140 Universes, and 900 reports in production, it’s growing and touches nearly every part of the business, from operations to sales to human resources. Due to Johnson Financial Group’s growth, managing SAP BusinessObjects using native resources became challenging, and BI managers found user questions increasingly difficult to answer. An internal SharePoint upgrade project finally brought the situation to a head.

Suite Solutions

In 2018, a Johnson Financial Group Assistant Vice President and Business Intelligence Application Specialist bumped into a counterpart from another bank, who sang the praises of 360Suite. 360Suite software offered a potential solution to the SharePoint upgrade problem, so Johnson Financial Group calculated the return on investment, gave the software a trial run, and ultimately embraced several 360Suite solutions, including 360Eyes, 360View, 360Cast, 360Plus, and 360Bind. In the first few months of implementation, Johnson Financial Group experienced several successes with 360Suite, as highlighted in the following cases.

Use Case #1: SharePoint Upgrade

Johnson Financial Group schedules a large number of SAP BusinessObjects reports by exporting and saving them as Excel or PDF files, and then delivering them somewhere on the network, often to the SharePoint platform. As a result of the Johnson Financial Group SharePoint upgrade project, hundreds of scheduled report instances required a path change from the old SharePoint environment to the new one. Johnson Financial Group calculated that it would take at least 78 man hours to perform this task manually. Instead, the company was able to perform the task in just a few hours by using 360Suite to: 1) identify all 400 report instances that were scheduled to publish to SharePoint, 2) pause the scheduled jobs while SharePoint was being updated, and 3) update all SharePoint paths in bulk before resuming the scheduled jobs.

Learn how to publish Business Objects reports to SharePoint Online with 360Cast

Use Case #2: Universe Maintenance

Johnson Financial Group recognized the need to clean up a particular SAP BusinessObjects Universe that contained repetitive field names and tables with duplicate fields, but cleaning up the Universe was complicated by a lack of understanding about when, how, and where fields were being used. Without this information, BI Administrators couldn’t predict how changes would impact existing reports or ensure that, by fixing one problem, they wouldn’t create another problem. It was virtually impossible to unravel this mess manually, but 360Suite made it easy for Johnson Financial Group to analyze impact down to the object level, and clean up the Universe without breaking any reports in the process.

Use Case #3: Information Gathering & Reporting

At Johnson Financial Group, every report in production must have a corresponding SharePoint Wiki detailing the contents of the report, and a quarterly audit ensures compliance with this requirement. Until recently, Johnson Financial Group relied on the SAP BusinessObjects Query Builder to gather information needed by the auditor, a process that was long, tedious, and complicated. Now, Johnson Financial Group takes advantage of 360Suite platform to identify all reports located in public folders and the instances attached to them.

query-builder-limitations
Learn how to overcome
the limitations of Query Builder

 

Use Case #4: Data Extract Conversions

Johnson Financial Services uses SAP BusinessObjects to create data feeds — about 120 file extracts per month. Although the data warehouse team prefers to receive data as pipe delimited text files, it’s impossible to create this format with SAP BusinessObjects, so BI administrators were forced to drop Excel files. The data warehouse team converted the Excel files to pipe delimited text files using a conversion tool it developed for this purpose, but the process was slow — up to two or three hours per file in some cases. Now, Johnson Financial Group uses 360Cast to convert data extracts to CSV with a pipe delimiter. The result is a significant decrease in loading/processing time, and a corresponding boost to efficiency.

Conclusion

At Johnson Financial Group, 360Suite had an immediate and positive impact that extended across the organization. By adopting a suite of solutions that integrate seamlessly with SAP Business Objects, Johnson Financial Group BI administrators simplified and automated tasks, accessed metadata, and saved data extracts to different file types. Best of all, they obtained the ability to answer 95% of questions posed by SAP BusinessObjects users — with ease and confidence.

As a new customer, Johnson Financial Group is still discovering the many ways that 360Suite makes it easier, faster, cheaper, and safer to harness the power and maximize the value of SAP BusinessObjects. The entire 360Suite team looks forward to supporting Johnson Financial Group as it expands four initial use cases into a lengthy series of successes.

Contact us for a free trial or more information about the 360Suite commitment to customer success and its commitment to ensuring financial organizations can trust any decision made on data

Related posts

archiving-clean-up-sap-businessobjects-cover
October 29, 2020

Automate your SAP BusinessObjects archiving

READ MORE
spire-healthcare
September 23, 2020

SAP BusinessObjects continuous testing at Spire Healthcare

READ MORE
Howdens Joinery Group SAP BusinessObjects Projects
September 1, 2020

One Step At A Time: How Howdens Joinery Group Is Implementing 360Suite For Their SAP BusinessObjects Architecture Projects

READ MORE
360Bind360Cast360View360EyesBusiness Objects MetadataSharepoint Online
Ailsa Cartledge / About Author
Ailsa is the Marketing and Communications Specialist at Wiiisdom. Ailsa regularly creates content for the SAP BusinessObjects and Tableau community, and strengthens Wiiisdom's external communication.
More posts by Ailsa Cartledge

Related Posts

user adoption
Eliminate Risk thanks to Business Objects Automated Regression Testing

We were recently visiting a customer on the West coast and heard an amazing story. A utility company in California…

3
16 Jan 2017
best-practices-webintelligence-reports
Top 10 Best Practices for Web Intelligence Reports
9
16 Aug 2018
Webi reports
Repointing converted Webi reports to Freehand SQL connections

How to re-point Webi reports converted from Deski to a Freehand SQL connection In our post Taking full advantage of…

2
11 Jul 2017
vanderbilt-business-objects-sucess-upgrade
Vanderbilt University Medical Center Business Objects Upgrade and Epic Install
0 1
08 Aug 2018
Metadata and BI on BI in Business Objects
0 5
12 Feb 2018
implement-business-objects-data-catalog
The Importance of Implementing a Business Objects Data Catalog
0 0
05 May 2020
business-intelligence-self-service
Help Yourself: Extending the Reach of Self-Service Business Intelligence
0 0
04 Oct 2019
lockheed-martin-use-case
SAP HANA 1.0 to 2.0 Upgrade: How Lockheed Martin Aeronautics Piloted Their SAP BusinessObjects Data Source Change
0 0
03 Aug 2020
businessobjects-tags
How To Implement and Use Tags in Business Objects
0 0
23 Dec 2019
compare business objects universes
Taking full advantage of 360Suite #2 – Compare Universes

Have you ever wanted to know what the differences were between a Business Objects Universe in 2 different environments? I…

3
06 Mar 2017
lockheed-martin-use-case
Reducing Costs, Increasing Automation, and Improving Visibility for Self-Service Reporting at Lockheed Martin
0 0
12 Mar 2019
business objects solutions
Thinking Out of the Box

If you are following GB&SMITH you may have read my previous post a ‘decade of success’, then, you already know…

4
06 Sep 2017
reduce-sap-business-objects-costs
Reduce Your SAP BusinessObjects Costs
0 2
12 Jul 2018
bi-on-bi-360eyes
How City of Chicago uses BI on BI to improve metadata management, increase security, and save money
0 5
08 Feb 2018
rolling-the-dice-regression-testing
Rolling the Dice: SAP BusinessObjects Regression Testing
0 0
25 Apr 2019

Leave a comment Cancel reply

Information

  • Careers
  • Press
  • Terms & Privacy Policy
  • Legal
  • Supplier Code of Ethics

Support

  • Helpdesk
  • Downloads
  • Documentation
  • Knowledge Base
  • Release Notes

Latest news

  • How SAP Ariba Improved Its SAP Data Services Documentation Capabilities
    March 16, 2023
  • What is BI Testing?
    March 8, 2023

Connect With Us

  • Making trusted decisions together
  • Français
2023 © Copyrights Wiiisdom.
All Rights Reserved.

Request your trial for Wiiisdom Ops

Wiiisdom Ops supports Tableau Server and Tableau Online (now Tableau Cloud).
For custom installations, 3rd party authentication and single sign on, an initial setup may be required.
Please refer to our documentation and do not hesitate contacting us at: contact@wiiisdom.com.