BI Data Analytics

Since now IBM Cloud OPS team supports Cognos Environment and there is need to open ticket and have delays in response times to detect issues, we can set up Job to run some quick reports to run every 5 minutes. While scheduling, need to keep in mind Reports total tun time covers 3-4 minutes run time so that Job will keep running all the time. Exclude times in schedule where maintenance/backup going on.  Reports to be run in sequence so that it doesn't impact actual reports run by users. You can set Job run history to more time to see it on Page itself  You can set up to send an email via even after job completion to include run time. When you stop getting emails, it means there was an outage/issue in the environment. You can create Audit report to check mean, median and mode for Job run time performance to compare run times against.   This method can test dashdb and report run times consistency; however, actual navigational/interactive report run times can't b...

Below IBM document explains behavior of copy/move or overwriting impact of objects:- https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.wig_cr.doc/c_gtstd_copy_move_items.html If you copy and overwrite an existing report, the copied report ID and links replace those of the existing report. In this case, you might need to update links, such as links to job schedules. If you move and overwrite an existing report, the existing report ID and links are maintained. In this case, references to the moved entry are broken. However, this doesn't work in all cases and we see drill through links broken in some cases. Best approach in such case is to use cognos deploy method where you update reports in separate folder in same environment and import it to destination location. You can create single export and import tasks to use for all such updates.

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

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.

Issue: Native SQL based report against Oracle DB giving error: XQE-DAT-0001     Data source adapter error: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis Symptoms: Reports have multiple native sqls against Oracle DB. It is using Master details, Page set as well Cause: Cognos 10.2.2 FP7 upgrade from FP3 Analysis and Solution: Run query in Tabular data and see error coming from specific queries On analysis, it was found that there is comment statement in the end of query and it's not able to handle in FP7. It should have omitted it for evaluation. After removing the commented line, error disappeared. Comments: If we use standard comments /* */  or we move last commented line to in between query, it is able to parse sql correctly and send to Oracle as well. This is possible issue in supporting Oracle comments for this scenario in FP7.