BI Data Analytics

To keep up with upcoming Cognos fixes below links are useful: To check overall schedule: https://www-01.ibm.com/software/analytics/support/fixes/pbi_schedule.html Fix Pack lists ( below is latest Cognos BI 10.2.2 FP3): http://www-01.ibm.com/support/docview.wss?uid=swg27042898 Based on current versions, we need to evaluate fix list, open APAR, software version compatibility Environment and plan it. 

Is there any change in Query Engine from current version to "To Be" version?  Any new components/services added and what fine tuning would be required for them or can we disable them? What's license cost for separating out roles as needed? How data lineage can be discovered in new solution? Is all Fix Packs/Interim fix included in the "To Be" version Is OS, DB, DB drivers, application server compatible with latest version? Are we focused on first more stability of existing report set or new features? Do we have data available for testing reports in Test environment? Which Tool to be used for Regression Testing and comparison Testing? How you will manage multiple environments and URL changes for any application integrations? Along with this, review fix list and known issues list to be aware and verify if any of the features are potential to be used at your end. Preparation is key and questions/demos required. FAQs should be created based on di...

In MotioCI, regression testing is organized using three kinds of nodes in the Cognos instance tree: • Projects • Test scripts • Test cases Main Objectives are Ø   To identify any change in SQL ( Data may look same but may cause issue in future if SQL behavior is changed) Ø   To identify any change in formatting Ø   To identify any change in data for predefined prompts selection ( Data should be available) via Output Stability assertion- can be used for same report or reports in different location within or other instance Ø   Any Environment set up issues Ø   Execution Time stability – to baseline performance issues Projects – You can create multiple projects to focus on specific application folders and packages. It’s good to name appropriately to  distinguish  them from other projects and all shown at same place ( projects are arranged in alphabetical order). You can use Project_<App Name>  to create project. ...