BI Data Analytics

Below are some of the changes in LCM for IBM Cognos Analytics and should be used to identify reports to assess efforts ( Planning Phase) may be needed for upgrade process from IBM Cognos 10.2.2:- There is no reporting or exporting of results to capture differences and failures, progress. Prompts fill out using  'Capture Prompt Values' not working in IBM Cognos Analytics version. Reports having images as references to templates and using Layout component reference need to be validated for any issue. Validate impact where Java Scripts are used  such as multi select auto cascading implementation

Build test cases to detect below common Reporting issues Any blank column on the report for all selection Rows repeating for same dimension and attributes Double addition for amounts for same dimension for different selections Report filtering data for all selections ( default, individual, multi select) Download options working for all selections Query properties and naming conventions followed  Output getting distorted in pdf/excel or parameters, standard logos are not displayed

1. Create text Box Prompt for parameter and set default value to 1 ( we are going to use it for default selected).  Name it PromptOpt. 2. Make it's property visible to No. 3. Add HTML item before it with below script and check box . < script text= "javascript"> function handleClick(cb) { var fW = (typeof getFormWarpRequest == "function" ? getFormWarpRequest() : document.forms["formWarpRequest"]); if ( !fW || fW == undefined) { fW = ( formWarpRequest_THIS_ ? formWarpRequest_THIS_ : formWarpRequest_NS_ ); } var f = getFormWarpRequest(); var list1 = f._textEditBoxPromptOpt; list1.value = 1; canSubmitPrompt(); SetPromptControl('reprompt') ; } < / script> < TABLE class=tb style="WIDTH: 150px; BORDER-COLLAPSE: collapse" cellPadding=0> < TBODY> < TR class=tableRow> < TD class=tableCell onclick="handleClick(this)"> < DIV class=block>< input type="

Below new features I found interesting from IBM Cognos Analytics 11.0.6:- Users of Report content can view Data Lineage without going into edit mode. This features enable consumer of report to see source of data and also helpful for report author to see the source while testing the report. Now you can create Report views for Active reports In interactive mode reports, users have ability to freeze or pin column headers so that they stay in view when scrolling. It is available for List object only. It can be enabled by setting the 'scrollable area height' property.  Formatting applied on the List are also maintained. When creating a report, to add a scroll bar to a list prevent the list to accompany multiple pages use 'scrollable area height' List property to enable it. Now we are able to modify queries built in report studio using data modules. In the new version of Cognos Analytics (Cognos 11), sorting is an out of the box feature. Authoring is no longer requ

In Cognos 10.x and 8.x , this was the simple to handle on Cognos Connection or via Repot Studio interface.  In Cognos 11.0.6, You  need to load classic view (Cognos Connection) to go back to this interface to change the package. In Cognos Cloud environment, we have single environment for Development and UAT. In such cases, when we move content from Dev folder to UAT area, we need to switch to classic mode to change the package.

There is nice feature of Data Player added in IBM Cognod Analytics. We can use data player feature in a Dashboard to show trends transition over time filter. This will auto play the filter to next selection and refresh charts on dashboard. This works fine with fast data retrieval queries. However, if the query for chart is slow compared to filter query, it can result in chart data not changing while data player changes to the next selection. There is need to control the time the data player transitions to have the consistency between Data Player filter and output.

Add html item after the radio button. Add below:- < STYLE > Div.clsCheckBoxList{ border-style:none; } <  / STYLE >

Many times it's necessary to create multiple connections within Data Sources; for example, DB migration, multiple changes to keep in different DBs but same schema for parallel project. However, in IBM Cloud we have one single environment for UAT and Development so as soon as we enable it, it's not transparent to users and it adds additional step to select Data source and test. To resolve this, we can create separate group for each UAT users and change permission to specific Data source connection to deny for Read/Execute/Traverse. With this, they won't be prompted for Data source connections while running a report.

Environment: Cognos 10.2.2 Database: Oracle Issue: When report is run in html or excel 2007 format, dates appear to be fine whereas when run in Excel 2007 data or csv format, date appears to be in time stamp format. Cause & Resolution: Oracle dates are interpreted as Time Stamp in Cognos. You need to cast them at model or report level to date. On layout, date formatting was applied hence Date format appeared fine on Excel 2007 and HTML ouptuts.