BI Data Analytics

Typically on-premise environment, we keep a shared drive of deployment folder to share across environment so that  we don't need to copy them over each dispatchers and it's readily available for import in target environment. In Current IBM Cognos Cloud on 11.0.9, now there is script to sync up between environments and  it copies the deployment archive. We need to create new import for each new import and wait for 10-15 minutes before it will appear in new environment.  This was not the case in C10.2.2 Cloud Environment.

Issue   While navigating Manage > Account in IE renders blank screen. It works fine in Chrome.       Cause: There has been an NPS (net promoter score) application added to the Cloud Solution. It disables a Pop-up survey where you can rate the Cloud Solution. This NPS application can cause problems with IE. It was turned it off to resolve the issue.   There is a defect logged against issues with IE.

Cognos Analytics on Cloud 11.0.6 RFEs raised for features not available on cloud and/or defects identified: http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=108702 https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=104089 https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=108313 https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=104089 http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=108701 http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=108899

Below are the properties to set to keep column size and width with text wrapping: Column Merge issue  http://www-01.ibm.com/support/docview.wss?uid=swg21674298 Set the advanced server property RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL to TRUE for both BatchReportService and ReportService services.        Row Merge issue http://www-01.ibm.com/support/docview.wss?uid=swg21440556 RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL also to be set to TRUE  for both BatchReportService and ReportService services.   Once done, you can set any column width to be fixed and see same result in Excel as well as HTML. Please note that above properties will not be honored if you have unchecked Grouping repeating cells Report property in Report Properties menu. 

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

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.

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.

Issue Symptoms: After installing Life Cycle Manager, when clicking on start window, we get error that path not specified. Also, clicking on URI and trying to create project gives HTTP Not found error  Solution Create  "projects" folder under  C:\apps\ibm\cognos\LifecycleManager\data Make sure have full access on  C:\apps\ibm\cognos\LifecycleManager Restart  IBM Cognos Lifecycle Manager Startup and you should see below for successful start Using CATALINA_BASE:   "..\tomcat" Using CATALINA_HOME:   "..\tomcat" Using CATALINA_TMPDIR: "..\temp" Using JRE_HOME:        "..\bin\jre\7.0" Using CLASSPATH:       "..\tomcat\bin\bootstrap.jar" How to start and stop LCM Windows -> Start menu - navigate to the Lifecycle Manager entry and select " IBM Cognos Lifecycle Manager Startup" option.   Default: http://localhost:4797/LifecycleManager Lifecycle Manager s...

Below are issues/observations noted for reports upgrade: Repeater behavior changes In Cognos 10.2.1, it was working similar to singleton and was able to show single value ( if there is only one value for all rows). This was specifically used for Language based drill through link. After upgrade to Cognos 10.2.2 FP7, the report kept running forever in interactive mode. Upon running in batch mode, it was revealed that it repeated values for each row. To solve this, either convert data item to report expression item or use singleton (to get first value). Extract function data type In 10.2.1, it is being treated as string whereas in 10.2.2 FP7 it's treated as number. Due to this additional function used such as TO_Number resulted in warning in higher version. The argument at position 1 of the function 'TO_NUMBER' is invalid in filter/slicer expression ' TO_NUMBER(extract (YEAR,current_date))' of query 'Prompts', expected one of the following t...

Problem: After upgrade to FP7, noticed error generated from a crosstab having crosstab space nested within cross tab nodes:- Found an internal error: '!mapSuccess - reportName=test_FP7 - edgeName=11 - edgeOrdinal=1 - tuple=([TBdimension_4].[TBhierarchy_4].[all].[test data].[1].[1].[0], [TBdimension_5].[TBhierarchy_5].[all].[data value for test data within data).'. Solution: It seems that FP7 version was looking for hierarchy information for crosstab spaces as there were no measures assigned to that row. Just added one of values as nested crosstab node above the crosstab with default measure and hide it. This worked to stop generating error and report started working again without loosing display format needed.

Issue: While moving to Cognos cloud, report fails to pass Date parameter. XQE-DAT-0001 Data source adapter error: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string Version: Cognos 10.2.2 FP3/FP7 Database: Oracle 11g Cause: Cognos is treating Oracle parameters as Timestamp and cast/to_date function at both end doesn't work. Solution: Create data item: (extract(year, ?As Of?) * 100 + extract(month, ?As Of?) ) * 100 + extract(day, ?As Of?) 2. Pass data item value instead of Parameter value 3. In target report, data item should have below ( to use for filtering) and/or displaying: case when (length (?Date?)=8) Then to_date(substring(?Date?, 1,4)||'-'||substring(?Date?, 5,2)||'-'||substring(?Date?, 7,2),'YYYY-MM-DD') Else to_date(?Date?,'YYYY-MM-DD') end

Issue:  For Value Prompts Radio Button/List Boxes shows side scroll bar. Cause: Report was using 8.x styles Solution: Change Report properties to use 10.x styles

Problem: While running report, logo images are visible in html and when try to download in pdf/excel output, logo image is not available. Solution: Logos are copied to only gateway web contents. Below steps were performed on Cognos Cloud Images were copied to dispatchers. URL path used is relative in original report working in windows but not on Linux. Change is from “\” to “/”. “..\pathtoimage\image.gif” For Linux, it needs to be changed to : “../pathtoimage/image.gif”

We can pass dates as number for drill through report if there is  range filter is involved from in built date prompt: Steps: 1.        In Detail report, Create data item where filter is applied on date range [IntegerDate] extract(year,[Date1]) *10000 + extract(month,[Date1])*100+extract(day,[Date1]) 2.        In Detail report, Apply filter - [IntegerDate] between ?date1? and ?date2? 3.        In Summary report list query add below data items: Start Date: extract(year,[date1]) *10000 + extract(month,[date1])*100+extract(day,[date1]) End Date: extract(year,[date2]) *10000 + extract(month,[date2])*100+extract(day,[date2]) 4.        Update Drill through to pass new data items for ?date1? and ?date2? For single date passing via value prompt, it can be passed as To_Char/cast to compare and pass.