IBM Cognos Analytics 11.1.2 Fix List

Good news! IBM has updated the APARs with the resolution, and this finally allowed me to compile the fix list. It may not be fully comprehensive, and a few non-11.1.2 (I know there are some 11.1.2 fix pack fixes included) fixes may have snuck in. But here it is, the only place to get a (somewhat) curated list of fixes in the latest version of Cognos.

PI93413 UNSECTION IN UPGRADED REPORT FAILS WITH TYPEERROR
PH08761 DASHBOARD AGAINST PURE DATA FOR ANALYTICS SOURCE PERFORMS POORLYAFTER UPGRADE
PH04780 UPGRADED DASHBOARD MISSING CALCULATIONS IN DASHBOARD AND IN LISTOF ITEMS TO INSERT
PH05295 SEARCH RETURNING INCOMPLETE RESULTS AFTER CONTENT STORE UPGRADE
PH08760 SCROLLBAR IS MISSING UNDER DATA ITEMS AFTER UPGRADING FROM 11.0.12 TO 11.1.1
PH07757 AFTER OVER THE TOP UPGRADE FROM 11.0.12 TO 11.1.1, THE INSERTABLE OBJECTS BUTTON IS INVISIBLE
PH07313 AFTER UPGRADE TO 11.1 FROM 11.0.11, DASHBOARD CHART COLOUR SERIES ARE NO LONGER SORTED
PH09781 AFTER UPGRADING THE ACTIVE REPORT FROM 11.0.13 TO 11.1.1, USER IS NO LONGER TO EDIT OR MODIFY FOR REPORT …
PH01601 DRILL-THROUGH REPORTS UPGRADED FROM AN OLDER RELEASE OF COGNOS THAT USE DATAMODULES THROW XQE-GEN-0002.
PH01636 CROSSTAB RESULTS ARE NOT CORRECT AFTER UPGRADE FROM BI 10.2.1 TOCA 11.0.11
PH05955 CANNOT SEARCH REPORT BY A STRING IN THE FILTERS ON THE REPORT AFTER UPGRADE TO CA 11.1
PH06662 FRAMEWORK MANAGER CRASHES WHEN PUBLISHING A PACKAGE UPGRADED FROM 11.0.6 TO 11.1.1
PH02343 PDF TO PDF DRILL THROUGH RUN IN UPGRADED PORTAL PAGE SHOWS SOURCE REPORT TAB IN IE AS WAITING FOR SERVER
PH04040 UPGRADED COGNOS FOR MICROSOFT OFFICE REPORT RESULTS IN DATA SOURCE AND REPORT PROMPTS LOOP
PH08297 DETAIL AGGREGATION PROPERTY ‘AUTOMATIC’ IS CHANGED TO ‘DEFAULT’ WHEN REPORT IS UPGRADED CAUSING CUSTOM FILTER …
PI95874 CHECK BOX GROUP NOT SHOWN PROPERLY IN COGNOS ANALYTICS 11.0.8 FOR REPORTS UPGRADED FROM 10.X
PH07277 IN CA 11.1 CAN NOT HAVE DIFFERENT MEMBERS FROM DIFFERENT HIERARCHIES FROM THE SAME DIMENSION IN A CONTEXT …
PH06699 CA DASHBOARDING: LOCAL FILTER START AND END DATES DEFAULTS TO 1970/01/01
PH05933 SPECIAL CHARACTER SHOWS WHEN A REPORT IS RUN FROM A PACKAGE WITHHEX CHARACTERS (HEX ‘1D’)
PH07939 EDITING UPGRADED JOBS WITH PROMPTS IN 11.1.1 NEW UI CAUSES THE PORTAL TO FREEZE
PH01512 CONTENT LOCALE SET AS ENGLISH WHEN LOGIN USING LDAP NAMESPACE AFTER UPGRADE TO CA 11 (R11) OR HIGHER
PH04310 SELECT CONNECTION PROMPT DOES NOT SHOW DATASOURCE NAME
PH08406 DRILL-THROUGH IN DASHBOARD LOSE SITS TARGET WHEN COPYING OR DEPLOYING THE FOLDER WITH DASHBOARDS AND REPORTS
PH06606 A SEQUENCE OF ACTIONS ON CREATION OF THE MULTI MEASURE LEAD TO THE INSERTION OF A DATAVIEW WITH A WRONG …
PH08394 CA 11.1.1 CANNOT CONNECT TO DB SERVER WITH TLS 1.2 WHEN USING IBM JRE
PH08371 CASE STATEMENT LITERALS MISSING NCHAR/NVARCHAR PREFIX N
PH07686 OBJECTS DON’T SHOW UP AFTER RE-OPENING LONG LIST IN TEAM CONTENT
PH07689 PARAMETER VALUES IN MULTI SELECT PROMPT NOT SAVED IN JOBS
PH07818 THE DATA ITEM WHEN CONTAINS IF THEN ELSE STATEMENT IN ITS EXPRESSION RESULTS IN INCORRECT OUTPUT ON A REPORT.
PH08848 “MY CONTENT (DEV)” APPEAR IN ROLE FEATURE
PH08724 LAUNCH LEGACY UI TRANSLATION IN GERMAN WRONG
PH08610 WHEN LANGUAGE IS SET TO CHINESE (TAIWAN), THE PROPERTIES PAGE FOR MANAGE->PEOPLE->ACCOUNTS->NAMESPACES->COGNOS …
PH08476 ABILITY TO COPY A QUERY FROM ONE REPORT TO ANOTHER BLANK REPORT NOT WORKING
PH08576 SCHEDULED EVENT GENERATES AND DELIVERS REPORT WITH WRONG FORMAT AND METHOD
PH08580 INTERNAL ERROR: ‘REPLACEMENTS.SIZE() > 1’ WHEN RUNNING A REPORT WITH CROSSTAB SPACES
PH07154 PRETTIFY BUTTON INSERTS EXTRA SPACES IN THE CALCULATION USED IN A DASHBOARD WHICH CAUSES VALIDATION ERRORS ON …
PH07168 EVENT AGENT
PH06607 DECIMAL FUNCTION THROWS XQE-PLN-0264 ERROR
PH06682 FOOTER IN CUSTOMIZED QUERY STUDIO TEMPLATE APPEARS DIRECTLY BELOW THE PAGE OBJECTS AND FLOATS
PH06799 AUTO-CREATED CHART TITLE IS GARBLED WHEN PRODUCT LANGUAGE IS JAPANESE
PH06577 EXCEL FILE UPLOADS FAIL WHEN RDS SERVICE IS NOT ENABLED.
PH09548 DRILL-THROUGH TO SUBSEQUENT TARGET REPORT RESULTS WITH APPBAR AND NAVBAR REAPPEARING.
PH07454 THE COMBINATION OF CASE STATEMENT AND DIVISION CALCULATION CAUSES ROUNDED VALUE
PH07571 IMAGE EXTENSION WITH BLANK IN EXTENSION NAME OR IMAGE NAME DOES NOT WORK AND EXTENSION CANNOT BE DELETED …
PH09050 SIZE AND OVERFLOW PROPERTY NOT WORKING FOR TEXT BOX PROMPT WHEN USING AN 11.X STYLE WITH FULL INTERACTIVITY …
PH08922 DATA CONTAINING VALUES ‘R5′ AND ’63’ DO NOT DISPLAY CORRECTLY INDASHBOARDING
PH09020 DASHBOARD MAPS DO NOT KEEP THE CONTEXT WHEN FILTERED ON COUNTRY CODE
PH09334 INCORRECT SEARCH RESULTS WHEN TRY TO MATCH LAST CHARACTERS OF NAMES AND DESCRIPTIONS
PH09396 DRAGGING A QUERY SUBJECT INTO A REPORT DISPLAY US AN EMPTY LIST
PH09403 ELEMENT CANNOT BE EMPTY ACCORDING TO THE DTD/SCHEMA ERROR WHEN TING TO SAVE A REPORT
PH09038 PROMPT DRIVEN BY PROMPT MACROS IN NATIVE SQL MANDATORY ON VIEW RECENT RUN
PH09291 ATTEMPT TO MODIFY A DASHBOARD FILTER FAILS.
PH08575 INTERNAL ERROR CODE ON NODE ‘V5EDGEGROUP’. NESTED HIERARCHIES ARE NOT NORMALIZED WHEN RUNNING A REPORT
PH08777 NO MORE “CAPABILITIES” TAB IN “TEAM CONTENT” PROPERTIES
PH08347 SCHEDULING AN EVENT RETURNS – SAXEXCEPTION: INVALID ELEMENT
PH06492 PARAMETERIZED URL TO PERFORM LOGIN DOES NO WORK WHEN USING A CUSTOM LOGIN PAGE
PH07005 CHANGING OUTPUT FORMAT OF A REPORT WITH PROMPT PAGES, THE PROMPTPAGE DOES NOT REFLECT THE FONT AND COLOR …
PH07765 CYRILLIC CHARACTERS ARE NOT DISPLAYED CORRECTLY IF THE DATA TYPEIS TEXT BLOB
PH07668 DASHBOARD DRILL THROUGH SOURCE VALUES NO LONGER SET WHEN EDITING
PH08010 OWNER OF A SECURITY FOLDER DISPLAYED AS UNKNOWN
PH08171 INCORRECT ROUND FUNCTION OUTPUT WITH POSRGRESQL DATA SOURCE.
PH08125 RUN AS EXCEL DOES NOT OPEN OUTPUT IN EXCEL APP ON IOS
PH07700 “CREATE A NEW JOB” FEATURE MISSING UNDER ROLE CUSTOMIZATION THEREFORE CANNOT BE REMOVED FROM A ROLE
PH08199 INTERMITTENT CCL-BIT-0006 WHEN RUNNING FRAMEWORK MANAGER AGAINST11.1 ON CLOUD.
PH08177 LONG REPORT NAMES ARE CUT WHEN LEAVING THE REPORT NAME EDIT FUNCTION WITH ESC
PH08186 USERS RECEIVE AN UNHELPFUL ERROR MESSAGE WHEN THEY SAVE/SAVE AS A DASHBOARD WHERE THE ASSET HAS BEEN DELETED …
PH06769 CROSSTAB SPACE AND TUPLE CALCULATION COMBINATION GIVE A RSV-SVR-0040 ERROR
PH07518 COULD NOT SWITCH TO EDIT MODE DUE TO UNEXPECTED ERROR IN A REPORT THAT CONTAINS UNION QUERY WITH A DATA MODULE
PH07339 MY SCHEDULES AND SUBSCRIPTIONS RETURNS ADM-ERR-001 WITH A USER THAT BELONGS TO MORE THAN 1024 COGNOS GROUPS
PH07269 SWIDTAG FILE IS MISSING FOR 11.0.13
PH07131 LANGUAGE SELECTION WHEN CREATING PACKAGE AGAINST TM1 CUBE SLOW WITH PA CONNECTION
PH06863 BORDERS ON SHAPES IN A DASHBOARD ARE VERY THICK IN IE AND EDGE
PH07488 PERFORMING A SHIFT CLICK IN A CROSS TAB DOES NOT SELECT THE CORRECT CELLS
PH07274 USER WILL BE ABLE TO CREATE AND RUN CROSS-JOINED REPORT USING THE PACKAGE THAT DENIED OF CROSS PRODUCT ALLOWED …
PH07319 REFRESH OF A NON-VISIBLE WIDGET ( FROM OTHER TAB OR IN DIFFERENTSTORY SCENE ) FREEZE BROWSER IN COGNOS 11.0.13.
PH07465 COGNOS ANALYTICS 11.0.13 – MANAGE ACTIVITIES DOES NOT SHOW ANY PAST ACTIVITIES
PH09577 IFRAME/HTML TAG GIVES ERROR ON EXECUTION
PH09575 WHEN CLICKING ON TEAM CONTENT AND BROWSING FOR FILES/FOLDERS, THE MORE BUTTON IS NOT VISIBLE AND YOU CAN’T …
PH10343 COLUMN DEPENDENCIES WILL NOT LOAD IN DATA MODULES
PH09905 UNABLE TO EDIT ACTIVE REPORT VARIABLE – TYPEERROR: UNABLE TO GETPROPERTY ‘SETATTRIBUTE’
PH10088 DASHBOARD TITLE BLOCKS POP UP MENU
PH08272 DASHBOARD WIDGET DISPLAY “QUERY SERVICE INTERNAL ERROR” WHEN SELECTING FILTER VALUES
PH03695 NOT ABLE TO RUN REPORT IN PARALLEL BURST, WHEN USING DMR. FAILEDAND ERROR XQE-GEN-0002 AN UNEXPECTED EXCEPTION …
PH04937 HARD CODED CONNECTION POOL SIZE 100
PH06216 SECURITY CONCERN REGARDING DOCUMENTED CHANGES TO BADCSSCHARS FORSITEMINDER INTEGRATION
PH06697 DATE FILTERS IN LOCAL FILTERS OF DASHBOARD RESULTS IN ERROR: DATA TYPES STRING AND TIMESTAMP-DATE TIME CANNOT …
PH03215 MISSING OBJECTS LISTED UNDER MY CONTENT
PH07256 SEARCHING A LARGE LIST HIERARCHY IN CA IN A SEARCH & SELECT PROMPT TAKES SIGNIFICANTLY LONGER THAN IT DOES IN …
PH08447 EDIT A QUERY SET (UNION) CHANGES THE USAGE TYPE ALL QUERY ITEMS USAGE TO UNKNOWN
PH07931 DPR-ERR-2056 WHEN RUNNING A DQM LIST REPORT WITH MULTIPLE COLUMNS, NO DUMP GENERATED
PH06197 INTERACTIVE REPORT USING CQM PACKAGE AND RUN AS HTML IS VERY SLOW TO PAGE DOWN
PH07243 ADDING CERTAIN AMOUNT OF DASHBOARD ITEMS GIVES A QUERY SERVICE INTERNAL ERROR.
PH08048 COGNOS DRILL THROUGH WITH ‘DO NOT USE PARAMETER’ STILL PASSES PARAMETER
PH07951 TREE PROMPTS ARE EMPTY IN REPORTS BASED ON A PA PACKAGE
PH07775 SET A PROMPT PAGE AS HOME PAGE DOES NOT WORK
PH05995 DASHBOARD VISUALIZATIONS RETURN AN INTERNAL ERROR HAS OCCURRED FOR CALCULATIONS WHEN SELECTING FILTERS
PH07934 VISUALIZATION WARNING IN DASHBOARDING IS NOT CONSISTENT
PH06285 _MONTHS_BETWEEN FUNCTION THROWS XQE-DAT-0001 ERROR
PH05625 BLANK PANE AFTER SUPPRESSING EMAIL DELIVERY NAMESPACES LIST
PH07114 XQE-PLN-0264 WARNING WHEN VALIDATING THE HOUR FUNCTION WITH A PACKAGE USING A LIMITED FUNCTION SET
PH06380 404 CLICKING ON GO TO THE WELCOME PAGE IN POWERPLAY STUDIO
PH05797 PADDING IS IGNORED FOR BLOCK WHEN ALIGNMENT SET FOR BLOCK PARENTCONTAINER
PH05243 SORTING DOES NOT WORK ON CALCULATED MEASURES FOR DYNAMIC CUBES
PH06032 XQE-DAT-0001 USING _FIRST_OF_MONTH WITH DATE FUNCTION AGAINST DB2
PH04728 VALUE FUNCTION NOT VALID WITH MORE THAN 2 ARGUMENTS IN DQM
PH01887 AFTER APPLYING FP10 ON 10.2.2 FP1, CALCULATED VALUE OF CROSSTABREPORTS IS CHANGED
PH01982 SEARCH AND SELECT PROMPT NOT WORKING WHEN RUN IN NON-HTML FORMATAND FULL INTERACTIVITY SET TO YES
PH02097 RIGHT-CLICKING A DATA ITEM IN EVENT STUDIO CAUSES INTERNET EXPLORER CONTEXT MENU TO OVERLAP THE EVENT STUDIO …
PH02016 RENAMING A LOCAL CLASSES USED IN REPORT BREAKS ALL ITEMS WHERE THE CLASS WAS USED
PH02174 MSAS MUN WITH SPECIAL CHARACTERS RETURNS NO DATA
PH00313 DELETED ALTERNATE HIERARCHY IN VIRTUAL CUBE APPEARING IN THE PACKAGE WHEN CREATING REPORTS
PH02335 JAVASCRIPT ERROR WHEN ATTEMPTING TO USE BUILD PROMPT PAGE ON A VISUALIZATION
PH02308 XQE-GEN-0005 ERROR ON MAXIMUM() DATE CALCULATION IN DQM REPORT
PH02045 CQM AND DQM RETURNS DIFFERENT RESULTS WHEN TESTED ON A PACKAGE WITH MULTIPLE UNIONS
PI96555 MARGIN IN CHART CAUSES TOOLTIP TO NO LONGER WORK
PI97136 RUNNING THE REPORT AS XML IN MOZILLA FIREFOX BUGS THE UI.
PI97960 UNDER “MY SCHEDULES AND DESCRIPTIONS” A COGNOS ANALYTICS USER ISABLE TO SEE ALL CURRENT RUNNING INTERACTIVE …
PI97972 NUMBER PAD ON THE RIGHT-SIDE OF THE KEYBOARD IS NOT WORKING FORTHE LIST BOX VALUE PROMPT
PI96356 INTERMITTENT XQE ERRORS BURSTING REPORT
PI95258 NON-INTERACTIVE VIEWER RADIO BUTTONS ARE SQUISHED TOGETHER
PI91255 THE METADATA DID NOT LOAD WHEN CREATING DASHBOARDS WITH SECURED CUBES
PI88781 CROSSTAB IGNORES ROW CALCULATION IF THERE IS A CALCULATION ALREADY IN THE COLUMN
PI97223 DRILL THROUGH DOES NOT SHOW ERROR WHEN OPENED IN NEW WINDOW AND INTERACTIVITY SET TO NO
PI94889 DATA MODULE TRY IT MODE ERROR WHEN RUN AS ‘VIEW TABULAR DATA’: ERROR MODULE NOT FOUND
PI93995 Replace option is not available when selecting multiple items
PI89965 ERRORS WHEN UPLOADING FILES AND ON CREATING NEW DASHBOARDS IF THE COGNOS SERVICE NAME CONTAINS BRACKETS
PI92993 ERROR TESTING STORED PROCEDURE QUERY SUBJECT IN FRAMEWORK MANAGER USING DQM WHEN DATABASE NAME CONTAINS AN …
PI92809 IMAGE FOR ZERO SUPPRESSION MISSING AND ADDITIONAL COLUMN FOR EXCEL EXPORT
PI91944 NEW QUERY ITEM INVOKES ERROR WHEN USING EDIT TO ACCESS AUTHORINGMODE
PI94216 INFINITE LOOPING IN BINARYSEARCH WHEN PROCESSING A LARGE ARRAY.
PI91251 UNABLE TO USE SAME FILTER WITH TWO DIFFERENT USAGES TYPE.
PI92069 CROSSTAB REPORT THAT USES DQM TO ORACLE RUNS FINE IN 10.2.2 BUT GET NO DATA FOR A SUBSTR CALCULATION WHEN …
PI87706 EXCEL2007 OUTPUT CELL WIDTH WAS CHANGED AFTER APPLYING FP6 TO FP2 ENVIRONMENT.
PI85932 MESSAGE LOGGED AS ERROR WHEN AUTO UPDATE OF IN-MEM AGGREGATES DONE SHOULD BE INFO
PI87918 SAVE AS DOES NOT RETAIN REPORT LOCATION AFTER CONVERTING QS REPORT
PI88451 REPORT SELECTION IN THE DRILL-THROUGH DEFINITION WINDOW OPENS TOTEAM CONTENT INSTEAD OF TO THE PATH OF THE …
PI89111 EXPLORE ICON WITH GLOSSARY AND LINEAGE OPTIONS MISSING
PI88445 TOTAL COLUMNS SHIFTED ON DELETE IN REPORT AUTHORING
PI88459 USING “MY INBOX” TO VIEW REPORTS, RECEIVING A SOAP FAULT ERROR WHEN EDITING PORTLET AND RETURNING TO THE …
PI89755 “XQE-V5-0005 IDENTIFIER NOT FOUND” ERROR IN REPORT SERVER WHILE REFERENCING QUERY ITEMS BASED OF NESTED …
PI88973 THERE IS ADDITIONAL WHITE SPACE ADDED IN TH REPORT WHEN BROWSER IS SWITCHED TO FULL SCREEN MODE (F11)
PI89669 LINEAGE OPTION NOT AVAILABLE FOR REPORT HEADER
PI87379 INSTALLATION OF 11.0.7 ON TOP OF 11.0.5 FAILS
PI88395 THE ANALYTICS WELCOME MENU AND THE MENU UNDER THE HEAD TO ALLOW LOGOFF GETS COVERED BY REPORT.
PI91376 11.0.8 CUSTOM FILTER IN RUN MODE MISSING FIND IN THE VIEWER
PI90898 FILTER MISSING WHEN EXPORT TO EXCEL
PI86598 LINK IN ERROR MESSAGE ENDS IN: OOPS THAT’S NOT RIGHT! THE PAGEYOU REQUESTED CANNOT BE DISPLAYED. 403: FORBIDDEN
PH05539 SAVING A DATAMODULE THROWS ERROR IN COGNOS ANALYTICS R12 IF COGLOCALE.XML IS CUSTOMIZED
PH05532 XSQL PARAMETER DOESN’T EXIST.
PH03748 CANCELING A BURST REPORT DOES NOT WORK IN A DISTRIBUTED ENVIRONMENT
PI99118 SAVED ACTIVE REPORT DRILL THROUGH SHOWS CLASSIC VIEWER INSTEAD OF C11 VIEWER
PH05120 QUERY SERVICE INTERNAL ERROR IN NESTED VISUALIZATION IN DASHBOARD AGAINST PLANNING ANALYTICS SOURCE
PH02471 MASTER DETAIL REPORT WITH NULL SUPPRESSION IN HTML DOESNT DISPLAY DATA WHEN THE CROSSTAB IS DISPLAYED OVER …
PH02626 11.0.12 RUNNING A REPORT IN BACKGROUND, WITH PROMPT ME CHECKED, THEN CLICK ON THE MAIN PAGE WILL RESULT IN …
PH03114 PROMPT BUTTON WIDTH CAN NOT EXCEED A WIDTH OF 4 CM
PH03240 SCHEDULED EMAIL EVENTS DO NOT MAINTAIN CORRECT REPORT FORMAT FORATTACHED REPORTS
PH03394 MULTI-FACT SCENARIO PROVIDING INCORRECT RESULTS
PH00291 NEW SUBSET CREATED IN PA NOT VISIBLE IN CA UNTIL PA SERVICE RESTART
PH02974 REPORT WITH PROMPT API GENERATES AN ERROR THAT THE PROMPT CONFIGURATION CONTAINER WAS NOT FOUND WHEN RUN AS …
PH02734 SCHEDULED EVENT AGENT FAIL IF MODIFIED BETWEEN SCHEDULE EXECUTION
PH03683 REPORT IN EXCEL FORMAT ONLY DISPLAYS 12 DECIMAL PLACE VALUES.
PH03229 CREATING A SECTION AND UNSECTION THE DATA ITEM CAUSES THE LAYOUTTO GET MESSED UP
PH03295 UNABLE TO SATISFY BYPASS BLOCKS FOR WEB CONTENT ACCESSIBILITY GUIDELINES (WCAG) 2.0
PI93435 ERROR USING TIMSTAMP FUNCTION AGAINST DB2 10.1
PI89550 COGNOS 10 VIEWER DISPLAYED WHEN DRILL THROUGH FROM REPORT WITH MULTIPLE DRILL THROUGH LINKS
PI99334 PACKAGES IN R11 WILL BE SHOWN AS SOURCE IN AUTHORING MODE ALTHOUGH THEY HAVE NO RS CAPABILITY
PH00526 CONDITIONAL VARIABLE SET ON A PROMPT PAGE WILL CAUSE THE ‘NEXT’ PROMPT BUTTON TO BE GREYED OUT
PH00589 GREENPLUM JDBC CALLS NOT ESCAPED
PH00714 INCORRECT NESTING IF THE CROSSTAB CONTAINS A CHILDREN() FUNCTION
PH00340 ‘PROMPT FOR VALUES’ OPTIONS IS UNCHECKED/CHECKED WHEN REPORT IS SAVED AS REPORT VIEW DURING INTERACTIVITY …
PH00163 SELECTION CONTEXT NOT POPULATED IN GO TO PAGE WHEN DRILLING FROMPOWERPLAY STUDIO
PH00144 MULTIPLE NESTING IN A CROSSTAB IS NOT WORKING USING FIREFOX
PI99684 DATA SET RUN TAKE MORE TIME THAN REPORT RUN FOR THE SAME QUERY ON A POWERCUBE
PI99406 WHEN RUNNING REPORT TO RUN IN BACKGROUND AND SELECTING PRINT REPORT. REPORT RUNS EVEN IF NO PRINTER HAS BEEN …
PH04427 THE DISPLAY VALUES OF PACKAGE-BASED DRILL-THROUGH NOT SHOWING CORRECTLY.
PH04650 ROLES APPLIED ON PARENT TENANT IS NOT REFLECTED ON CHILD TENANTSROLES.
PH04790 CROSSTAB IN A DASHBOARD FAILS WHEN THERE ARE MULTIPLE MEASURES AND ONE HAS ZERO VALUES.
PH05772 REPORT EXECUTION TIME INCREASE SIGNIFICANTLY FROM 10.2.2 TO CA 11.0.13 FOR REPORTS WITH LARGE PROMPT SELECTION
PH04404 FOLDEROPENER ACTION CONTROLLER WILL NOT DISPLAY TAKE OWNERSHIP FUNCTIONALITY
PH05656 FRAMEWORK MANAGER ERROR XQE-DAT-0001 AGAINST INFORMIX 12 WHEN TRYING TO TEST OR VALIDATE A QUERY SUBJECT WITH …
PH02036 REMOVE FEATURE NOT AVAILABLE FOR A DATA SOURCE WHEN VISUALIZATIONS CONTAINING DATA ITEMS FROM THAT DATA SOURCE …
PH02078 ‘ACTION IS NOT AVAILABLE FOR SELECTED DATA’ ERROR WHEN SELECTINGUNDO DRILL DOWN IN WORKSPACE
PH04847 DASHBOARD WIDGET INTERVAL REFRESH WILL CONTINUE WHEN AN ERROR HAPPENS
PH03369 STORED PROCEDURES NOT GETTING IMPORTED IN FM ON CA 11.0.12 WITH EDB POSTGRES ADVANCED SERVER 10.0
PH05052 URL TO “MY CONTENT” IS DIRECTED TO “MY CONTENT/MY FOLDERS”
PH02515 A CALCULATED MEASURE IN A CROSS-TAB GIVES DIFFERENT OUTPUTS WHENTHE CONTEXT FILTER IN THE REPORT IS SET TO …
PH04168 VISUALIZATION GALLERY FILTER CHECKMARK DISAPPEARS
PH04851 STICKY POPUP FOR THE TIMER AND FILTER LOWER PRIORITY
PI95196 A REPORT ORIGINALLY LINKED TO A CQM PACKAGE GIVES THE WRONG OUTPUT FOR A CALCULATED TOTAL WHEN THE PACKAGE IS …
PI92854 MSR-API-0002 ERROR FOR LINEAGE ON CALCULATIONS
PH03855 NUMBER FORMATTING IMPACTING DECIMAL PRECISION
PH00118 SHARE LINK INCORRECT AFTER NON-INTERACTIVE DRILLTHROUGH
PH04034 THE VENDOR SPECIFIC FUNCTION IS NOT SUPPORTED
PH04029 COM.COGNOS.XQE.AST.SQL.SQLALIAS INCOMPATIBLE WITH COM.COGNOS.XQE.AST.RQP.RQPDATAITEM
PH04085 SELECT ALL AND DESELECT ALL LOSE ALIGNMENT AFTER MIGRATION
PH03744 CUT THE QUERYITEMS FROM THE REGIONSLOT IN VISUALISATION MAP DELETES THE COMPLETE QUERY
PH02645 RSP-SRV-0078 OPENING ACTIVE REPORT IN EDIT AFTER IMPORTING IT FROM 10.2.2 INTO CA 11.0.10
PH03416 NULLPOINTEREXCEPTION WHEN USING CALCULATED MEASURE FROM MODEL THAT HAS DIVISION
PH01505 GLOBAL PARAMETERS SHOW ONLY TOP ELEMENT FOR DIMENSIONAL PACKAGE OFF OF TM1 CUBE
PH02809 CASTING PARAMETER AS INTEGER TO QUERY DATABASE CAUSES NULL POINTER EXCEPTION
PH05239 HTTP 404/504 ERRORS
PH05150 ERROR “TYPE:INVALIDDATATYPEVALUEEXCEPTION, MESSAGE:VALUE ” WHENOPENING 10.2.1 MIGRATED QUERY STUDIO REPORTS …
PH04073 PASS-THROUGH IN DETAIL FILTER DOES NOT VALIDATE IN DQM
PH04075 GENERATED SQL USES REPROT QUERY NAME IN FROM CLAUSE WHICH DOES NOT EXIST
PH04087 WARNING LISTS INCORRECT DATATYPE
PH02051 LANGUAGE CHANGE IN ‘RUN AS’ OPTION DOESN’T CHANGE PROMPT PAGE LANGUAGE IN 11.0.12
PH03828 EXECUTING AN EVENT STUDIO AGENT SHORTCUT CREATES NO OUTPUT AND NO RUN HISTORY
PH05244 XQE-GEN-0005 SQLPARAMETER INCOMPATIBLE WITH COM.COGNOS.XQE.AST.V5EXP.V5SIMPLENODE
PH05241 ARRAYINDEXOUTOFBOUNDSEXCEPTION “XQE-GEN-0018”, “MESSAGE”: “QUERY SERVICE INTERNAL ERROR HAS OCCURRED
PH05255 DATA PLAYER VISUALIZTION DOESN’T APPEAR IN DASHBOARD SAVED WITH PRE-SELECTED LIST VALUES
PH05314 CLICKING ON THE COUNT OPTION IN A COLUMN IN A TARGET REPORT RESULTS IN AN ERROR.
PH05020 REPORT DRILLING THROUGH TO ITSELF NOT DISPLAYING PROMPT PAGE
PH05600 INSTRUCTION OF INT FUNCTION IN IN LINE HELP IS NOT CORRECT
PH03373 XQE HANDLER TRACE BACK ERROR TESTING ANY DATASOURCE CONNECTION FROM GLASS UI WITH IHS 9.0
PH05355 CROSSTAB SPACER AND A CONDITIONAL STYLE DON’T WORK TOGETHER IN A CROSSTAB, THROWS XQE-PLN-0003
PH05363 WHEN A USER IS SENDING AN EMAIL OUT IT IS ALWAYS BEING SENT FROMTHE EMAIL ADDRESS SPECIFIED IN THE DEFAULT …
PH05356 NULL IN DATA DISCRETE VALUE SLIDER IN AN ACTIVE REPORT RESULTS IN ERROR “CANNOT READ PROPERTY 0 OF UNDEFINED”
PH05410 MAPBOX VISUALIZATION DOESN’T RENDER IN A MULTI-TABBED REPORT
PH06080 QUERY INFORMATION WINDOW CENTERING TEXT
PH06043 CHANGING THE TITLE CAUSES THE GRAPH NAME TO CHANGE WHEN EXPORTING TO XLS
PH06004 BREAD CRUMBS FAIL TO RENDER IN VIEWER WITH FULL INTERACTIVITY SET TO YES
PH09149 MSR-GEN-0002 MFWSHORTCUT INCOMPATIBLE WITH COM.COGNOS.XQE.METADATA.ICALCULATION ERROR WHEN CREATE A DATA …
PH09227 ALL PARAMETERS NOT AVAILABLE IN THE MY PARAMETERS DIALOG WHEN USING DYNAMIC CUBES
PH08865 USER UNABLE TO SEE SUBFOLDERS SECURED USING A GROUP WITH TENANT SET TO A TENANT FROM TENANT BOUNDING SET
PH09131 RUN THE REPORT AND CLICK SAVE AS THE FOLLOWING XML ERROR MESSAGEAPPEARS: ELEMENT CANNOT BE EMPTY ACCORDING TO …
PH08973 OVERWRITING REPORTS IN BULK DOES NOT WORK.
PH04572 UNABLE TO IMPLEMENT SSL 3RD PARTY CA
PH06612 URL USING CAMPASSPORT ID DOES NOT SHOW USER PREFERENCES-PERSONALDETAILS
PH06602 SAVED PROMPT VALUES ARE BEING SKIPPED WHEN EXECUTING REPORT VIEWS WITH SAVED PROMPTS AND SELECTING “PROMPT ME” …
PH06781 DRILL THROUGH DEFINITION FOR TARGET REPORT DEFAULT ACTION WITH OPEN WITH ANALYSIS STUDIO DOES NOT APPEAR ANY …
PH05370 WHEN USER NESTS TWO HIERARCHIES ON A VISUALIZATION (COLUMN CHART) AND XQE ERROR IS GENERATED
PH05182 CONCATENATION OF 3 STRINGS IN ONE EXPRESSION CAUSES REPORT OFF PLANNING ANALYTICS TO HANG
PH06303 PACKAGE WITH MULTIPLE DYNAMIC CUBES CAUSES REPORTS TO FAIL
PI97330 REPORT DESIGN: CREATE FILTER DIALOG NOT FULLY SHOWN/ USABLE WITHLOW SCREEN RESOLUTIONS
PH04129 DASHBOARD EXECUTED IN R7 RENDERS AND LOADS THE WIDGETS WHEREAS IN R12 WIDGETS DO NOT ALL LOAD.
PH04888 VIRTUAL CUBES SHOWS INCORRECT RESULT IN DASHBOARD
PH06894 IDENTIFIER NOT FOUND ERROR IS GENERATED FROM PROMPT MACRO
PH06923 COM.COGNOS.XQE.AST.SQL.SQLAGGREGATE INCOMPATIBLE WITH COM.COGNOS.XQE.AST.V5EXP.V5SIMPLENODE
PH06927 XQE-PLN-0248 WHEN FILTERING BASED ON OTHER QUERY
PH06954 UNABLE TO COPY/PASTE QUERY OBJECTS BETWEEN REPORTS IN 11.1.1 IN FIREFOX/CHROME
PH06932 INVALID CHILD FOR NODE OF TYPE ‘COGMDXGROUP’
PH06812 NULLPOINTEREXCEPTION WHEN CASTING LONG VARCHAR
PH06817 SUBSTR FUNCTION THROWS XQE-PLN-0264 ERROR
PH08203 LICENSE TOOL SHOWS USER WITH COLLABORATE AND RUN WITH OPTIONS CAPABILITIES AS INFORMATION DISTRIBUTION
PH02344 OPTIONAL RADIO BUTTON PROMPT DOES NOT HAVE DESELECT OPTION IN INTERACTIVE MODE
PH07578 DATA MODULE BASED ON A DATA SET WILL DISPLAY EMPTY CELLS
PH07198 RSV-SRV-0003 ERROR WHEN TRYING TO EXPAND A MEMBER WITH MSAS CUBEIN A REPORT
PH03023 USING EMBEDDED LOGIN OPTIONS DOES NOT ALWAYS LOGIN CONSISTENTLY ANY ANY BROWSER
PH01960 REPROMPT AND RUN DOESN’T CORRECTLY SET OUTPUT TYPE PARAMETER
PH04142 SCHEDULE THE AGENT IN EVENT STUDIO WILL NOT LAUNCH WHEN USING OIDC AS AN AUTHENTICATION SOURCE.
PH04173 XLSX ATTACHMENT CHANGE TO .HTML AFTER SCHEDULE UPDATE IN NEW GUI
PH03201 EVENT STUDIO AGENTS SHOW POOR PERFORMANCE
PH03246 USER WITH RUN PERMISSION TO A FOLDER CANNOT SCROLL THE ENTRIES DESCRIPTION WITHIN IT
PH04629 CAMID WITH AN APOSTROPHE CANNOT QUERY MEMBERS USING THE PLANNING ANALYTICS DATA SOURCE
PH03658 DISPATCHER WILL ROUTE DQM REQUESTS TO A QUERY SERVICE, EVEN IF IT IS IN A BUSY STATE.
PI94141 ERROR “CAN NOT RETRIEVE THE PASSWORD FROM CONFIGURATION.” IN COGSERVER.LOG
PH04407 GAUGE CHART REPORT REPRODUCED ERROR JAVA.LANG.NULLPOINTEREXCEPTION WHEN THE REPORT IS RUNNING WITH CONTENT …
PH03249 RQP-DEF-0068 UNABLE TO CONNECT TO AT LEAST ONE DATABASE DURING AMULTI-DATABASE ATTACH WITH EXTERNAL DATA FILES
PH03462 LOCAL CLASSES MISSING WHEN REPORTS RUN FROM HOME
PH03931 UPLOADED FILES HANGS WITH ROUTING RULES
PH04677 ERROR WHEN USING COUNT DISTINCT NESTED IN USER-DEFINED FUNCTION
PH04559 CONTEXT FILTER PROMPTS FOR REPORT DO NOT ALWAYS EXPAND TO SHOW MEMBERS FOR DIMENSIONS USING DQM PLANNING …
PH04011 WHEN USING CQM, THE CASE STATEMENT BRINGS BACK A DIFFERENT RESULT THAN THE IF STATEMENT
PH02707 EXPAND MEMBER OPTION ON HTML REPORT OUTPUT RESULTS IN DUPLICATE UNIQUE VALUE ERROR *
PH02604 RUNNING 2 ACTIVE REPORTS CONCURRENCY CAUSES XQE-GEN-0005 JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION
PH02687 SAVE AS REPORT VIEW ON SAMPLES REPORT (EMPLOYEE SATISFACTION) THROWS AN XML ERROR IF PROD LANGUAGE SET TO …
PH02648 UNCAUGHT TYPEERROR IF A TABLE CELL WITH A TAB CONTROL INSIDE IS GIVEN THE HORIZONTAL
PH03010 VALIDATION ERROR WHEN ADDING TEXT TO A TABLE WITH HEADERS DEFINED IN AN EMAIL TASK IN EVENT STUDIO
PH03126 WHEN SEARCHING A STRING LIKE ABC060DEFG, GETTING LINES WITH THEEXPECTED OBJECTS BUT ALSO OTHERS OBJECTS
PH02422 HTTP 503 ERRORS BETWEEN THE GATEWAY AND THE WEBSPHERE LIBERTY SERVER NOT HANDELED BY THE GLASS UI.
PH02381 A REPORT WITH A TABLE OF CONTENT AND A PROMPT PAGE DOES NOT SHOWTHE TABLE OF CONTENT WITH THE POINTS
PH00790 PASSING MULTIPLE PARAMETER VALUES TO A DRILL-THROUGH ACTIVE REPORT
PH02258 2 SELECT AND SEARCH PROMPTS CLEAR OUT EACH OTHER’S RESULTS IF NOSELECTIONS ARE MADE
PH02315 REPORT VIEW DOES NOT HAVE PROMPT FOR VALUES CHECKED EVEN REPORT ITSELF HAS.
PH02270 PROMPT VALUES KEEP ASKING FOR THE PROMPT VALUES AND NOT GETTINGPAST THE PROMPT SCREEN AGAINST SAP BW PROMPT
PH02053 TYPEERROR: CANNOT READ PROPERTY ‘SLICE’ OF NULL ERROR WHEN SETTING EXPLICIT DENY ON TEMPLATE
PH01282 IE – DRILL THROUGH DOESN’T WORK FOR SAVED EXCEL OUTPUT
PI99696 CREATING MORE THAN 15 SUBSCRIPTIONS FOR ONE REPORT RESULTS IN ERROR
PH00631 CUSTOM FILTERS IN REPORT OUTPUT NOT WORKING
PH01381 HTML ITEM AND FULL INTERACTIVITY TO YES
PH00999 CROSSTAB WITH CLASS DON’T PRINT ON A NODE MEMBER DOES NOT RUNS IN EXCEL
PI98666 DOT IN NAMESPACE ID CAUSES SERVICES TO STOP WORKING.
PI99776 NOT ABLE TO FILTER IN REPORTING USING ALIAS SHORTCUTS ON RELATIONSHIP JOINS IN FM
PI99575 IF A PROMPT IS REQUIRED AND THE COLOR OF ITS BUTTONS CHANGED, BUTTONS (NEXT, FINISH) ARE NO MORE GREYED
PI99572 THE FUNCTIONALITY OF PARAMDISPLAYVALUE() CHANGED TO NOT SHOW A VALUE WHEN THE PARAMETER “DISPLAY” VALUE IS NOT …
PI98903 MIS-ALIGNMENT IN RESULT AND CHOICE BOX IN SEARCH AND SELECT PROMPT
PI99167 DRILL THROUGH PASSES VALUE FROM PREVIOUS DRILL WHEN USING INTERACTIVE VIEWER
PH00334 WHEN EDITING AN ACTIVE REPORT WITH PROMPTS AND SELECTING PAGE VIEW->PAGE PREVIEW AN “HTML ITEM” ERROR OCCURS.
PH00946 DISABLING DELIVERYSERVICE CAUSE ERROR POP-UP WHEN GETTING SAVED REPORT
PI98237 PI98237 UNABLE TO SAVE TEMPLATE WITH READ PERMISSION ACCESS.
PH01010 TYPEERROR WHEN THE BOX TYPE IS SET TO BLOCK
PH01300 DATE CALENDAR RANGE PROMPT IS NOT WORKING CORRECTLY WHEN INTERACTIVITY IS SET TO YES
PH01747 SHARE URL INCONSISTENT BETWEEN RUNNING THROUGH EDIT MODE AND DIRECTLY FROM HOME PAGE
PH01186 NAVIGATE ON BUBBLE IN REPORT BUBBLE VISUALIZATION GOES BLANK
PH01193 FREEZE COLUMN HEADINGS ON CROSSTAB IN A TABLE FOR NON-INTERACTIVE REPORT CUTS OFF BOTTOM OF THE CROSSTAB
PH01214 DATA LIST TOTAL TRIES TO TOTAL A COLUMN OF ITEMS NOT USUALLY TOTALLED (STRING,MONTHS,CHARS)
PI99332 OPTIONAL DROP DOWN PROMPT HAS A VALUE SELECTED WITHOUT SETTING THE DEFAULT.
PI98500 CHANGING SORT ORDER IN DASHBOARD VISUALIZATION CHANGES COLORS AND LEGEND OF A CHART
PI98850 FOR THE CURRENT TIMESTAMP EXPRESSION, THERE IS A ONE HOUR DIFFERENCE BETWEEN USING #$CURRENT_TIMESTAMP# AND …
PI99126 XQE-DAT-0001 DATA SOURCE ADAPTER ERROR WHEN USING _WEEK_OF_YEAR ON DQM REDSHIFT PACKAGE
PI93124 COGNOS VIEWER DOES NOT CLOSE PROMPT PAGE AFTER SELECTING DELIVERY METHOD
PI99376 WHEN CALLING A REPORT VIEW BY A URL ITS NAME IS INCORRECT AND ENDS WITH … (NULL)
PI99716 HIDDEN FOLDER IN NAMESPACE STILL VISIBLE IN NEW UI
PI88585 PARAMETERIZED URL USED IN COGNOS 10.2.2 TO PASS DATA SOURCE CONNECTION NO LONGER WORKS IN COGNOS 11 R6.
PI99574 SELECTION MADE IN SELECT AND SEARCH PROMPT DISAPPEARS IF VALUES ARE SEARCHED FOR IN ANOTHER SELECT AND SEARCH …
PH00132 JAVA SCRIPT ERRORS WHEN TRYING TO OPEN TEMPLATES WITH CUSTOMIZEDPERMISSIONS
PI98318 IN DQM, ADDING A FILTER TO TABULAR SQL DOES NOT WORK.
PI99691 TYPE OF SYNONYM QUERY SUBJECT CHANGES WHEN THE OBJECT IS UPDATEDIN FM
PH00489 VARIOUS PROPERTIES FILES RELATED TO ERROR MESSAGES CONTAIN THE WRONG COGNOS VERSION 8 OR 10 INSTEAD OF 11
PH04328 DPR-ERR-2079 FIREWALL REJECTION ERROR DUE TO WEBSEAL CHANGING CONTENT-LENGTH TO LOWERCASE
PH04631 CONSOLIDATIONS WITH AN APOSTROPHE IN THE NAME CAUSE AN INVALID MEMBER REFERENCE WHEN EXPANDING THE METADATA …
PH01432 CUSTOMER ENCOUNTERS AN ERROR WHEN TRYING TO CREATE A RELATIONSHIP IN A DATA MODULE BETWEEN A PACKAGE AND A …
PH04297 COLORS ARE NOT DISPLAYED ON A CUSTOM MAP IN A DASHBOARD
PH03704 MAIL SERVER WITH TLS 1.2 ENABLED CAN’T BE CONFIGURED WITH COGNOS11.0.12
PH03543 USING MULTILINGUAL DYNAMIC CUBE PACKAGE THROWS XQE-GEN-0005 ERROR WHEN CHANGING LABEL.
PI94588 XQE-DAT-0001 ERROR WHEN USING FUNCTIONS THAT STARTS WITH “_” IN THE NAME WHEN CISCO INFORMATION SERVER IS THE …
PH04675 LIST REPORT WITH ROWS SUPPRESSION THROWS A XQE-GEN-0005 JAVA.LANG.NULLPOINTEREXCEPTION ERROR
PH02787 GETFORMFIELDVALUE METHOD FROM THE ITRUSTEDSIGNONREQUEST ISN’T WORKING IN COGNOS 11
PH02691 BACKGROUND RUN REPORT WITH DELIVERY VIA EMAIL SENDS REPORT EVEN THOUGH REPORT WAS CANCELLED WHILE IN EXECUTION …
PI96046 OUT OF MEMORY ERROR WHEN EDITING LARGE REPORT IN IE BROWSER
PI96741 REFRESH A PACKAGE OF A REPORT DATASOURCE WITH MULTIPLE PACKAGE WILL REMOVE ALL BUT ONE PACKAGE
PI96751 TEXT BOX PROMPT NOT SAVING PROMPT VALUE FROM REPORT PAGE WHEN RUN AS EXCEL
PI91538 ON CA11.0.7 SPECIFIC PROMPT VALUE COULD NOT BE DISPLAYED WHEN SET VALUES FROM PROPERTY
PH06179 DASHBOARD PERFORMS SLOWLY WHEN A CALCULATION IS ADDED TO A WIDGET
PH06204 FLYOUT PANEL IS EMPTY WHEN CLICK PROPERTIES OF A PACKAGE
PH05606 SORTING OF USERS WHEN VIEWING A NAMESPACE DOES NOT WORK AFTER USING THE SEARCH FUNCTION
PH05674 AGGREGATE RATIO WITH A DASHBOARD AND DATA MODULE
PH03771 ERROR “CM-REQ-4179 THE LOCALE “EN-US” IS NOT ONE OF THE CONFIGURED CONTENT LOCALES”
PH07797 AN ERROR OCCURS MSR-GEN-0002 ON BROWSER WHEN WE RUN A REPORT USING A DATA MODULE BY ACCESSING GATEWAY URI.
PH07889 REPORT FAILS XQE-V5-0011 IF FM PACKAGE WITH IF-THEN-ELSE CALCULATED ITEM JOINED TO UPLOADED FILE
PH06458 ERROR WHEN LOADING TM1 CUBES IN DASHBOARD TOOL
PI99378 TYPEERROR WITH SECTION AFTER CHANGING LIST TO CHART
PI99107 LIST GROUPING GETS LOST WHEN A QUERY CALCULATION IS ADDED
PI99325 MEMBER SEARCH FOR PLANNING ANALYICS SOURCE DOES NOT WORK CASE INSENSITIVE
PI99220 SQL QUERY OBJECT IN A REPORT AND CLICK ON THE TAB BUTTON AN ERROR MESSAGE OCCURS
PI93024 DRILL THROUGH IS NOW WORKING FROM A SAVED HTML VERSION OF A LISTREPORT
PI93594 DYNAMIC CUBE “NUMBER OF PROCESSED REQUESTS” METRIC IS NOT REFRESHED FOR DASHBOARD REQUESTS
PI98644 REPORT OPTIONS DO NOT SAVE UPON EXIT UNLESS A NEW REPORT IS CREATED
PI98681 SEARCH OPTION IS NOT AVAILABLE IN THE FILTER CONDITION DIALOG BOX IN REPORTING
PI98685 8.X REPORT STYLE NOT SHOW IN PROPERTIES
PI98089 TREEPROMPT: COGNOS OFFERS TO GO BELOW LOWEST LEVEL
PI98556 VERY BAD PERFORMANCE WHEN RUNNING A REPORT AGAINST IBM PLANNING ANALYTICS CUBE.
PI98550 UNABLE TO EXPORT TARGET REPORT , LINKS NOT AVAILABLE IN THE VIEWER.
PI97951 _DAY_OF_WEEK NOT PROCESSED ON DATABASE FOR EXASOL
PI98273 UNABLE TO CHANGE DATA FORMAT FOR CURRENCY FIELD IN CUBE DESIGNER
PI98484 DPR-ERR-2077 WHEN VALIDATING A REPORT WITH REQUIRED AND OPTIONALPROMPT
PI98260 DRILL-THROUGH TO SUBSEQUENT TARGET REPORT RESULTS WITH APPBAR AND NAVBAR REAPPEARING.
PI95719 DRILL UP/DOWN IS NOT WORKING FOR NAVIGATION PATHS IN REPORT AUTHORING
PI98216 _WEEK_OF_YEAR NOT PROCESSED ON DATABASE FOR EXASOL
PI98220 _MAKE_TIMESTAMP FAILS USING EXASOL AS DATASOURCE
PI97852 CA11 R10 – SILENT DISTRIBUTED GW ONLY INSTALL – INSTALLS ALL COMPONENTS
PI94046 VIEWING ACTIVITIES VIA MANAGE > ACTIVITIES IS MUCH SLOWER THAN THROUGH THE ADMIN COLSOLE
PI95816 IMAGE LIBRARY IN A ACTIVE REPORT, PAGE PREVIEW NO IMAGE SHOW
PI93218 UNABLE TO OPEN SECOND DRILL THROUGH REPORT WHEN A SOURCE REPORT IS INTERACTIVE AND TARGET REPORTS ARE …
PI66125 REPORT STUDIO: TIME INTERVAL FORMAT ON A NEGATIVE BIGINTEGER VALUE LEADS TO INCORRECT VALUE.
PI95168 MEMBER DESCRIPTION APPEARS AS (NO VALUE) WHEN DRAGGING INTO A DASHBOARD 11.0.9
PI96952 _DAYS_BETWEEN NOT PROCESSED ON DATABASE FOR EXASOL
PI87439 HTML REPORT OUTPUT IS NOT WELL FORMED. IF YOUR REPORT USES “HTMLITEM” ELEMENTS ENSURE THAT THEY RESULT IN …
PI96410 ORACLE TABLE NAME
PI95818 FEATURES DOES NOT WORK WITH MULTIPLE NETWORK CARD
PI92746 REPORT EXECTION VIA URL API IN CA11 DOESN’T RESPECT THE DEFAULT OUTPUT FORMAT
PI95288 XQE ERROR WHEN UPDATING SYBASE POWERDESIGNER METADATA IN A MULTILINGUAL FRAMEWORK MANAGER MODEL
PI95264 RECENT ITEMS REMOVED FROM WELCOME PAGE REAPPEAR WHEN USER LOGS BACK INTO COGNOS ANALYTICS
PI94774 ORDER OF THE PARAMETERS UNDER ‘MY PARAMETERS’ SECTION IN APPLICATION BAR.
PI95521 CHANGING FROM PAGE PREVIEW TO PAGE DESIGN VIEW REMOVES STYLE ANDFORMATTING AFTER RUNNING THE REPORT
PI94716 LAYOUT COMPONENT REFERENCE THROWS ERROR WHEN REFERENCING A TOOLBOX ITEM CONTAINING ANOTHER TOOLBOX ITEM
PI95072 EASY INSTALL DOCUMENTATION IS MISSING DETAILS ABOUT INSTALLATIONREQUIREMENTS IN TERMS OF INFORMIX USER AND …
PI91161 STYLE CHANGES IN THE REPORT CLASSES ARE NOT KEPT IN THE PDF OUTPUT. HTML SHOWS THE CORRECT FORMAT.
PI92050 DQM MODE INVALID METADATA RESPONSE.
PI92157 TARGET REPORT LOSES IT INTERACTIVITY WHEN DRILLING FROM A NON-INTERACTIVE REPORT
PI89842 ORACLE 12C EXTENDED DB TYPES WITH VARCHAR2(32767) DOES NOT WORK FOR COGNOS 10.2.X
PI92147 MAP ON 2ND TAB OR PAGE WILL NOT LOAD PROPERLY
PI91870 COGNOS REPORT BUTTON STYLES ISSUE IN CA 11.08
PI83431 ERROR V5BOUNDSQLQUERYITEMREFERENCE ON REPORT EXECUTION
PI80456 PROJECTED QUERY FAILS IN DQM PACKAGE WITH ERROR XQE-GEN-0005
PI81250 SUPPORT FOR DERIVED TABLES AGAINST SYBASE ASE
PI81032 NO GLOSSARY LINK WITH LIST OBJECT
PH08398 11.1.1 METADATA IMPORT FAILS FOR POSTGRES DB ON IBM CLOUD
PI98949 DISPLAY LICENSES WITH PRODUCT LOCALE GERMAN AND SORTED BY LAST LOGON SHOW INCORRECT ORDER
PI98436 XQE TAKE AN EXCESSIVE AMOUNT OF TIME TO RUN A QUERY
PI97766 TREE PROMPT BUTTONS NOT DISPLAYING WHEN SETTING PROMPT VALUES WHILE CREATING A JOB IN FIREFOX OR CHROME
PI92974 RIGHT TO LEFT ALIGNMENT DOESN’T WORK (WITH HEBREW)
JR59444 CANNOT MAP TABLE WITH BOOLEAN DATA TYPE ON AIX PLATFORM
PH08710 INCORRECT RESULT FOR SPECIFIC CALCULATION WITH ROUND FUNCTION (ORACLE DATASOURCE)
PH08808 SAVED ACTIVE REPORT DRILL-THROUGH NOT WORKING AS EXPECTED
PH09099 ROUTING SETS NOT ACKNOWLEDGED FOR DASHBOARDS AND STORIES WITH CALCULATION
PH07606 MULTIPLE PROBLEMS IN NEW JOB UI AFTER EDITING THE JOB IN “CLASSIC VIEW”
PH09632 ADDING SPECIAL CHARACTERS TO THE NAMESPACE ID CAUSES ERRORS WHENUPLODAING A FILE AND ADDING DATA TO A DASHBOARD
PH08831 COGNOS 11.1.1 SHOWS BLANK WINDOW WHEN CLICK ON PROPERTY OF THE TEAM CONTENT ‘S FOLDER OR CONTENTS LIKE PACKAGES
JR60884 FM PACKAGE PUBLISHED AS CQM FAILS TO SHOW DATA PREVIEW FOR DATA MODULES (SAME DATA AS DQM WORKS FINE)
PH09859 CUSTOM URL TO LOAD A BLANK NEW REPORT WITH A PACKAGE DOES NOT WORK IN 11.1.1
PH05839 SIGNING OUT BEFORE “REPORT HAS NO PROMPTS” POPS UP CAUSES THE REPORT NOT TO RUN
PH06127 ERROR EXECUTING REPORT IF USER DOES NOT HAVE READ PERMISSION ON THE DATA MODULE: MSR_GEN_0087, HTTP 403
PH06805 DASHBOARD DRILL THROUGH GIVING DIFFERENT OUTPUTS WITH ONE CHANGEIN CLICK
PH04816 ACTIVE REPORT REPORT VIEW ATTACHED TO EMAIL TASK IN AN EVENT FAILS WITH RSV-DST-0021
PI87080 ERRORS IN REPORT BUILT AGAINST MULTIPLE SQL SERVER DATABASES, USING CONVERT() FUNCTION: RQP-DEF-0177,…
PH05206 BLANK SCREEN BEFORE LOADING ICON APPEARS WHEN SETTING VALUE PROMPT IN A REPORT VIEW
PH04691 SAVE IN ‘MY CONTENT’ PROMPTS ERROR “YOU DO NOT HAVE THE APPROPRIATE PERMISSION TO SAVE THE OBJECT”
PH00796 FILTER AREA EMPTY IN DASHBOARDS
PH04228 FEATURES/FUNCTIONS FOR CAPABILITIES IN COGNOS WORKSPACE DO NOT ALIGN WITH DOCUMENTATION
PH04905 SAP IQ: QUERY SUBJECT VALIDATION FAILS BECAUSE OF “TOP 0” IN SELECT STATEMENT
PH03405 ‘UNDO DRILL DOWN’ THROWS ERROR IN COGNOS WORKSPACE
PH04951 IMAGES IN PDF OUTPUT FAIL TO LOAD IF SERVED VIA TLS1.2 BY MICROSOFT IIS USING SHA256 SIGNED CERTIFICATE
PH02492 WHEN SELECTING A VALUE THAT CONTAINS A SINGLE QUOTE (‘), THE RESULT IS A QUERYSELECTOR ERROR.
PH03916 SUM(1) STITCH QUERY RETURNING INCORRECT RESULTS IN CROSSTAB
PH04086 WARNING LISTS INCORRECT LOCATION
PH04078 CAST_DECIMAL(NULL) CANNOT BE EXECUTED IN DQM FOR DB2
PH02015 UNABLE TO CHANGE EVENT RUN HISTORY PROPERTIES
PH04025 LIMITING FUNCTION SET DOES NOT ALLOW FOR ALL FUNCTIONS
PH05341 CAST CURRENT_DATE TO TIMESTAMP RETURNS WRONG TIME PORTION WHEN PROCESSED LOCALLY
PH05325 USERS GETTING PERMISSIONS ERROR WHEN SAVING A REPORT
PH06148 DATE PROMPT SUBTITLE DISPLAY BECOME ‘ AND ‘ (CORRECT DISPLAY SHOULD BE ‘ AND )
PH08967 MAPS WITH FILTERS ON MULTI-PAGE REPORT DON’T FILTER
PH06813 CAST_INTEGER EXPECTING NUMERIC VALUE
PH07682 REPLACING A MEMBER PROPERTY WITH AN EQUAL DATA ITEM RENDERS COLUMNS BLANK IN A CROSSTAB
PI99651 SCHEDULED REPORTS FAILING WITH CM-REQ-4159 CONTENT MANAGER RETURNED AN ERROR IN THE RESPONSE HEADER/CM-CAM-4005
PH03172 WHEN MOVING MORE THEN THOUSEND ELEMENTS FROM THE LEFT TO THE RIGHT SIDE OF TEXT BOX PROMPT THEN THE …
PH01907 MAXIMUM EXECUTION TIME FOR THE BATCH REPORT SERVICE TUNING SETTINGS IN THE ADMINISTRATION CONSOLES DOESN’T …
PH02247 VIEW PAGES AS TABS DOES NOT WORK WHEN REPORT WITH SAVED OUTPUT IS EMBEDDED IN AN IFRAME
PH02187 EVENT STUDIO ‘SELECT VALUES’ WINDOW NOT FUNCTIONAL WITH LOWER SCREEN RESOLUTION
PH00841 USER SAVE A REPORT UNDER MY CONTENT ERROR MESSAGE APPEARS BECAUSE THE USER DOES NOT HAVE APPROPRIATE …
PH01026 DASHBOARD WITH BOTH A CROSSTAB AND A MAP VISUALIZATION GIVES A JAVASCRIPT POP-UP WHEN ATTEMPTING TO DRILL-DOWN …
PI99601 COGNOS ANALYTICS 11.0.11 INSTALLER ON SUSE LINUX CHECKS WRONG DIRECTORY FOR DISK SPACE
PI99739 AMBIGUOUS CONNECTION ERROR IN FRAMEWORK MANAGER
PI99573 UNEXPECTED BEHAVIOR IN DATA LIST COLUMN TITLE
PI99543 QUERY STUDIO CASTS NOT ONLY ON A TIMESTAMP FIELD BUT ALSO ON A DATE FIELD WHEN USING LAST NUMBER OF DAYS FILTER
PH04730 ERROR RECEIVED WHEN EDIT CONDITIONAL STYLE IN SAVED REPORT
PH04115 CA 11 REPORT USING CUSTOM FILTER AND HOLDING SHIFT KEY TO SELECTMULTIPLE ITEMS RESULTS IN SELECTED ITEMS COUNT …
PH04679 XQE-PLN-0020 FOR SPECIFIC COUNT DISTINCT SCENARIO
PH03363 PDS-PPE-0045 THE QUERY DOES NOT CONTAIN A MEASURE FROM SOME REPORTS WHEN USING NEEDZSFORVERYSPARSEPCCUBES
PH04412 WHEN USEOLDCUSTOMFILTERDIALOG IS ENABLED AND CONTENT PRODUCT LANGUAGE IS GERMAN THEN FIRST CHECK BOX IS …
PH03407 DRILL THROUGH TO SAME REPORT PASSING NO PARAMETERS DOES NOT CLEAR SELECTED PROMPTS
PH03975 EXCEL MERGES THE VALUES IN THE REPEATER.
PH05336 CSRM AKA REFLECTED LINK VULNERABILITY IN COGNOS ADMINISTRATION’SMYPROPERTIES FOR BACKURL PARAMETER
PI97775 CREATE REPORT VIEW DOES NOT WORK WHEN THE COGNOS ANALYTICS PORTAL IS EMBEDDED IN AN IFRAME
PI97751 CA 11 VALUE PROMPT NOT SAVING PROMPT VALUE FROM HTML REPORT OUTPUT PAGE WHEN SELECTING RUN AS EXCEL FROM …
IT20462 SECURITY: TSAMP PRIVILEGE ESCALATION VULNERABILITY AFFECTS DB2 (CVE-2017-1134).
IT20561 SECURITY: DB2 LUW ON AIX AND LINUX AFFECTED BY A VULNERABILITY IN GPFS (CVE-2016-6115).
IT20566 SECURITY: DB2 IS AFFECTED BY VULNERABILITIES IN COMPRESSION ROUTINES.
PH07115 “RSV-CM-0011 THE USER CAPABILITY CACHE SIGNATURE IS INVALID” IS RAISED INTERMITTENTLY WHEN RUNNING JOBS
PH08190 XQE-V5-0011 V5 SYNTAX ERROR WHEN CREATING DATA GROUP USING THE UI WHILE THE CONTENT LANGUAGE IS SET TO DANISH
PH06970 IN QUERY STUDIO CLICK ICON COLLABSE GROUP ON A CALCULATION DATE ITEM WHICH IS GROUPED: IDENTIFIER NOT FOUND
PH02533 CALCULATED FIELDS ON NON-NUMERIC COLUMNS CANNOT BE USED TO FILTER DASHBOARDS
PH03012 DRILL-THROUGH NOT WORKING WITHOUT READ-PERMISSION
PH08964 GERMAN USER APPLY A CLEAN FUNCTION ON A ITEM IN A DATA MODULE THEN THE FOLLOWING ERROR MESSAGE APPEARS: …
PI97741 WRONG PACKAGE WHEN ADDING QUERY IN MULTIPLE PACKAGE REPORT
PI96695 IN REPORT STUDIO, OPEN A REPORT IN EDIT MODE, THE CHANGES ON OPTION ARE NOT SAVED.
PH05767 ERROR SAVING REPORT AS REPORT VIEW
IT20562 SECURITY: DB2 CLP WILL TRAP IF IT IS PASSED A ROUTINE NAME GREATER THEN THE ALLOWED MAXIMUM LENGTH …
IT20563 SECURITY: BUFFER OVERFLOW THAT COULD ALLOW A LOCAL USER TO OVERWRITE DB2 FILES OR CAUSE A DENIAL OF SERVICE …
PH06761 ERROR: RMEMBEDDEDFILTER INCOMPATIBLE WHEN HAVING SECURITY TABLE FILTER FOR 2 RELATED REPORTS IN ONE DASHBOARD

Quickie: How to use the new macro function queryValue

A very pleasant surprise when building reports. There’s a new function called “queryValue”.

On the surface it looks fairly innocuous, but the result of this is a lot of effort saved when building reports. There are many times where I want a way of pulling a default value from a database in a filter. For example, my report might need to let the user select a year, but last date with data is unknown. Normally we can do something like:

[Sales (query)].[Time].[Year] = #prompt('Year','integer',
'maximum([Sales (query)].[Time].[Year] for report)'
)#

WITH 
"TQ0_q_SelectedMonth1" AS 
    (
    SELECT
        "GO_TIME_DIM"."CURRENT_YEAR" AS "Year0", 
        MAX("GO_TIME_DIM"."CURRENT_YEAR")
            OVER(
            ) AS "Max1"
    FROM
        "GOSALESDW"."gosalesdw"."GO_TIME_DIM" "GO_TIME_DIM"
    )
SELECT
    "TQ0_q_SelectedMonth1"."Year0" AS "Year0"
FROM
    "TQ0_q_SelectedMonth1" 
WHERE 
    "TQ0_q_SelectedMonth1"."Year0" = "TQ0_q_SelectedMonth1"."Max1" 
GROUP BY 
    "TQ0_q_SelectedMonth1"."Year0"

It works, but I don’t like it. It’s creating a window function, and actually hits every row in that table. One way around would be to create a parameter map in the framework model. Create a model query that has the value you want, add a data item with a static 1, and create a parameter map based on that. You could then do:
[Sales (query)].[Time].[Year] = #prompt('Year','integer',
sq($lastYearWithData{1})
)#

Then the SQL will look like:

SELECT
    "GO_TIME_DIM"."CURRENT_YEAR" AS "Year0"
FROM
    "GOSALESDW"."gosalesdw"."GO_TIME_DIM" "GO_TIME_DIM" 
WHERE 
    "GO_TIME_DIM"."CURRENT_YEAR" = 2013 
GROUP BY 
    "GO_TIME_DIM"."CURRENT_YEAR"

This is much better but still way too clunky. It requires access to the framework model, and a new parameter map for each and every scenario that we need. What if we want the last date of data for a specific product line? Or product?

Instead, let’s take a look at queryValue()

[Fact Business].[Dates].[Year] = #prompt('Year','integer'
, queryValue('maximum([Sales (query)].[Time].[Year])')
)#

This behaves exactly like the parameter map, and the SQL is identical. Cognos is actually making a query that runs maximum([Year]), and returns that value to the macro – exactly like a parameter map would. We can add filters to the query like this:
[Sales (query)].[Time].[Year] = #prompt('Year','integer',
queryValue('maximum([Sales (query)].[Time].[Year])','[Sales (query)].[Sales].[Quantity]>0 and [Sales (query)].[Products].[Product]=''Trail Star''')
)#

Notice using a double quote to escape the single quote. Great Outdoors stopped selling Trail Star in 2011, and 2011 is now the default value in the prompt.

This is also especially useful in Data Sets and Data Modules, where parameter maps simply don’t exist.

Extensions in Cognos Analytics

When compared to Cognos 10, Cognos 11 has a very different portal system. Called Glass, this extensions system allows a much greater flexibility in terms of adding additional buttons and menus. Pretty much every aspect of the portal can be modified, including the ellipsis menus. In addition to adding, we can also prevent users from seeing specific menu items.

1. Opening a webpage in an iFrame
2. Running a report or a dashboard
3. Opening a folder
4. Add a dashboard shape
5. Run a script
6. Adding a menu for any of the above actions
7. Hiding specific glass features or views

Let’s start with a basic extension – opening a website in an iFrame.

{
	"name":"incident_Reporter_iFrame",
  "comment":"Opens the incident reporter in Cognos.",
	"schemaVersion": "1.0",
	"extensions": [
	{
		"perspective": "common",
		"comment": "There is a special meta perspective called COMMON. Adding contributions to this perspective will cause the extension to be applied to All perspectives.",
		"features": [{
			"id": "incidentOpener",
			"toolItems": [
			{
				"comment": "This code will display a custom Website button that opens the specified URL in an iFrame.",
				"id": "ops.iframeOpener.incidents",
				"containerId": "com.ibm.bi.glass.navbarTrailingGroup",
				"label": "Incidents",
				"icon": "images/incidentReporter.png",
				"type": "Button",
				"weight": 100,
        "coachMark":{"title":"Incident Reporter","contents":"Use this link to open new incidents"},
				"actionController": "bi/glass/api/IFrameOpener",
				"options": {
					"url": "http://SERVER/incidentReporter.aspx",
					"title": "Incidents"
				}
			}
			]
		}]
	}]}

Let’s go through this.

Top level has name, schemaVersion, and contains the extensions array. In all places you can add a comment field.
Name should be descriptive so the next person working on this can figure this out. And then use the comment to explain what you’re doing!
Comments are just that, they’re ignored by Cognos and they’re a great place to defend your code.
The extension allows you to handle different perspectives in different ways. So you might want this to appear in one way in authoring, and another way when the user is in dashboards.

Inside extensions we start getting into how the extension appears on the page.
Perspective lets you apply this everywhere (“common”) or to a specific view (“home”, “authoring”, “dashboard”, or “modeller”).
Features defines the items in the extension.

And inside features…
id needs to be unique.
toolItems are the actual buttons and menu structure.

And inside the toolItems…
This is the place where we define what appears in the locations.
Each item needs a unique ID.
The container ID references various places in Cognos. It’s the parent of item you’re creating. The help documentation lists five placement options, but I’ll give you a hint. You can use developer toolbars to examine various elements in Cognos to see if you can put an item there:

You could also do what it says on the IBM article here, but that would be far too easy.

Label and Icon are self-explanatory.
Type can be menu, menuItem, or button. If you have a menuItem, you need to make sure the containerID is a menu. It doesn’t need to be a menu that you’ve created.
Weight determines the position of the item in the container, higher numbers making it have a higher position.
Push turns the button into a toggle.
coachMark is an object containing title and contents that creates those nice blue hint bubbles.
actionController tells Cognos what this button does. The one above opens an iFrame, but you could also use ReportOpener, DashboardOpener, FolderOpener. In my next example further down I’ll show how to run a custom controller.
Options give context to the action. In this case we want the iFrame to open incidentReporter.aspx on SERVER. If you point against an external website please note that not all websites allow themselves to be viewed in iFrames. Google for example just won’t work.

To use it you need to paste the JSON into a file called spec.json. The icon is looking for images/incidentReporter.png. Zip the spec.json and the images folder and you’re done!

Now when we upload it we see the incidents button under the Manage on the bottom left:

Now let’s do something a little more complex fun.

One of things that always bugged me about using Cognos in Chrome was the lack of clipboard access. While it’s true that you can now copy objects from report to report in C11.1, there are times when I want to modify the XML. Local classes, for example, have a very limited list of options. If I want to add something non-standard, like position:absolute, I’d have to open it in IE or copy the entire report XML.

We’re not going to get into the JS behind my Clipboard Editor, but we’ll go into the JSON of the object.

{
	"name":"CognosPaul_Bag_o_Tricks",
	"schemaVersion": "1.0",
	"extensions": [
	{
		"perspective": "authoring",
		"comment": "This is a collection of extensions aimed at easing the life of a developer.",
		"features": [{
			"id": "CognosPaul.BagOTricks",
			"toolItems": [
{
				"id":"custom.appbar.trailingGroup.trickMenu",
				"containerId": "com.ibm.bi.glass.appbarTrailingGroup",
				"type": "Menu",
				"label": "Custom Tools",
				"icon": "images/bag.png",
				"weight": 650
			},
			{
				"id": "custom.appbar.trailingGroup.menuItem2",
        "comment":"Clipboard editor will allow you to copy an object in Cognos and see the XML in a memo input. You can then edit it and paste back into Cognos.",
				"containerId" : "custom.appbar.trailingGroup.trickMenu",
				"comment": "The containerId is the ID of the parent menu.",
				"type": "MenuItem",
				"actionController": "v1/ext/CognosPaul_Bag_o_Tricks/js/controllers/ClipboardEditor",
				"comment": "action controller is looking at the js embedded in the zip.",
				"label": "Edit Clipboard",
				"icon": "images/clipboard.png",
				"weight":800
			}
			]
		}]
	}]}
  

In this case I’m creating a menu in the appbarTrailingGroup. It will appear in the upper right menu bar, next to the ellipsis menu.

The menu named “CognosPaul_Bag_o_Tricks”, and that same name will be used further down in the actionController. It contains one extension, which is only valid from the authoring perspective.

The extension itself contains a menu, and a single menu item. Notice the containerId for both items. The only major difference between this and the iFrame viewer is the actionController. Notice the call is without js, and uses the name of the object: “v1/ext/EXTENSIONNAME/folderstructure/JSFILENAMEWITHOUTTHEJSEXTENSION”.

I personally find the clipboard editor incredibly useful, but because I’m using undocumented functions in Cognos I can’t guarantee that it will work for all future versions. Copying from one report to another is possible with this, but you have to initialize the report clipboard by copying something.

iFrames.zip (236 downloads)
Clipboard Editor (229 downloads)

And finally, on a personal note, I’m a sucker for free high-fives. Thanks GoTeamJosh!