Empowering Cognos Dashboards with Analytics FlexiPrompts for Real-time Dynamic Search

Introduction

One common challenge we faced in the business was Reporting and Analysis with Large
Datasets. The users have dynamic requirements by the management and business owners
to review and get meaningful insights on the operational and analytical data from the most
granular level to the most summarized level.

Business Analyst often highly dependent on the IT team or Data Team, and also face a lot of
operation delays for summarizing, joining, and filtering the data as quickly as the CEOs or CFOs demand.

Solution built on IBM Cognos Analytics

We understood the scenario or consuming data by business users and the need for analytics
on the go, and designed a flexible approach to handle large datasets using simple dynamic
flexible prompts and filter extension to the IBM Cognos Analytics platform. The simple
JavaScript code helps to work with larger datasets and provides endless flexibility, easiness
and agility for business users to work with data on the Cognos webpage itself, avoiding
multiple downloads and repetitive executions of extracting outputs.

Benefits of Analytics-FlexiPrompts

• Simple to adapt to existing Cognos environment as well as business users to define
  dynamic prompt-based filtering on very large datasets.
• Join or build a nested condition.
• Review the output in the list/table view. 
• Working with data on the web without downloads and reworking with Excel.
• Build and Modify the Dashboards
• Define and reuse the prompts based on user access
• Slice large dataset into small chunks to enhance the analysis performance