Company: Apotex

Apotex

  • The largest pharmaceutical in Canada
  • 6,500+ employees
  • Revenues greater than $1 billion

The Challenge: Getting a clear picture of business fundamentals

Several years ago, the finance group at Apotex embarked on an initiative to find and deploy an easy-to-use yet powerful business analytics solution to increase their ability to answer the most important operational questions, namely:

  • What products are being sold?
  • Who is buying those products? and
  • What are the profit margins by product and customer?

As with most SAP customers, the finance group used the standard tools available to them to perform the desired analytics. Reports could be generated that identified sales by product or by customer. Profitability reports could also be generated. However these reports were static and ineffective for trend analysis and pinpointing operational issues, the team resorted to Microsoft Excel. Even with significant limitations, the team was able to obtain greater insight into the SAP data, and more importantly, understand what they needed, rather than what they were getting.

The Solution: Panorama’s BI Solution on SAP BW

At this stage, the Apotex finance team met with a local Panorama partner – The Catalytics Group Inc. – who were able to develop a strong proof of concept using the Panorama’s BI Solution Suite operating on the Microsoft platform.  Apotex continued their work with Catalytics to execute on the desired solution using Panorama’s BI Solution.

At the same time,  the Apotex Information Technology group began a strategic deployment of SAP BW.  IT approached finance to join the initiative, and a decision was reached to use  the Panorama’s BI Solution deployment to design a corporate-wide solution using a single data source (namely the BW cubes and data stores). Once again, the finance group at Apotex turned to Catalytics to support the implementation of Panorama’s BI Solution as the analytics and reporting solution for the SAP BW data source.

The Rationale

A critical decision in moving forward with Panorama was the ability to adhere to the strategic decision relating to a single data source. For many years the organization had been relying on Excel and Access to manage the business analytics function. Each department would extract data from SAP R/3 and place it in one of these tools. In some cases, the same data was being extracted by multiple people in the same team, or by different user groups. The manner in which the raw data was then manipulated and presented was dependent upon what story the group was trying to tell, rather than what the data itself was inherently “saying”.

When evaluating other alternatives, Apotex realized that most of the solutions do not natively integrate with SAP BW, but rather they add an additional layer for metadata and data extractions. Apotex knew what they wanted – standardization on SAP BW while getting the power of self-service analytics and reporting.

The Results

Since initially going live, the finance team has expanded their use of Panorama’s BI Solutionby incorporating it into the annual planning process. Budgets are prepared, reviewed, and loaded into SAP R/3. Prior to final submission and review at the executive level, departments are able to review their planned revenue and expenditures against historical results, and they are now also able to “slice” them against each product. Future initiatives will allow for review of certain data by customer, thereby allowing the Apotex to not only forecast and plan future product sales, but also anticipate which customers will buy which products. This will allow sales management to focus their attention on areas that will help them meet or exceed their sales plan.

A number of interesting things happened during the implementation of the Panorama’s BI Solution solution:

  • Work performed during the initial project using Microsoft technologies such as SQL Server and Analysis Services cubes was seamlessly migrated to the new dashboard environment. As data became available through the SAP BW platform, data views were replaced in the dashboard pages without users being made aware of the change. In some cases, pages consisted of data from both SAP BW and SQL Server Analysis Services, which was easily accomplished due to Panorama’s BI Solution native integration with both platforms.
  • During the initial design phase, user groups had determined that monthly data aggregations would be sufficient in terms of granularity, and IT then built the solution based on meeting that requirement. During deployment, however, it became apparent that certain constituents needed to see sales information by products on a daily basis. IT resources (as in most organizations) were strapped and could not undertake this modification in the time desired by the user community. Turning once again to Catalytics as their preferred Panorama consultancy, a short term solution was defined, created and deployed in under three weeks. Procedures were written to perform the required calculation to determine the daily data delta and store those values to a cube from which the data is then presented in dashboard pages.

Solution Highlights

  • To date, the solution has proved versatile and robust, allowing for all user requirements to be met easily and in a controllable environment.
  • Analysts can now focus on review and interpretation of analytics rather than in their preparation.
  • Data can now be viewed from different perspectives, leading to more informed decision making.
  • Well designed and defined Panorama’s BI Solution dashboard pages provide a common, consistent view on data through the organization.
  • Rich BI functionality satisfies the organizations need for deep and meaningful information.

Submit to our blog