BI Data Analytics

Requirement: To modify Bullet chart Sample Bullet color is not aligned with color standard. Remove labels from charts Remove Satisfactory and Good Category from charts as want to show only Actual and Target for Time dimension. Make it compact to avoid any large space utilization Before Change: Steps: visJSON Update Update Elements to remove Satisfactory and Good section Update color and fonts for Actual and Target sections in Elements Remove Categories from data section and rows values for removed categories Remove Categories from axis section Chart Area Update and Refresh Bundle Remove references from Chart Type Definition for categories Remove from String Resources Refresh Thumbnails Changed Bundle name to avoid overwriting of existing sample Upgrade Definition and visJSON Generate VizBundle Definition Import in Library Reopen Report Studio and use Convert Visualization or get from Tool Box. Tool Used: IBM Visualization Customizer

Below section in Rave Line chart defines symbol and it's size,                "symbolStyle":                {                   "size":8                }, It can be removed to get Line chart without any marker.

Environment: Cognos 10.2.2 High Level Steps done as follow:- 1. Open given Combination Chart as base in IBM Visualization Customizer Tool 2. Replace Bar Charts from data set sections, Elements sections with Line chart data 3. Change Colors for both data sources to show different colors 4. if needed, remove legend or position to appropriate place. After the change: Use: To show different measures of same dimensions in same chart for comparison.

Prerequisite: Download IBM Visualization Customizer from Analytics Zone corresponding to Cognos version Download Visualization Bundle either from Cognos Admin Console or from Analytics Zone (Free available) Bullet Chart Customization Example Chart Name: az.Bullet_10_2_2   Changes: Open Bundle in IBM Visualization Customizer to access vizJSON Line # 119/120 for measure value font size and make it bold At Line 388, change color for Target Bar chart Around line# 502 and 529, removed blocks for second bullet chart Save as different bundle name and validate Import to Cognos Admin console and validate via Rave Visualization for availability and user

MotioPI is Desktop admin tool for Cognos and can be used independently( MotioCI is separate tool). Below are typical use cases:- Ø   Download report outputs on local machines in bulk; Ø   Model recovery from Content Store Ø   Administration of Environment - o    Data source information o    Create Report/Objects inventory creation for each application o    Content store bulk cleanup of outputs/schedules o    Owner change for reports/schedules o    Dispatcher/Environment settings o    Report execution times o    Studio to view spec/models and make changes Use the following link to launch MotioPI: http://www.motio.com/products/piLaunch.do Before you launch MotioPI, please visit our getting started webpage at https://www.motio.com/products/pi/gettingStarted.do

High Level Set up steps details: 1. Need to register to Analytics Zone 2. Download tool from Downloads section 3. Get all samples for Cognos version from Analytical zone and keep at same place 4. Download Tool's documentation from link ( For Cognos 10.2.1.1) and follow direction:- http://www.ibm.com/support/docview.wss?uid=swg27039892

In Cognos 10.2.1, It is observed that when sorting is defined on series text data item (ascending) , it results in descending order. To achieve ascending sorting, in sorting for data item defined as descending and it worked! Not sure, why it is working just opposite but worth trying if you face same issue.

An issue with Application drill through sorting is observed in Cognos 10.2.1 Active Report. Summary Active Report Rave chart where I defined application drill through to different Active reports. When I see report on ipad for drill through is not in alphabetically sorting order. I checked if it is based on creation date or drill through name/label name or actual content store id; however, it is not sorting based on any of them. It is also not dependent on in between addition/deletion of drill through and there is no sorting options available on Rave charts.

Requirements: Prompt page and report are on same page for dynamic refresh User wants date to be selected for latest month available in Database   Solution steps: Calculated maximum month as latest month for report Sorted Data item in descending order and applied sorting on prompt ( auto submit = yes) Use Prompt API for RS to select latest month referring below link   http://www-01.ibm.com/support/docview.wss?uid=swg21639520     Issues Faced: Page was getting reset to default selection even we select different month. Solution: Add line of code in script using below reference: http://cogblogger.com/2014/10/javascript-running-code-only-once/ Issue Faced: Initial run of report is not filtering out data based on prompt parameter and showing aggregated value. Solution: Use of prompt macro to make default parameter as latest month and made filter "Required" instead of Optional. [Month Year] = #prompt('p_Month_Year', 'st