Case Study: City of Chicago improves metadata management, security, and cost savings with Wiiisdom

How City Of Chicago Uses Bi On Bi To Improve Metadata Management, Increase Security, And Save Money

Wiiisdom helped the City of Chicago address long-standing BI governance challenges in its SAP BusinessObjects environment, which had grown over nearly 18 years and included 1,500 users, 90 production universes, and nearly 96,000 reports. The city needed better metadata management, stronger security, clearer usage visibility, and solid data to support a BI 4.x migration and future investment decisions.

Using Wiiisdom’s 360Suite solutions for SAP BusinessObjects, the city gained BI-on-BI reporting and administration capabilities through SDK-based access to CMS, audit, and file store metadata. This provided deeper insight into report, user, session, scheduling, and impact analysis, while helping reduce risk from direct production database queries. The result was better understanding of the BI landscape, support for cleaning up unused content, improved performance and reliability, and stronger justification for migration and license or hardware decisions.

City of Chicago