As I mentioned in the previous post. I cannot guarantee the accuracy of this list. There may be some fixes I’ve missed, and some fixes listed here that were really fixed in a different version. A big shout out to Naveen Shivayogi for finding a quick way of identifying the specific fixes.

PI93791	DIVIDE BY ZERO AND DIVIDE BY NULL CALCULATIONS CAUSES QUERY SERVICE INTERNAL ERRORS IN DASHBOARD
PH03086	DRILL THROUGH TO SAVED EXCEL OUTPUT CANNOT OPEN EXCEL PROGRAM FROM NON-INTERACTIVE VIEWER
PI98665	INCONSISTENT BEHAVIOUR IN DISPLAYING ACTIVITIES UNDER MANAGE ACTIVITIES FOR SCHEDULES AND SUBSCRIPTIONS VIEW
PI96075	TOOLTOPS INSIDE A VISUALIZATION DO NOT PICK UP “SPECIFIED TEXT”AND CHANGES THE LANGUAGE AUTOMATICALLY
PI98249	DRILL THROUGH TO TARGET IN XLS, CSV FROM NON-INTERACTIVE SOURCEDOES NOT CLOSE THE TARGET WINDOW
PI98675	DELAY OF EXACTLY 60 SECONDS IN SENDING EMAILS OUT OF COGNOS
PI96366	DASHBOARDS DO NOT WORK WITH AN ORACLE FUNCTION
PI97826	WHEN RUNNING IN SLOVENIAN CONTENT AND PRODUCT LANGUAGE. MONTHS IN DATE PROMPT ALL HAVE FULL STOPS EXCEPT FOR …
PI95050	PROMPT PAGES FOR BACKGROUND REPORTS DO NOT SCALE TO THE PROMPT DIALOG SIZE IN INTERNET EXPLORER, BUT DO IN …
PI94411	RUNNING ACTIVE REPORT INTERACTIVELY IMAGES IN LIST OR CROSSTAB WHICH ARE RETURNED FROM CASE STATEMENT ARE …
PI99063	LOCALIZED CUBE AND DIMENSION NAMES NOT REFLECTED IN PACKAGE
PI96626	CUSTOMURLS THAT CALL ACTIVE REPORTS WILL OPEN A PAGE WITH PERSPECTIVE HOME AND THEN CREATE AN ADDITIONAL TAB …
PI96962	DRILL THROUGH TARGET REPORT DOES NOT SHOW THE CORRECT FILTER VALUES
PI95219	SHORTCUT NAME IS NOT REFLECTED IN METADATA TREE WITH DATA MODULE
PI99072	VIEWING REPORT AS ACCESSIBLE PDF OR EXCEL 2007 THROWS 404 ERROR WHEN TEMPORARY OBJECT LOCATION SET TO SERVER …
PI94380	CREATING A NEW DATA MODULE AGAINST TERADATA DOES A FULL TABLE SCAN ON THE GRID RESULTS. THIS SHOULD BE …
PI98110	TEXT BOX PROMPT DISPLAYED DIFFERENTLY IN INTERNET EXPLORER THAN FIREFOX AND CHROME BROWSERS
PI94971	CA 11.0.7 NOT PASSING THE FULL NETWORK PRINTER NAME TO ADOBE READER
PI98694	TM1 SECURITY CUBE MEMBER_UNIQUE_NAME
PI95652	CLICK REFRESH OR RELOAD WEB BROWSER PAGE LOSES THE SETTINGS FOR A DASHBOARD OR REPORT WITH APPBAR OR NAVBAR …
PI99319	R9+ NON-ADMIN USER TRIGGERS AGENT SERVICE CNC-ASV-0001 ERROR
PI94939	REPORT VALIDATION DOES NOT UPDATE USAGE PROPERTY IN REPORT SPECIFICATION
PI99391	WHEN YOU RUN A REPORT AND PROVIDE THE PROMPT VALUES IN THE URL AND IF THE VALUE HAS A LEADING ZERO, IT WILL BE …
PI98886	DUMMY QUERIES BEING FIRED FROM COGNOS ANALYTICS WHEN USING STORED PROCEDURES.
PI97490	GOING BACK FROM THE TARGET REPORT TO THE SOURCE REPORT WITH A HTML CODE WINDOW.HISTORY.GO THEN THE PROMPT PAGE …
PI89873	LEGACY CHART, WITH A VERY SMALL NUMBER AND FORMAT WITH 0 DECIMALPLACES, RECEIVE CGSERRORASSERT:0:FATAL: ERROR
PH00093	[DQM] XQE-GEN-0018 ERROR WHEN FRAMEWORK MANAGER PROMPT MACRO IS USED AS FILTER
PI98088	DASHBOARD THROWS AND EXCEPTION ‘QUERY SERVICE ERROR HAVE OCCURRED, PLEASE SEE THE LOG FOR DETAILS’
PI99426	IMPROVEMENT OF HOME PAGE RENDERING TIME REQUIRED
PI98320	PROMPTED FOR DATA SOURCE CREDENTIALS IN TRANSFORMER 11, CREATINGA CUBE WITH SOURCE TYPE AS DQM REPORT
PI99427	ADJUST COMMUNICATION WORKFLOW SO NO 404 OR OTHER CUSTOM HTTP CODES ARE USED
PI97024	REPORT DEFINED AS HOME PAGE CHANGES WHEN IT CONTAINS A DRILL-THROUGH
PH00086	LIST PAGE HEADER PADDING RENDERING ISSUE IN PDF WHEN USING A REPORT CONTAINING REPEATER
PI99240	UNABLE TO LOCATE DATA SETS WHEN CREATING A DATA MODULE IF A LARGE NUMBER OF EXISTING DATA SETS RETURNED IN THE …
PI99681	PROMPT PAGE NOT APPEARING IN PDF BUT APPEARS IN HTML
PI98454	FILTER CONDITION DIALOG SEARCH IS UNPREDICTABLE
PI95125	URL WITH FORMAT=CSV ALLOWS USER WITHOUT GENERATE CSV OUTPUT CAPABILITY TO VIEW REPORT IN CSV FORMAT
PI98299	WILD CARD (%) IN SEARCH RETURNS NO VALUES WHEN USING A DATA MODULE AS THE SOURCE.
PH00228	DATE RANGE FILTERS NOT APPLYING CORRECT RANGE TO DATA OUTPUT.
PI98347	PERFORMANCE ISSUES OBSERVED WHEN MORE NUMBER OF SCENES ARE ADDEDTO STORY.
PH02472	“CUT” GROUPED COLUMN REMOVES DATA ITEM. “CUT” ANY OTHER COLUMN AND DATA ITEM REMAINS
PI99305	SLOW LOADING METADATA TREE IN COGNOS ANALYTICS WHEN ALL MEMBERS OF HIERARCHY AT ROOT LEVEL OF HIERARCHY
PH00462	ERROR IN DB2 SCRIPT FOR COGNOS ON ZOS
PI99631	KOREAN CHARACTERS GET CORRUPTED IN FRAMEWORK MANAGER 11.0.11
PH00529	WHEN REPORT PROPERTY FULL INTERACTIVE = NO THEN SCHEDULE PROMPT VALUES RESETTING TO DEFAULT WHEN YOU CLICK EDIT
PI99579	BLANK SCREENS WHEN RUNNING REPORTS
PI95267	TM1 CUBE WITH OUT A MEASURE FOR REPORTING THROWING AN INCORRECT ERROR MESSAGE IN THE UI BUT CORRECT MESSAGE IN …
PI99346	DRILL-THRU NOT PASSING CORRECT VALUES AS SHOWN BY PARAMDISPLAYVALUE IN TARGET
PH00015	UNABLE TO CREATE DATA MODULE USING PA DATA SOURCE CONNECTION.
PH00122	DISPLAY VALUE NOT DEFAULTING TO USE VALUE AS IN PAST VERSIONS
PH00243	SYSTEM.XML PARAMETER HIDEINACCESSIBLETABS NOT APPLICABLE TO R11+PORTAL TABS
PI95400	DUPLICATE FOLDERS IN NAVIGATION
PH00491	REPORTS FAILING WITH XQE-GEN-0010 ERRORS
PI95569	DATE PROMPT SHOWS UNWANTED KOREAN CHARACTERS ”
PH00055	BI REPORTS USING TM1 DATA INTERMITTENTLY RETURN NO DATA ON STRING MEASURES
PI99737	DEFAULT MEMBER NOT FOUND WITH CURRENTMEMBER FUNCTION
PH00798	ROUTING RULES DO NOT WORK WHEN RUNNING REPORTS IN BACKGROUND
PI97765	CAMNAMESPACE URL PARAMETER GIVES ERROR “AAA-AUT-0011 INVALID NAMESPACE WAS SELECTED”
PH00205	OPENING MIGRATED REPORTS IN EDIT MODE WILL CAUSE A TYPEERROR IN 11.0.10
PI94196	IN FRAMEWORK MANAGER , VERIFY MODEL DOESN’T DETECT DELETED COLUMNS
PH00831	CHARTS VISUALIZATION DOESN’T SHOW PALETTE COLOUR IN SIDE BAR MENU
PH00389	SELECTION MADE IN MULTI-SELECT SEARCH/SELECT PROMPT DISAPPEARS IF VALUESARE SEARCHED FOR IN ANOTHER SELECT AND …
PI99399	EDITING DASHBOARD FILTER DIALOG DISAPPEARS AFTER TYPING IN SEARCH FIELD
PI99153	ANALYSIS STUDIO REPORT IS LOADED BEHIND THE COGNOS ANALYTICS WELCOME PAGE
PH00773	URLS TO OTHER REPORTS IN HTML OBJECTS FAIL WHEN RUNNING FROM SAVED HTML OUTPUT WITH RELATIVE PATH IN URL
PH03254	THE OPTIONAL TEXTBOOK PROMPT WHEN SUBMITTED BLANK FILTERS OUT THE ENTIRE DATA IN A REPORT
PI93897	PERSISTENT CROSS SITE SCRIPTING (XSS) ISSUE IN COGNOS 10.2.2
PI97550	DB2 DATE SHOWN AS TIMESTAMP IN FILTER
PH01367	AFTER A COGNOS ANALYTICS TIME OUT LOGON PROMPT IS EMPTY
PH02984	THE OPTION “DELETE UNREFERENCED QUERY OBJECTS” DOES NOT STAY UNCHECKED WHEN A REPORT IS REOPENED.
PI98257	CA 11.0.9 REPORTING SLOWDOWN AGAINST PA 2.0.4 VS PA 2.0.2
PH02400	HEADER IS REMOVED WHEN CUTTING A COLUMN FROM LIST REPORT WHEN AUTO GROUP AND SUMMARY FOR LISTS IS ENABLED
PI98291	RUNNING COUNT ERROR IN COGNOS ANALYTICS 11.0.11
PH00302	FAILED LOGON AGAINST SAP NAMESPACE RESULTS IN CAM-AAA-0126 WHICHCAN ONLY BE ESCAPED VIA BROWSER REFRESH
PI95865	CA RFE DASHBOARD PREVENT SELECTION OF DATA SOURCE CONNECTION IFMULTIPLE EXISTS.
PH00419	OK BUTTON CAUSES THE REPORT TO RELOAD INSTEAD OF CLOSING
PI97942	RUNNING REPORT WITH PROMPT FROM INTERACTIVE HTML OUTPUT IN EXCELSHOWS THE PROMPT, RUNNING IN PDF DOES NOT SHOW …
PH00379	PROMPT VALUE WITH ZERO AT BEGINNING IGNORED
PH01605	DB2 ON Z/OS ALIAS DOES NOT IMPORT
PH00251	WHEN CUTTING A LIST COLUMN IN A LIST REPORT ALSO THE OVERALL HEADER IS DELETED FROM THE LIST
PI97209	UNNECESSARY DIALOG WHEN CLOSING REPORT WITH INTERACTIVITY AS A CONSUMER USER.
PH00307	COGNOS ANALYTICS SAP NAMESPACE PROVIDER YIELDS LESS CONTENT THENTHE COGNOS 10 PROVIDER
PH01788	REPORT LINK TO SOURCE PACKAGE GETS BROKEN AFTER SOURCE PACKAGE IS OVERWRITTEN
PH00337	AUTOMATING CLEARING THE QUERY CACHE USING QUERYSERVICEADMINTASK.BAT’ SCRIPT IS NOT WORKING
PH01898	TYPEERROR POPUP WHEN SEARCHING IN 2 MULTI-SELECT SEARCH & SELECTPROMPTS AND MANY VALUES ARE SELECTED IN THE …
PI99655	CHANGING LANGUAGE IN IE RESULTS IN ANS-MES-1005 ERROR.
PI91372	REPORT RETURNS XQE-V5-0005 OR QE-DEF-0359 ERROR WHEN PROMPT IS PREDEFINED
PI99407	RESOLUTION SET 1280X720 THEN MY SCHEDULES AND SUBSCRIPTION LIST IS EMPTY BUT WHEN YOU ZOOM OUT LIST GETS …
PH01791	REPORT VIEW LINK TO SOURCE REPORT GETS BROKEN AFTER SOURCE REPORT IS OVERWRITTEN
PI99050	XQE-V5-0005 error occurs on Framework Manager with some localized characters
PH01328	CODE INJECTION VULNERABILITY IN CA 11.0.11
PH00417	XQE-MDX-0001 (LOCAL MDX EXECUTION FAILED) AFTER UPGRADE TO R11.
PH01589	ERROR WHEN ADDING NAMESPACE TO PERMISSIONS LIST: ITEM HAS ALREADY BEEN ADDED TO THE PROFILE
PH00490	REPORTS FAILING WITH XQE-GEN-0002 ERRORS
PH02105	FIND IN FILTER FOR SPECIFIC VALUES SHOWS ITEMS NOT MATCHING THE THE SEARCH VALUE
PI99553	LARGE CASE/WHEN IN REPORT CAUSES VERY LONG TIME FOR VALIDATION.
PI93727	SAP BW: DRILL THROUGH VALUES NOT PASSED TO SAP VARIABLES USING DQM
PH01164	TWO SEARCH AND SELECT PROMPTS ON THE SAME PROMPT PAGE CAUSING ANERROR
PH01884	RUN A PROMPT REPORT WITH FULL INTERACTIVITY NO IN BACKGROUND WITH I.E. 11 WEB BROWSER. PROMPT PAGE IS LEFT …
PH00969	MAP IN REPORT STUDIO DOES NOT DISPLAY VALUE WHEN HOVER OVER POINT
PH02118	AGENT VIEWS DO NOT HAVE AN AGENT TAB ON THE AGENT VIEWS PROPERTIES AFTER R10
PH01494	REPORT UPGRADED TO COGNOS ANALYTICS GETS ERROR XQE-GEN-0010 XDATACONTEXT WAS LEAKED FROM RSAPIRESULTSET
PH03422	TEXT BOX PROMPT IS SHIFTED TO THE FAR LEFT OF THE PROMPT PAGE WHEN THE REPORT IS RUN AS HTML IN BACKGROUND
PH01397	CAN SELECT EXTERNAL NAMESPACE NAME IN DATA SERVER CONNECTIONS IF NAMES IS TWO WORD WITH SPACE IN BETWEEN.
PH03660	FIREFOX HANGS DRILL THROUGH
PI98121	BLANK PAGE SHOWS FOR PARENT REPORT AFTER DRILL THROUGH FROM PDF TO PDF CHILD WITH INTERACTIVITY SET TO YES
PH02390	CM-SYS-5157 STARTING CONFIGURATION WITH GENERIC OPENID CONNECT NAMEPSACE WITH LOCAL CERTIFICATE FOR TOKEN …
PI98472	STRING MEASURE DATA DOES NOT WORK CORRECTLY WITH PLANNING ANALYTICS CONNECTOR.
PI94938	CUSTOM CONTROL/ PROMPT API THROWS ERROR WHEN REFERENCED AS LAYOUT COMPONENT REFERENCE
PI98202	REPORT UPGRADED FROM COGNOS BI 10.2.2 TO COGNOS ANALYTICS 11 TAKES LONGER TO OPEN 1ST PROMPT PAGE
PI97134	ERROR RSV-SRV-0126 0042 WHEN CREATING A CUSTOM FILTER THAT WILL RETURN BACK TOO MANY STRING VALUES
PI98221	SAP BW HIERARCHY RELATED VARIABLES ARE NOT PROPERLY HANDLED
PI97873	MASTER-DETAIL REPORT WITH MULTI-SELECT FILTER IS FILTERED ON INCORRECT VALUES WHEN SINGLETON ADDED TO THE PAGE
PI98270	MODIFY CODE GENERATION TO BE MORE SAFE TO PROPERLY HANDLE EMPTY LISTS
PI86820	LINEAGE FUNCTION SHOWS ERROR WHEN THE QUERY IN THE REPORT HAS A UNION JOIN:MSR-API-0002
PI97548	CROSSTAB REPORT DOES NOT DISPLAY ALL COLUMNS AFTER MIGRATIING FROM 10.2.2 TO 11.0.9
PI87074	Printer not working after upgrade
PH03865	ERRORS WHEN EXECUTING DRILL THROUGH REPORT BASED ON PLANNING ANALYTICS CUBE: XQE-GEN-0002, NULLPOINTEREXCEPTION
PH02893	WSDL NOT RETURNING FROM HTTP:///IBMCOGNOS/BI/V1/DISP/RDS/AUTH/WSDL
PH01162	POWERPLAY REPORTS ARE OPENED AS PDF INSTEAD OF OPENING IN POWERPLAY STUDIO WHEN CLICKING ON THE REPORT IN THE …
PI88200	REPORT FAILS TO RUN WITH ERROR XQE-GEN-0005 FOUND AN INTERNAL ERROR: JAVA.LANG.NULLPOINTEREXCEPTION
PH02043	FILTER SEARCH THROWS JAVA EXCEPTION ERROR WHEN SCROLLING THROUGHVALUES
PI90150	SELECTING VALUE FOR MISSING VALUES OPTION IN QUERY STUDIO FILTERRETURNS AN ERROR RSV-SRV-0003
PI64599	ORA-12704: CHARACTER SET MISMATCH
PI97968	DASHBOARD FILTER SEARCH LIST NOT RETURNING EXPECTED RESULTS
PH00252	THE “MORE”-OPTION IS NOT DISPLAYED IN THE TREE PROMPTS – WHEN RUN WITH FULL INTERACTIVITY.
PI95967	SCHEDULED REPORTS SAVING TO FILE SYSTEM ARE ALL FAILING WITH ERROR MESSAGE
PH02102	UPGRADED REPORT BREAKS FORMAT WHEN REMOVING A COLUMN
PH02119	R12 – AGENTS RUN WITH NON ADMIN USER RESULT IN AGENT SERVICE GENERAL ERROR OCCURRED [JAVA.LANG….
PI85117	ALPHABETICAL ORDER OF DATA ITEMS IN FM FOR DQM PACKAGE IN IMPORTVIEW AFFECTING DASHBOARD FILTER BEHAVIOR AND …
PH02544	CANNOT READ PROPERTY ‘SELECTSINGLENODE’ OF NULL AT MESSAGE IS DISPLAYED IN CUSTOM FILTER ON NON MEASURE
PI87063	AUTHORING THE REPORT WITH INVALID FILTER EXPRESSION AFTER EDITING THE PAGE, IT CANNOT CLICK OKAY BUTTON TO …
PI87712	PERFORMANCE ISSUE IN REPORT STUDIO WHEN LOADING A LARGE DQM PACKAGE.
PH02756	XQE PINS CPU AT 100% FOR HOURS
PI87771	OPTIONS SETTINGS IN MORE MENU IN REPORTING TOOL SOMETIMES RESET TO DEFAULT.
PI87183	REPORT DESCRIPTION PROPERTY ISN’T SCROLLABLE BY A USER PART OF CONSUMER ROLE ONLY.
PI88086	UNABLE TO VIEW RUN HISTORY FOR EVENT STUDIO AGENTS
PI88665	WHEN YOU EXECUTE A REPORT AGAINST POSTGRESQL (JDBC),
PI89906	ERROR RUNNING A REPORT WHICH WAS CONVERTED FROM COMPATIBLE QUERYMODE TO DYNAMIC QUERY MODE: XQE-PLN-0248
PI87576	IN COGNOS WORKSPACE, THE GLOBAL AREA FILTERS DOES NOT DISPLAY THE LATEST VALUES IN FILTER WHEN CHANGING THE …
PI92314	DIFFERENT JOIN AFTER UPGRADE TO 10.2.2 FP8 IN DQM
PI96630	IFRAME DOES NOT LOAD REPORTS WITH FULL INTERACTIVITY SET TO YES

IBM has decided to stop publishing the fix lists with each new release. This has, needless to say, infuriated quite a few users. So, as a public service, I will post them here. Since I am NOT IBM, I cannot guarantee that what I have here is complete, or even correct. So here is the fix list for 11.0.12. (the list 11.0.13 will be published shortly).

PI99226	UNABLE TO SELECT PROMPT VALUES USING MULTIPLE SEARCH AND SELECT PROMPTS ON A PROMPT PAGE IN A REPORT
PH04098	“RUN THE SCHEDULE/SUBSCRIPTION ONCE” FEATURE MISSING IN “MY SCHEDULES AND SUBSCRIPTIONS” ON VERSION 11.0.10
PI94751	EDIT PROMPT VALUES FAILS FOR SCHEDULES OR REPORT VIEWS WHEN OPTIONAL PROMPT VALUE IS NOT SET
PI97917	REMOVING A FILTER IN DASHBOARD REMOVES ALL THE SUBSEQUENT FILTERS AS WELL
PI94017	JOB WITH REPORT AS A HTML ATTACHMENT IS DIFFERENT BETWEEN IE/CHROME
PI97773	CAM-CRP-1193 ERROR WHEN SAVING CONFIGURATION ON REMOTE INSTALLS WHEN WLP LTPA AUTHENTICATION IS ENABLED
PI95162	[UPGRADE] REPORT SQL GIVES ERROR ORA-00942: TABLE OR VIEW DOES NOT EXIST
PI94458	IMAGES IN A CONDITIONAL PALLETE IN A BUBBLE CHART WILL CAUSE ANRSV-SRV-0040 ERROR RESULTING IN A FAILED REPORT
PI95905	IT APPEARS THAT THE OPTION TO ‘PROMPT’ FOR CREDENTIALS WILL SIMPLY BE IGNORED AND A BLANK USERNAME/PASSWORD IS …
PI94697	XQE-GEN-0010 ERROR OCCURS IN REPORT EXECUTION WITH PLANNING ANALYTICS (TM1) DATASOURCE.
PI96198	DOUBLE-CLICKING ON A QUERY ITEM WITHIN THE INSERTABLE OBJECTS PANE IN EVENT STUDIO IS NOT WORKING ON IE 11
PI95122	SETTING REPORT FORMAT OPTION TO CSV ALLOWS USER WITHOUT GENERATECSV OUTPUT TO VIEW REPORT IN CSV FORMAT
PI95649	MY PARAMETERS WILL NOT APPLY TO THE REPORT WHEN THE REPORT HAS MORE THEN ONE PROMPT
PI95300	REPORT AGAINST A MODEL WITH ALIAS SHORTCUTS ACCESSING A RELATIONAL DQM DATASOURCE FAILS WITH XQE-GEN-0005
PI95880	NO MORE SPACE IN PROMPT VALUE IN FULLY INTERACTIVE MODE
PI96091	SCALE OF DECIMALS IGNORED IN DATA MODULES WITH ORACLE 11
PI98645	HTML ITEM ERROR WHEN TRYING TO SET PROMPT VALUES TO SCHEDULE A REPORT
PI96031	ERROR IMPORTING REPORT WITH NESTED REPEATER INTO WORD WITH COGNOS FOR MICROSOFT OFFICE
PI97984	CANNOT PIN LINE GRAPH IN DASHBOARD WITH REPEATER COLUMN
PI95896	EXPANDING METADATA TREE IN EVENT STUDIO USING IE11 RENDERS SCROLLBAR FOR ENTIRE PAGE INSTEAD OF FOR THE …
PI97023	AN ERROR OCCURRED DURING THE DEFINITION OF DRILL-THROUGH
PI95304	DATA SOURCE CONNECTION AND SIGNON SELECTION PROMPT LOOPS IN REPORT AUTHORING TOOL
PI99018	INDEX CREATION DOES NOT WORK AS EXPECTED
PI93487	DATE STRING CALCULATION RETURNING DATA IN DIFFERENT FORMAT IN 11.0.9 COMPARED TO 11.0.7
PI97727	XQE-GEN-0010 FOUND AN INTERNAL ERROR: ‘NO CUBES USED IN CONTEXT.’. WHEN SHARED MEMBER CACHE IS USED IN …
PI96561	PROMPT MACRO SLICER AGAINST POWERCUBE IGNORED IN EXCEL OUTPUT.
PI93934	UPGRADED REPORT FAILING TO RUN
PI93724	USING CZECH MAP SHOWS MISMATCHES IN ADMINISTRATIVE BOUNDARIES
PI98077	DASHBOARD CHARTS LEGENDS CHANGING BACK TO RIGHT ALIGNED
PI98471	ENABLING METRIC DUMP FOR ONE DISPATCHER ENABLES METRIC DUMP FOR ALL DISPATCHERS
PI96977	DRILL THROUGH ON SOURCE REPORT WITH SAVED HTML OUTPUT DISPLAYS HTML TARGET REPORT BUT WITH NO OPTION TO VIEW …
PI98740	NEW ITEMS CREATED IN COGNOS ANALYTICS CANNOT BE FOUND IN SEARCH UNTIL AFTER A RESTART OF THE CONTENT MANAGER …
PI94799	11.0.9 CREATING A NEW DATAMODULE RESULTS IN APPVIEW ERROR: FAILURE SHOWING THE CONTENT VIEW IN IE
PI98292	BI/TM1 REPORT DOES NOT PERFORM AS EXPECTED AFTER UPGRADE FROM 10.2.1 TO CA 11
PI97233	XQE-V5-0011 SYNTAX ERROR WHEN USING A MEASURE FROM A MEASURE DIMENSION THAT HAS A MACRO EXPRESSION REFERENCING …
PI97478	GLOBAL PARAMETERS IMPORTED FROM A REPORT THAT USES ADVANCED ROUTING INTERMITTENTLY DO NOT DISPLAY
PI96752	FUNCTIONALITY TO POINT AN EVENT STUDIO AGENT TO A NEW PACKAGE, NO LONGER EXISTS IN COGNOS ANALYTICS. EXISTED …
PI94911	WITHOUT READ PERMISSION CONSUMER USER IS NOT ABLE TO RUN REPORT ON A PACKAGE
PI96577	GET ERROR MESSAGE:XQE-GEN-0002 AN UNEXPECTED EXCEPTION OCCURRED RSV-SRV-0042 TRACE BACK
PI95760	AN RSV-BBP-0028 ERROR OCCURS WHEN “RUN WITH INTERACTIVITY” IS SET TO NO WHEN USING RUN AS TO EXCEL AND THEN …
PI96787	VALUE OF MEMBER DESCRIPTION CHANGED BETWEEN TM1 AND PLANNING ANALYTICS CONNECTION TYPE
PI98108	DISPLAY LEGEND CHECKBOX NOT WORKING IN DASHBOARD
PI98230	FRENCH REGIONS NOT RECOGNIED IN CAR11 WITH MAPBOX
PI95471	MANAGE -> ACTIVITES DOES NOT SHOW SCHEDULES OR PAST ACTIVITIES WHEN THERE IS A LARGE NUMBER OF SCHEDULES
PI98476	SHOWPROMPTOVERLAY FUNCTION CALL ON “EDIT” SAVED SELECTIONS FORCES FULLY INTERACTIVE MODE
PI98016	READ ACCESS SHOULD NOT BE REQUIRED ON THE BASE REPORT TO CREATE A REPORT VIEW
PI98313	TEXT IN DASHBOARD BEING REMOVED ON DEPLOYMENT
PI96789	UNABLE TO INSERT VALUES TO A FILTER BY PASTING THEM IN IN THE FILTER FOR REPORT DIALOG.
PI96902	UNABLE TO DRILL DOWN ON & AMPERSAND CHARACTERS USING MICROSOFT ANALYSIS SERVICES (MSAS) CUBE DATASOURCE
PI93560	ERROR IN DASHBOARD “DATASOURCE WAS NOT FOUND IN CONTENT MANAGER”WHEN USING MACRO FOR DATASOURCE IN FRAMEWORK …
PI96437	REPORT VIEW NOT HYPERLINKED IN “RECENT” REPORT MENU
PI96761	AFTER UPGRADING TO 11 XQE-PLN-0248 THE COLUMN OF UNION COULD NOTBE FOUND IN THE MODEL.
PI97650	RUNNING A PROMPT API BASED REPORT IN BACKGROUND YIELDS: HTML REPORT OUTPUT IS NOT WELL FORMED.
PI97071	LEADING AND TRAILING ZEROS ARE CUT FROM PARAMETERS USED IN CUSTOMURLS TO CALL REPORTS
PI59126	ERRORS CRP-OPF-2003 CRP-REP-1005 CRS-REP-1008 CRP-OPF-2016 REP-API-1001 INSTEAD OF LOGON PROMPT
PI96832	OIDC HANGS
PI80715	PROMPT USING PROMPTMANY DOES NOT SHOWN WHEN EXECUTE VALIDATION IN REPORT STUDIO.
PI96281	INCORRECT CHARTS RENDERED WHEN VIEWED IN IOS EMAIL APPLICATION.
PI95573	THE STATIC CHOICE IS NOT APPEARING ANYMORE WITH “SELECT AND SEARCH PROMPT”
PI97430	REPORT WITH LOOP FAILS WITH QE-DEF-0481 THE EXPRESSION ‘[ITEM1]–>[ITEM2]–>[ITEM1]’ HAS A LOOP IN QUERY STUDIO
PI97585	USER CAN OPEN FILE EXPLORE USING LINK (FILE:\\[NETWORK ADDRESS])AND GET “CANNOT OPEN URL” AND FILE EXPLORE AT …
PI93947	QUERY SERVICE INTERNAL ERROR – WHEN ADDING TWO MEASURES WHEN THERE IS NO COMMON DIMENSIONAL VALUES WHEN IN …
PI95015	WITH MODEL PROMPT MACRO FILTER ON A DMR MEMBER THROWS AN ERROR IN REPORT STUDIO WHEN EXPANDING THE MEMBERS
PI98264	XQE-DAT-0001 ERROR DRILLING THROUGH FROM A PROMPTED TABBED REPORT.
PI97191	UNABLE TO SET UP SECURITY FILTERS FOR DATA MODULES
PI97999	FRAMEWORK MANAGER FACT DIMENSION CALCULATION WITH MINUTE KEYWORDNOT WORKING IN DASHBOARD
PI97114	UNABLE TO CREATE DASHBOARD WHEN MODEL DATASOURCE USES PARAMETER MAP AND SESSION PARAMETER TO SELECT DATASOURCE
PI99027	LAUNCH INSTRUCTION INCORRECT IN QUERY STUDIO GUIDE IN COGNOS ANALYTICS
PI87614	CONFIGURING SAP NAMESPACE ON COGNOS ANALYTICS 11.0.6 FAILED IF SAP SYS NUMBER GREATER THAN 1 DIGIT
PI98430	EXTERNAL DATA AND XSLX FORMAT
PI86345	XQE-V5-0003 ELEMENT ‘XMLATTRIBUTES’ WAS NOT PROCESSED AS IT IS NOT SUPPORTED BY ‘QUERY’.
PI97149	ANALYSIS STUDIO DPR-ERR-2079 FIREWALL SECURITY REJECTION.
PI90084	PROMPT FILTER DOES NOT AFFECT 11.0.7 PDF EXCEL REPORT OUTPUT
PI95176	COGNOS REPORTING DOES NOT SHOW THE CHILD MEMBERS, WHEN USING ‘MEMBER INSERT OPTION’ > ‘INSERT MEMBER WITH …
PI90057	REPORT FAILS WITH ORA-00932: INCONSISTENT DATATYPES: EXPECTED NUMBER GOT LONG
PI93109	BAD REQUEST (HTTP 400) ON REPORT VIEW AND CHROME
PI98567	POWERPLAY REPORT WITH RUN AS INTERACTIVELY, IT WILL SHOW NO BACKGROUND AND FONT COLOR IN PDF WITH MISSING FACT …
PH01599	EXCESSIVE HISTORY OBJECTS GETTING INDEXED CAUSING FAILURE OF INDEX TASK
PI98040	‘LEARNING CENTER’ LINK IN ‘HELP’ DROP DOWN MENU UNAFFECTED BY LANGUAGE PREFERENCE CHANGES
PI96296	OUT OF MEMORY SITUATIONS FOR DYNAMIC CUBE WITH SUPPRESS ZERO IN ANALYSIS STUDIO
PI91353	REPORTS USING CUBE DATA SOURCE ARE FAILING AFTER R8 UPGRADE OVERTOP
PI74372	SMALLER CHARTS WITH SHOW VALUES SET TO FINE STAGGER HAVE VALUES IN THE WRONG ORDER
PI93614	WHEN USER CLICK THE DRILL THROUGH LINK IN REPORT THEN TWO LINKS APPEARS. THE SPACE BETWEEN THE TWO LINKS ARE …
PI93240	RUNNING A QUERY VIA TABULAR DATA RETURNS DPR-ERR-2056 IN 64 BIT EXECUTION MODE
PI94948	UNEXPECTED BEHAVIOR WHEN EXPORT TO CSV USING DRILL THROUGH
PI95930	DASHBOARDS ARE BLANK(NO DATA ONLY HEADINGS) WHEN VIEWED IN FULL SCREEN USING EMBEDDED LINK IN CA 11.10
PI96497	ERROR PRS-INS-1425 RUNNING A STORED PROC IN EVENT STUDIO
PI96651	REPORT WHICH DRILLS TO ITSELF IN EXCEL FORMAT THROWS AN ERROR _07B IS NOT A CONSTRUCTOR.
PI96712	AFTER ACCESSING R10 CA WITH FM R10 WILL BREAK ANY EXISTING COGNOS 10.X.X FRAMEWORK MANAGER THAT EXISTS ON THE …
PI84559	AGENT VIEWS FAIL WHEN THEY ARE RE-IMPORTED FROM ANOTHER ENVIRONMENT
PI96742	[UPGRADE] QUERY STUDIO TIMESTAMP PROMPT BECOMES TYPE-IN PROMPT
PI94907	PROMPT TYPE IN FRAMEWORK MANAGER : SELECT WITH SEARCH DOESN’T RETURN RESULTS AFTER APPLYING CUSTOM FILTER
PI80499	NO OBJECT FOUND
PI83185	XQE-GEN-0005 DMRMEMBERPROXY INCOMPATIBLE WITH MEMBER
PI97122	DELIVERY LINK FROM “UPDATE SCHEDULE” UNDER “MY SCHEDULES AND SUBSCRIPTIONS” DOES NOT WORK
PI96893	FACTORYMODE=TRUE DOES NOT UNLOAD EXTENSIONS ONLY THEMES
PI98548	DELETING INDICES FOLDER 11.0.11 CAUSES SEARCH TO STOP WORKING AFTER EACH SERVER RESTART
PI96299	REFERER HEADER WHEN RUNNING A REPORT VIEW IN CHROME IS HUGE COMPARED TO RUNNING IN INTERNET EXPLORER
PI87002	UPGRADED REPORT CONTAINING SEARCH AND SELECT PROMPT BASED ON A NESTED QUERY WITH CONCATENATED FIELDS THROWS …
PI87603	NOT ABLE TO CONFIGURE SAP NAMESPACE WITH R6
PI89595	SQL SERVER SYNONYMS NOT VISIBLE IN DATA MODULE .
PI79628	PROMPT VALUES IN “MY SUBSCRIPTIONS” RETURN TO THEIR “NULL VALUE”WHEN EDITED
PI85592	OBJECT SECURITY IN FRAMEWORK MANAGER IS NOT APPLIED IN REPORT
PI90553	FILTERING BLANK VALUES USING A PROMPT ON COGNOS WORKSPACE ADVANCED RESULTS IN AN UNEXPECTED RESULT.
PI91327	AFTER DRILL THROUGH FROM PDF TO NEW WINDOW THE PDF VIEW TAB REFRESHES AND APPEARS BLANK
PI92448	DRILL UP/DOWN ON TIME DIMENSION IN DASHBOARD VISUALIZATION INCORRECT IF COLOR PROPERTY IS SET
PI92685	UNABLE TO VALIDATE AND USE A PARAMETER MAP BASED ON NUMERIC KEY WITH A DATE/TIME VALUE.
PI91969	UI IGNORES SPACE IN PROMPT VALUES
PI92738	ERROR WHEN CREATING A DASHBOARD FROM A DQM PACKAGE BASED ON A MAPPING TABLE
PI96727	CMS/RDS CALLS ERROR OUT WITH INVALID CREDENTIALS ERROR.
PI96368	HTML OUTPUTS ARE ATTACHED AS MHT FILES IN EMAILS IF EMAIL BODY IS SPECIFIED
PI93448	DUPLICATE RESULTS IN AGGREGATION USING SNOWFLAKE DB

Here’s an interesting problem. A user can select multiple items from a tree prompt, from any level. The report shows all of the selected members, but the total should only include items from the lowest members.

Let’s take a look at what happens if we select the all member and the first level. In this case, the retailers hierarchy.

By simply doing total(currentMeasure within set [Retailers]) we’re doubling the value. Which makes sense, the Retailers member contains the five regions. It’s exactly the same as saying, “I want the total for all of the retailers plus the total for all five regions”.

Instead we need a way of saying, “I want to total only those members which don’t have any descendants in the set”.
First let’s build the set expression to get those members.

filter(
    [Retailers]
  , count(member(1) within set 
    intersect(
      descendants(
          currentMember(hierarchy([Retailers]))
        , 0
        , after
      )
    , [Retailers]
  )
  )=0
)

A bit complicated so let’s walk through it.

First we go to the Retailers set. For each member ( currentMember() ), we find all of it’s descendants ( descendants(.., after), we then intersect that on the original set, and count the members in common. Finally we can then say we only want those retailers where the count of descendants is 0. Important note. This is probably not the most performant expression in the world. For each member it’s going down to the leaf level and comparing that against the original set. Good for a hierarchy containing a few thousand members. Not so good when your hierarchy has millions of members.

We can then wrap that expression in total:

total(currentMeasure within set filter([Retailers],count(member(1) within set intersect(
descendants(currentMember(hierarchy([Retailers])),0,after),
[Retailers]
))=0)

And let’s see how it looks.

Now what happens if we want the opposite. We want the top members summed. If we have the all member, only that. The question then becomes, “I want to total only those members which don’t have any descendants in the set”. The solution is very similar to the first problem. The only problem is Cognos doesn’t support the MDX standard “ascendants” function.

This I will leave as an exercise for the reader. If you get stumped, feel free to see the solution in the attached report.
summing-leaf-members.txt (418 downloads)