BI Data Analytics

Below issues were identified for MotioCI 3.0 upgrade   Content Store corruption --Engage MotioCI Regression Test cases going in Pending State - recycle MotioCI process Not able to sign in URL - IE Cache clearance

  Problem: Even when using Auto generate test cases feature, it may take a while to generate test cases and it may fail for time out. Secondly, this would be frustrating if even after long time, no prompt parameters are imported.   Cause: It's possible its taking so long because there may be a large amount of prompts its going through.   Resolution: Deselect the "Attempt to Import Parameters from Reports, Views and Outputs" option Auto generate and do dry run to see which reports failed for prompts. Update those reports manually or cloning from other test cases to speed up process.      

MotioCI can be helpful to do impact analysis for any Backend DB changes. Steps: 1. Create queries for packages for each query subject. Please remember to put filters to limit data and have good performance. 2. Create test cases for each of them. 3. Run Test Scripts via MotioCI 4. Schedule them to run with comfortable frequency and failure notification. Once a test case fails, you can verify reason for failure (  table lock vs, DB changes) and get them corrected.

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. ...