MotioCI Reports

Post: MotioCI Purpose-Built Reports

MotioCI Reporting

Reports Designed with a Purpose – To Help Answer the Specific Questions Users Have

Background

All of the MotioCI reports were recently redesigned with one goal in mind — each report should be able to answer a specific question or questions that a user in a specific business role might have. We tried to put ourselves in the shoes of users and put on our thinking cap. We asked ourselves, “What are the tasks of the key groups of users of Cognos and MotioCI?” “How do they use MotioCI?” “What questions might they ask related to their function within their organization?” And, lastly, “How can we help make their job easier by providing answers to those questions?”

As of MotioCI 3.2.11, there are now over 70 Cognos reports that come bundled with the application. They are published in 7 fairly self-descriptive folders: Admin, Documentation, Inventory and Reduction, Motio Labs, Promotion, Testing and Version Control.

Business roles

We think there are key roles within each organization that use MotioCI. They may have different job titles between organizations, but they tend to fall into these broad groups.

  • Project Managers
  • Executives
  • Administrators
  • QA Testing team
  • Business Analysts
  • Report Developers

Role-specific reports

Project Managers

Project Managers are often called on to oversee discrete efforts related to the development of Cognos Analytics reports, or to an upgrade of the application. To manage a project, users in this role need to see an overview or summary of recent activity related to the project. Most of the reports for this role are found under the Testing folder. Some of the reports are specific to managing Cognos Analytics upgrade projects. Other reports provide summary information on the test results of a MotioCI project, or compare results across projects or instances.

  • Test Results Instance Comparison by Project Summary – Crosstab summary of Test Result Status by Project and Instance.
  • Upgrade Project Burn-down Report – Cognos Upgrade Project Tracker. Plots Test Result Failures over the course of the project with calculated trendline projection.
  • Upgrade Project Test Results Comparison – Comparison of Test Results of MotioCI Projects within the Upgrade Project. Provides additional detail to support the Upgrade Project Burn-down Report.

Executives and Managers

The CIO, Business Directors, and Managers are interested in the big picture. Often they need to build a business case for the on-going use and maintenance of Cognos Analytics. Pieces to the puzzle of building a strong business case and defending the value proposition may include the number of Cognos items under version control, the number of users using Cognos Analytics, and trends in usage. Reports with this information (and more) are found under the Admin folder, as well as, the Inventory and Reduction folder and Version Control folder.

  • Inventory Summary report provides a useful dashboard summary of objects in a Cognos instance.
  • MotioCI Timeline Trends – Seven different charts; Users and Number of Events by Day of Week, Month of Year and Year; Action Type and Number of Events by Day of Week, Month and Year; Action Type and Number of Events by Year, Month
  • Versioned Items by Type – Cognos Versioned Items with Display Name, Path, Type, Version, and Size.

System Administrators

Cognos System Administrators manage the reporting environment, which includes security and access to the Cognos Analytics application. It also includes managing capacity and, sometimes, providing support to other users. Reports under the Admin folder provide insight into system processes.

  • Active Worker Processes – Current active Worker Processes and, if Testing activity, Project and Test Case. Also shows PID to tie to Server Process Identifier.
  • Dispatcher Properties Comparison – Side-by-side comparison of properties of system dispatchers. Another example of a report which shows a valuable snapshot of information which is impossible to get anywhere else..
  • Locked Items – Currently locked reports and files. If a user does not check in a report when they are done editing, a lock will remain on the report and other users will not be able to edit it. This report allows the administrator to view which reports are locked in case additional action is required.

Administrators

Administrators may often be responsible for promoting reports between environments. As such, reports in the Promotion folder provide information on Promotion Results and comparing the content between Cognos instances. In most organizations, it is critical that reports are developed in the Development environment, tested in the QA environment and presented to the public in the Production environment.

  • Reports Instance Comparison – Comparison of report name, location and version between 2 environments.
  • Reports Promoted with no Successful Test Results – will help identify reports which may have somehow bypassed the mandated process of testing all reports before they are promoted..
  • Reports Promoted with no Tickets -.Reports which have been promoted, but do not have an associated external ticket reference in the comments on the source object. This report helps validate that internal processes have been followed.

Administrators may also be involved in the technical aspects of an upgrade and the prework in preparation for the upgrade. Reports in the Inventory folder document pending and completed reductions done in preparation for an upgrade.

  • Reduction Group – List of Inventory Reduction Groups with drill-through to additional detail.
  • Reduction – List of Inventory reductions with drill-through to cascaded detail of files reduced.
  • Reduction Details – Lists the lowest level of Reduction Details.

Testing Team

The QA Testing team is responsible for evaluating reports after they have been created and before they are put into production. All of the reports in the Testing folder may be useful. This team may need more detail on the failures of Test Cases than, say, a Manager, or Project Manager.

  • Test Results Failure Detail – Lists details on four tabs of CI testing failures: 1) Validation Failures, 2) Execution Failures, 3) Assertion Failures and 4) Assertion Step Failures.
  • Assertion Results – Status of Assertion Results by Assertion for Versioned Items within a specified time range.
  • Assertion Definitions – .MotioCI Assertions and, optionally, Assertion Types, Assertion Components and full help. Can be used to see what Assertions are in the system, where custom assertions are and information on which Assertions can be used for testing.

Business Analysts

Business Analysts may play a role in defining and documenting the requirements for a report. Reports in the Documentation folder provide a starting point for documentation of reports and other Cognos objects with detailed, technical documentation.

  • Report Documentation – Documents all report queries and data items in a report.
  • FM Complete Reference – Documents all domains of a model published as a package. If rendered in PDF, Table of Contents allows quick jump to domain of interest.
  • Jobs Documentation – Jobs with member Reports. Show which reports are run with each job.

Report Developers

Report Developers are on the frontline creating new reports. Depending on the organization, these may be dedicated authors, or, may be business users. They may find some of the same reports as the QA Testing team helpful in troubleshooting reports and report errors before they hand it off to be tested. Reports in the Documentation folder may also be helpful in providing information on report standards and conventions, data item definitions and calculations. Reports in the Version Control folder provide summary and detailed information on recently edited reports.

  • Data Item Lookup, will help find where else in the report catalog a particular field is used so that consistency is maintained.
  • Test Results – Test Case Results Result Message Details
  • Reports Edited Recently – Key data on reports which have been edited recently to help you find a specific report.

How to get started

How can you find the reports to help you do your job?

  1. Begin at the beginning. Install MotioCI. Publish the MotioCI reports. The details are in the User Guide, but you’ll find a Publish button on the Cognos Instance Settings tab for a Cognos instance in MotioCI. You’ll also need to set up a data source connection to point to the MotioCI database.
  2. Start by exploring the report listed above under your project role.
  3. Dive deeper by running the Report Descriptions report which lists all reports and their descriptions.

Report Descriptions report

The Report Descriptions report in the MotioCI Reports > Documentation folder lists all included MotioCI reports along with a short summary of each. With the Report Descriptions report, you can view a list of all the prebuilt Cognos reports that are included with MotioCI. The reports are listed by name and folder. The list includes a short summary of each report, alongside information about the owner, last update, package, locales, and prompts. If new reports are added in a future version of MotioCI, they will be included in Report Descriptions, with the following caveat: The Report Descriptions report requires the Report Descriptions assertion to have been run on the reports it is documenting. To add test cases with the Report Descriptions assertion to the reports, follow the steps in the User Guide under Configuring MotioCI to automatically generate test cases.

Because this report relies on an assertion to gather the data, the results are not limited to MotioCI reports. You can use the report to take inventory of any or all of the reports you have developed in Cognos. Just make sure that the Report Descriptions assertion has been run on the reports that you would like to include and select the appropriate Cognos Instance and Project from the report prompts.

Note: to take advantage of this report, you will need a MotioCI Testing license to run the required assertion and test case.

Prompts

Cognos Instance and Project are required prompts. The Instance radio button prompt is limited to a single value. You must select one or more values from the Project checkbox prompt.

A portion of the first page of the Report Descriptions Report.

Summary

MotioCI is an indispensable tool which extends and simplifies the capabilities of Cognos Analytics. Because of the depth and breadth of data captured in MotioCI on your Cognos environments, it’s sometimes hard to find the signal through the noise, The MotioCI reports have been designed to do exactly that. These reports may very well make MotioCI more valuable and help you do your job better.

 

Scroll to Top
As the BI space evolves, organizations must take into account the bottom line of amassing analytics assets.
The more assets you have, the greater the cost to your business. There are the hard costs of keeping redundant assets, i.e., cloud or server capacity. Accumulating multiple versions of the same visualization not only takes up space, but BI vendors are moving to capacity pricing. Companies now pay more if you have more dashboards, apps, and reports. Earlier, we spoke about dependencies. Keeping redundant assets increases the number of dependencies and therefore the complexity. This comes with a price tag.
The implications of asset failures differ, and the business’s repercussions can be minimal or drastic.
Different industries have distinct regulatory requirements to meet. The impact may be minimal if a report for an end-of-year close has a mislabeled column that the sales or marketing department uses, On the other hand, if a healthcare or financial report does not meet the needs of a HIPPA or SOX compliance report, the company and its C-level suite may face severe penalties and reputational damage. Another example is a report that is shared externally. During an update of the report specs, the low-level security was incorrectly applied, which caused people to have access to personal information.
The complexity of assets influences their likelihood of encountering issues.
The last thing a business wants is for a report or app to fail at a crucial moment. If you know the report is complex and has a lot of dependencies, then the probability of failure caused by IT changes is high. That means a change request should be taken into account. Dependency graphs become important. If it is a straightforward sales report that tells notes by salesperson by account, any changes made do not have the same impact on the report, even if it fails. BI operations should treat these reports differently during change.
Not all reports and dashboards fail the same; some reports may lag, definitions might change, or data accuracy and relevance could wane. Understanding these variations aids in better risk anticipation.

Marketing uses several reports for its campaigns – standard analytic assets often delivered through marketing tools. Finance has very complex reports converted from Excel to BI tools while incorporating different consolidation rules. The marketing reports have a different failure mode than the financial reports. They, therefore, need to be managed differently.

It’s time for the company’s monthly business review. The marketing department proceeds to report on leads acquired per salesperson. Unfortunately, half the team has left the organization, and the data fails to load accurately. While this is an inconvenience for the marketing group, it isn’t detrimental to the business. However, a failure in financial reporting for a human resource consulting firm with 1000s contractors that contains critical and complex calculations about sickness, fees, hours, etc, has major implications and needs to be managed differently.

Acknowledging that assets transition through distinct phases allows for effective management decisions at each stage. As new visualizations are released, the information leads to broad use and adoption.
Think back to the start of the pandemic. COVID dashboards were quickly put together and released to the business, showing pertinent information: how the virus spreads, demographics affected the business and risks, etc. At the time, it was relevant and served its purpose. As we moved past the pandemic, COVID-specific information became obsolete, and reporting is integrated into regular HR reporting.
Reports and dashboards are crafted to deliver valuable insights for stakeholders. Over time, though, the worth of assets changes.
When a company opens its first store in a certain area, there are many elements it needs to understand – other stores in the area, traffic patterns, pricing of products, what products to sell, etc. Once the store is operational for some time, specifics are not as important, and it can adopt the standard reporting. The tailor-made analytic assets become irrelevant and no longer add value to the store manager.