Solve, then Evolve
All Cognos TM1 implementations require a strategy to deliver an appropriate reporting solution. This is the plan that will ensure that each business user will have access to all the TM1 data that they need, in the most usable format and in a timely manner. This plan must be based upon environmental configurations, user experience levels as well as time and budget constraints. The plan should outline a strategy that will meet the business requirements during acceptance testing, initial deployment to production as well for a conceivable period of time into the future.
A proven, best practice strategy for reporting is to Solve, then Evolve.
With this approach, the applications “core statement” needs are first identified and “solved for”. These are not individual analyst support reports or ad hoc data queries but only those reports required to complete (close) and/or monitor a business process (P&L, Income Statement, Balance Sheet, etc.). These reports may also include critical KPI’s or KRI’s. These reports are usually fixed in format and require a standardized styling format. They may be parameter-driven, for example “Income Statement” by period, or by country. These reports lend themselves best to being deployed using TM1 Websheets.
Once the standard “book of business” statement reports have been delivered, ancillary statistical reporting needs can then be considered. These reporting needs are usually much more individualized and narrowly focused. These would include very specific views of data based upon specific business questions. They can include “check” and “reconciliation” views of data. These reports are almost always solvable using TM1 compiled cube views that are accessible using TM1 Web and the TM1 CubeViewer. The TM1 CubeViewer will also allow users to perform various filtering and drilling operations upon the data that each cube view displays.
Finally, as the application matures and the level of user experience increases, it may be beneficial to evolve the reporting solution by considering the deployment of TM1 Perspectives to specific members of the business user community. These users will usually be the “power users” of the group with responsibility for performing more in depth, advanced or complicated analysis and reporting. Because of the nature of TM1 Perspectives, it is recommended that care be taken before offering Perspectives as a user option. Performance and concurrency are the 2 main areas that may have a detrimental effect on both the Perspectives user as well as the overall TM1 application.
Bulk Absorption and Configuration
From a pure architectural perspective, what is sometimes referred to as “bulk uploading” sometimes is (mistakenly) considered to be part of reporting or included in the data consumption component of the application. Loading and/or updating data is part of the applications absorption or configurations components and should be handled with a best practice approach of leveraging TM1 TurboIntegrator scripts and/or active Websheets (designed based upon user and environmental requirements and constraints).
It is important to keep the implementation of the reporting solution (the consumption layer) separate and distinct from the key value add (the processing) of the TM1 application being deployed. From an architectural perspective, the manner of consuming the applications data may (and most likely) will evolve:
- As user needs and level of expertise change, the method for consuming data my need to change.
- Other reporting tools and/or technologies may be considered in the future (for example Cognos Insight or Cognos BI) which will change the method for data consumption.
- Organizational changes may require additional or different analysis and reporting and therefore may change the method of data consumption.
Keeping the data consumption layer distinct form the applications value add will allow the method for data consumption to be more fluid, be tuned for performance and change (if needed) with little or no modifications to the core application.