My good friend, and fellow IBM Champion, Ryan Dolley is hosting a livestream today at 1PM EST showing off many of the new features in the latest version of Cognos. Make sure to read more here: http://ibmblueview.com/cognos-analytics-11-1-5-whats-new/
Category: Uncategorized
Building reports across multiple cubes and data sources
There are many situations where you might need to build a report off multiple cubes. Sometimes you might need a cube for some parts of a report, and a relational source for another. Relational sources are easy, but how can you build prompts in queries from multiple cubes?
The first thing to do is to analyse the members in your cubes. Different cubes have different member structures.
Let’s take a look at random member unique names as they appear in different databases.
Note, I don’t have Essbase listed here, simply because I don’t have it installed on my laptop.
SSAS | [Adventure Works].[Date].[Date.Calendar].[Month]->:[M17].[[Date]].[Calendar]].[Month]].&[2011]]&[3]]] |
DMR | [Sales (analysis)].[Time].[Time].[Month]->[Time].[2011].[20111].[201103] |
TM1 | [Reporting].[Product].[Product].[Level1]->:[TMR].[Product].[Product].[987] |
PowerCubes | [Cube].[Date].[Date].[Date]->:[PC].[@MEMBER].[20140101-20140101] |
As you can see, MUNs are logically laid out. Assuming the MUNs are consistent, we can use these to build our queries.
Dates and Months
Let’s say we have a date prompt. In the DMR we need to use a date MUN, but in SSAS we need to use the month from it. Using various macro functions, and a few tricks, it will be easy to build the queries.
In the SSAS example above, the year and month values are split. So we need to extract those values from the selected date.
First we need a way to convert the selected date to a timestamp, because the macro date functions all need timestamps and not dates. Using dates would be too easy.
#toUTC(prompt('date','date','2011-03-01')+'T00:00:00Z')#
toUTC converts the specified string to a 0 point timezone. The T and Z shortcuts in the macro are simple shorthand to fill out the timestamp string. Using toLocal converts the string to the system timezone, which is dangerous for something like this as time-zones may cause inconsistent results in the query. So don’t use it.
Once we have the date in timestamp format, constructing the MUN is simple.
# '[Adventure Works].[Date].[Date.Calendar].[Month]->:[M17].[[Date]].[Calendar]].[Month]].&[' +timestampMask(toUTC(prompt('date','date','2011-03-01')+'T00:00:00Z'),'YYYY') +']]&[' +timestampMask(toUTC(prompt('date','date','2011-03-01')+'T00:00:00Z'),'mm') +']]]' #
Hint – wrap the macro function in sq() so you can see the expression it’s building. For example:
# sq( '[Adventure Works].[Date].[Date.Calendar].[Month]->:[M17].[[Date]].[Calendar]].[Month]].&[' +timestampMask(toUTC(prompt('date','date','2011-03-01')+'T00:00:00Z'),'YYYY') +']]&[' +timestampMask(toUTC(prompt('date','date','2011-03-01')+'T00:00:00Z'),'mm') +']]]' )#
becomes
[Adventure Works].[Date].[Date.Calendar].[Month]->:[M17].[[Date]].[Calendar]].[Month]].&[2011]]&[03]]]
DMR is actually a little easier. Despite the complex MUN above, we can actually reduce it to a single key. Note, this only works when the key is UNIQUE in the hierarchy. If the key appears multiple times with different parents, you will have to construct the full path.
Consider this example: [Cube].[Dim].[Hier].[Level]->[Product Group A].[Product B].[Red] Red may not be unique, so in order to get the correct member, the entire path with all of the pertinent keys would need to be included.
#'[Sales (analysis)].[Time].[Time].[Month]->['+timestampMask(toUTC(prompt('date','date','2011-04-01')+'T00:00:00Z'),'yyyymm')+']'#
The generated month MUN doesn’t match the MUN from the cube, but it will still work. If you validate in Cognos, you’ll get a warning like this:
XQE-WRN-0054 When the data source is queried for member "[Sales (analysis)].[Time].[Time].[Month]->[201104]" it returns member "[Sales (analysis)].[Time].[Time].[Month]->:[OL].[Sales (analysis)_Time].[Time].[Time].[2011].[20112].[201104]". It may not be the member you expect to see. query: "Report" dataItem: "SelectedMonth"
which is remarkably coherent for a Cognos error.
TM1 also lets you reference any member by simply calling its unique key, even if that member has different parents (possibly due to a multi-root hierarchy). In that case, using family functions may not work as expected.
In those cases we are constructing the member from scratch using the key. But what happens if you have a model that isn’t built using the keys as the underlying code? So often I see cubes where the caption of the member also works as the key. First you should smack the cube developer over the head and get them to fix the model.
The problem is that it may be impossible to switch the code of a level to a key, especially if the cube is already in a production environment. In those cases there are still a few possible solutions. One is to use queryValue, so long as your package also contains a relational model. You could use that to run a lookup to get the caption
queryValue(table.description,table.key = prompt('selectedKey','token'))
Older versions of Cognos, without the queryValue macro function can get the same effect by using parameter maps.
$productNameLookup(prompt('productKey','token'))
If the cube does have the key as a member property, you could use the filter function. In general I dislike this solution, and would bend over backwards to avoid it. Filter loops over every member in the referenced set, and if your level contains millions of members, this can be incredibly slow. The solution would be something like:
filter([cube].[dimension].[hierarchy].[level],[cube].[dimension].[hierarchy].[level].[keyProperty] = #prompt('selectedKey','token'#)
Ultimately by constructing MUNs using macros, or filtering on properties, you can safely query multiple cubes or relational models against the same keys and dates.
IBM Cognos Analytics 11.1.4 Fix List
November 7 EDIT: Rob mentioned below that IBM is re-releasing 11.1.4 to fix some drill through issues:
I just got a note on an open IBM Ticket: “We’d also like to inform you that CA 11.1.4 has been re-released today with additional fixes not included in the initial release of 11.1.4 pertaining to Drill Through type issues. We are encouraging customers download and update with the 11.1.4 re-release.”
Thank you Rob!
Some good news! I’ve heard a rumor that IBM is considering publishing the fix lists again. I delayed a couple of weeks in case they were planning on doing it for the 11.1.4 release, but no luck so far. Hopefully by 11.1.5 they’ll have their ducks in a row and I won’t have to do this again.
Without further adieu, the list.
1 | PH17738 | PH17738: BLANK SCREEN IS PRESENTED WHEN TRYING TO UPDATE THE TENANT INFORMATION IN COGNOS 11.1.3 |
2 | PH12714 | PH12714: SELECT VALUE PROMPT CHOICES MISALIGNED IN IE11 |
3 | PH07575 | PH07575: UNABLE TO GET OPTIONS FOR A REPORT SHORTCUT AS A RESULT OF SEARCH |
4 | PH16123 | PH16123: DASHBOARDS WIDGETS ARE NOT BEING FILTERED WHEN USING SUBSETS |
5 | PH15909 | PH15909: REPORT URL WITH PROMPT=FALSE WILL STILL PROMPT IN 11.0.13 |
6 | PH16007 | PH16007: FLY OUT PANEL FOR TENANT SETTINGS AND PROPERTIES IS EMPTY FOR ALL OBJECTS |
7 | PH16164 | PH16164: THE CAST OF A TIMESTAMP IN THE FILTER IS CAUSING LOCAL PROCESSING WITH GOOGLE BIGQUERY |
8 | PH14680 | PH14680: DASHBOARD AGAINST A PA CUBE IS THROWING A LOT OF XQE ERRORS |
9 | PH16489 | PH16489: PROMPT REPORT RUN IN BACKGROUND THROWS TYPE NULL ERROR IN EXCEL |
10 | PH16333 | PH16333: INVALID USE OF KEYWORD DISTINCT |
11 | PH16433 | PH16433: UNABLE TO NEST DATA ITEMS IN CHART TYPE CLUSTERED BAR CHART |
12 | PH16712 | PH16712: UNABLE TO USE CAST TO CONVERT A TIMESTAMP TO DATE IN GOOGLE BIGQUERY |
13 | PH16716 | PH16716: NAVIGATE THROUGH ?TEAM CONTENT?,HOWEVER, CLICKING ON THE CUSTOM FOLDER FROM THE LEFT BAR, NO CONTENTS ARE … |
14 | PH16504 | PH16504: ENABLE CAST OF TIMESTAMP TO A DATE IN BIGQUERY TO REDUCE DECOMPOSITION |
15 | PH16215 | PH16215: RE-WRITE LITERAL USING EMBEDDED QUOTE SO THAT BIGQUERY WILL ACCEPT IT VS PARSER ERRORS THEIR DRIVER/SERVER … |
16 | PH12604 | PH12604: XQE-PLN-0115 AN INVALID VALUE WAS ASSIGNED TO PROMPT |
17 | PH12238 | PH12238: REDUCE TIME FOR THE FIRST REPORT RUN |
18 | PH12226 | PH12226: INCORRECT TRANSLATION INTO SWEDISH IN THE FORMAT DIALOG WINDOW WHEN EDITING A DASHBOARD |
19 | PH12222 | PH12222: INCORRECT THOUSANDS SEPARATOR IN DASHBOARD SUMMARY WIDGETS WHEN USING SWEDISH LANGUAGE |
20 | PH12322 | PH12322: USERS WHO HAVE NO ABILITY TO ADD COLUMNS TO THE FILTER DOCK STILL SEE THE MESSAGE "DRAG AND DROP DATA HERE TO … |
21 | PH12324 | PH12324: SUMMARY VISUALIZATION IS EMPTY WHEN DATA USED AN APOSTROPHE (‘) |
22 | PH12300 | PH12300: VALUES OF RUNNING-COUNT ARE INCONSISTENT BETWEEN CQM AND DQM WHEN QUERIES ARE JOINED. |
23 | PH11880 | PH11880: ADVANCED SETTING LARGE WORKSHEET CAUSES BLANK CELLS WHEN GROUP REPEATING CELLS IS DISABLED |
24 | PH11676 | PH11676: AGGREGATE ADVISOR AGAINST A GERMAN CUBE MODEL WILL FAIL |
25 | PH12317 | PH12317: QUERY CANNOT BE PLANNED WITH 4 OR MORE CASE WHEN |
26 | PH11899 | PH11899: THE SCHEDULE DOES NOT RUN WHEN RUN ONCE IS CLICKED IN MY SCHEDULES AND SUBSCRIPTIONS |
27 | PH12617 | PH12617: EMPTY CONTEXT BASED MENU FOR PACKAGE WHEN NOT HAVING READ PERMISSION |
28 | PH05908 | PH05908: SEARCH IS UNABLE TO FIND SOME OBJECTS |
29 | PH04487 | PH04487: COPYING OR DELETING MULTIPLE REPORTS FROM THE C11 PORTAL GENERATES ONE OPERATION IN THE COGAUDIT.LOG |
30 | PH15886 | PH15886: ORACLE STORED PROCEDURE IMPORTS WITH NO INPUT PARAMETERS IN DQM AND NOT AT ALL IN CQM IN 11.1.3. |
31 | PH13815 | PH13815: DPR-ERR-2079 FIREWALL SECURITY REJECTION. YOUR REQUEST WAS REJECTED BY THE SECURITY FIREWALL. |
32 | PH11434 | PH11434: XQE-DAT-0001 ERROR OCCURRED WHEN ADDING MYSQL’S STORED PROCEDURETO A QUERY SUBJECT AND TESTING THIS IN FM. |
33 | PH11506 | PH11506: REPORT FAILS WITH JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION XVECTORCURRENTDATE |
34 | PH11633 | PH11633: INVALID IDENTIFIER WITH SNOWFLAKE USER-DEFINED FUNCTION |
35 | PH15536 | PH15536: THE TEXT ABOVE AND BELOW THE PROMPT TELLS THE USER TO SELECT A PACKAGE, WHEN IT SHOULD TELL THEM TO SELECT A … |
36 | PI93412 | PI93412: JAVA.LANG.NULLPOINTEREXCEPTION WHEN ATTEMPTING TO UPDATE OBJECT IN FM WITH SALESFORCE DATASOURCE THAT HAS BEEN … |
37 | PI82083 | PI82083: SEARCHING FOR A STRING IN COGNOS 11.0.6 RETURNS AN UNEXPECTED SET OF RESULTS IF CONTENT LANGUAGE IS CHANGED |
38 | PI93676 | PI93676: REPORT SET TO "RUN WITH FULL INTERACTIVE" = "NO" RUNS IN THE NEWVIEWER WHEN RUN IN HTML BACKGROUND. |
39 | PH05974 | PH05974: SMTPRULES FEATURE DOES NOT WORK IN COGNOS ANALYTICS |
40 | PH03165 | PH03165: BROWSER REFRESH (F5) CAUSES THE REPORT TO OPEN IN EDIT MODE |
41 | PH10335 | PH10335: ENRICH PACKAGE WITH MULTIPLE DATA SOURCES |
42 | PH10380 | PH10380: CM JAVA CORING WHEN ATTEMPTING TO SAVE OR RELINK DATA SOURCES |
43 | PH10774 | PH10774: "AMBIGUOUS CONNECTIONS" IN A DATAMODULE (NATIVE SQL) WHEN USING MULTIPLE DATASOURCE CONNECTIONS |
44 | PH10161 | PH10161: ALIAS ATTRIBUTES OF TOP LEVEL MEMBERS DO NOT SHOW IN REPORT |
45 | PH10546 | PH10546: SDS-CNC-0408 WATCH RULES FAIL TO SEND EMAILS BUT REPORTS AND SCHEDULES CAN BE SENT |
46 | PH10228 | PH10228: UNABLE TO EDIT TEXT FILTERS IN QUERY STUDIO WHEN MORE THAN ONE DATA SOURCE CONNECTION DEFINED |
47 | PH08719 | PH08719: ERROR: WE CAN’T CREATE YOUR SCHEDULE RIGHT NOW. TRY AGAIN LATER.WHEN CREATING A SCHEDULE USING GOOGLE OIDC … |
48 | PH10353 | PH10353: RUNNING A SIMPLE REPORT WITH MAPS (11.1.X, 11.0.X, OR LEGACY) WILL CAUSE IE TO CRASH AND THROW OUT OF MEMORY … |
49 | PH07937 | PH07937: WITH RSVP.PARAMETERS.LOG SET TO TRUE, SOME REPORTS DO NOT LOG ANY PARAMETERS IN THE AUDIT STORE TABLE … |
50 | PH11678 | PH11678: POWERCUBE DATA TAKES LONGER TO LOAD IN A DASHBOARD WHEN CONTENT LANGUAGE SET TO SPANISH |
51 | PH15213 | PH15213: XQE-PLN-0098 USING MONTH FUNCTION IN FILTER AGAINST SQLSERVER AND DQM |
52 | PH12454 | PH12454: SEA-GEN-0001 ERROR IS SHOWN IN COGNOSSERVER.LOG WHEN CA11.1.2 INSTALLED ON ENGLISH OS WITH FRENCH REGIONAL … |
53 | PH15670 | PH15670: GOOGLE BIGQUERY CAST EXPRESSION SUPPORTS A TARGET TYPE OF STRINGBUT NO PRECISION SPECIFICATION |
54 | PH15635 | PH15635: MISSING VISUALIZATION PROPERTIES |
55 | PH14996 | PH14996: EXPRESSION LIKE ‘%20’ IN A DATA MODULE CALCULATION IS CONVERTED TO LIKE ‘+’ |
56 | PH02552 | PH02552: EMPTY LINES ARE TRUNCATED FROM THE REPORT DESCRIPTION() USED IN A RICH ITEM TEXT IN THE REPORT EXPRESSION |
57 | PH02628 | PH02628: ERROR WHEN RUNNING A REPORT TO EXCEL FROM PORTAL WHEN REPORT CONTAINS JAVASCRIPT IN CUSTOM CONTROL |
58 | PI92696 | PI92696: ODD AND INCONSISTENT THEME CUSTOMIZATION BEHAVIOR FOR NON-SYSTEMADMINISTRATORS. |
59 | PI99418 | PI99418: REPORT NAME MISSING UNDER MANAGE –>ACTIVITIES–>CURRENT WITH "RUNNING IN BACKGROUND UN-TICKED" IN CA 11.11 |
60 | PH01474 | PH01474: WONDER WHY "BLAH BLAH" IS IN PROPERTIES FILE <C11>/WEBAPPS/P2PD/WEB-INF/SCRIPTS/PROCESSORS/HISTORY.GROOVY |
61 | PI95562 | PI95562: LICENSES FOR ANALYTICS USER COUNT TOWARDS ANALYTICS ADMINISTRATOR |
62 | PH10985 | PH10985: ERROR THROWS BY A IF-THEN-ELSE EXPRESSION IN A ACTIVE LIST REPORT |
63 | PH11105 | PH11105: IE CRASHING WITH OUT OF MEMORY ERRORS WHEN USING DASHBOARDS WITHMULTIPLE MAP VISUALIZATIONS |
64 | PH11029 | PH11029: WHEN DRILLING UP IN DASHBOARD THE FILTER REMAINS. |
65 | PH08971 | PH08971: DATA MODULE BASED ON A DATA SET AND A PACKAGE IGNORED THE DECIMAL AND THOUSAND DELIMITER |
66 | PH06861 | PH06861: CJAP – JDBC SAMPLE DOES NOT WORK IN CA 11.1 – LOGON ATTEMPTS RESULT IN AAA-SYS-0001 |
67 | PH12452 | PH12452: CLOSING OPEN REPORTS IN A TAB BRINGS USER BACK TO WELCOME PAGE INSTEAD OF SET HOMEPAGE |
68 | PH13841 | PH13841: SQLSERVER STORED PROCEDURE IN DATABASE WITH DASH/HYPHEN IN NAME FAILS TO TEST IN DQM |
69 | PH12812 | PH12812: DASHBOARD VISUALIZATION SET WITH REFRESH AUTOMATICALLY IS NOT UPDATED WITH LATEST DATABASE DATA |
70 | PH12556 | PH12556: CANNOT HAVE DATA SOURCES AND SECURITY OBJECTS SHARING THE SAME NAME |
71 | PH12706 | PH12706: WHEN A FILTER CONDITION IN A DASHBOARD IS BASED ON A DATA ITEM CONTAINING AN APOSTROPHE ( ‘ ) NO DATA IS … |
72 | PH12661 | PH12661: RECENT IE UPDATE IS CAUSING SCRIPTING ERRORS WHEN LAUNCHING FRAMEWORK MANAGER |
73 | PH14844 | PH14844: ‘TYPEERROR’ OCCURS BY PRESSING ‘ENTER’ KEY AFTER SELECTING ANY OPTIONS ON 11.1.3 CUSTOM FILTER. |
74 | PH14861 | PH14861: UPGRADE FROM 11.0.13 TO 11.1.3 REPORTS FAIL WITH XQE-GEN-0005 INTERNAL ERROR FOUND: COM.COGNOS.XQE.AST.SQL…. |
75 | PH14724 | PH14724: DATA CONTAINER ERROR WHEN TRYING TO COPY VISUALIZATION WHICH CONTAINS A DRILL THROUGH DEFINITION |
76 | PH14721 | PH14721: USING INCLUDE OR EXCLUDE FILTER ON A CROSSTAB REPORT OUTPUT RETURNS XQE-PLN-0004 FOUND AN INTERNAL ERROR ON … |
77 | PH14644 | PH14644: DRILLTHROUGH CONTAINED IN A SINGLETON FAILS WITH TYPEERROR USINGIE11 BROWSER |
78 | PH14537 | PH14537: VIEW TABULAR DATA FAILS FOR A QUERY WHICH CONTAINS A DATA ITEM THAT INCLUDES PARAMETER DEFINITIO |
79 | PH12842 | PH12842: SOURCE REPORT FOR PDF IN A DRILL THROUGH SETUP GOES BLANK FOR SAVED OUTPUT VERSION |
80 | PH13253 | PH13253: A BATCH JOB WITH BURST REPORTS EXECUTE IN PARALLEL WILL INTERMITTENTLY FAIL WITH ERROR XQE-GEN-0005 |
81 | PH12909 | PH12909: SELECT AND SEARCH PROMPT DOES NOT RESPECT RUN WITH FULL INTERACTIVITY SETTINGS IN BACKGROUND |
82 | PH12862 | PH12862: ALIGNMENT OF SELECT AND SEARCH PROMPT WAS CHANGED AFTER APPLYINGFP1 |
83 | PH12849 | PH12849: BACKGROUND COLOR OF VALUE PROMPT IN PROMPT PAGE CHANGES WHEN RUNIN BACKGROUND. |
84 | PH11914 | PH11914: IFRAME WITH PARAMETER AND VALUE SET DOES NOT AUTOMATICALLY RUN THE REPORT. |
85 | PH13018 | PH13018: FILTER FUNCTIONALITY AND RENDERING IS INCORRECT |
86 | PH12108 | PH12108: UNABLE TO CONVERT EXPLORATION TO CUSTOM REPORT IN PA FOR EXCEL AGAIN CA 11.1.2 |
87 | PH13218 | PH13218: QUERY STUDIO MODEL FILTER PROMPT APPEARS REPEATEDLY AFTER APPLYING IF 1010 |
88 | PH13087 | PH13087: UNABLE TO COPY ASSETS BETWEEN EXISTING REPORTS |
89 | PH13111 | PH13111: CONNECTION TO PA CUBE LOST. |
90 | PH13145 | PH13145: VECTORIZATION IN REPORTS. |
91 | PH13142 | PH13142: NUMEROUS JAVA.UTIL.ABSTRACTCOLLECTION.ADDALL ERRORS |
92 | PH13214 | PH13214: REPORT RUN TO EXCEL FORMAT WHICH HAS BEEN SAVED TO THE FILE SYSTEM CONTAINS END OF FILE MARKER AT 45,000 ROWS. |
93 | PH12523 | PH12523: MULTI SELECT VALUE PROMPTS SHOWS USING 11.X STYLE WHEN REPORT SET TO 10.X STYLE |
94 | PH12705 | PH12705: THE LINE SPACING ON MULTI-VALUE, VALUE PROMPTS IS INCONSISTENT BETWEEN COGNOS ANALYTICS 11.1.1 AND COGNOS … |
95 | PH13187 | PH13187: THE OPTION ( SHOW MISSING DATA AS GAP) IN LINE CHARTS DOESN’T WORK |
96 | PH12880 | PH12880: RACF PROVIDER IS NO LONGER AVAILABLE IN COGCONFIG NO RACF PROVIDER ON AIX AND ZLINUX. |
97 | PH13237 | PH13237: CANNOT SEE "CREATE SHORTCUT" OPTION WITH ONLY "READ" PERMISSIONS |
98 | PH12937 | PH12937: "ORA-00942: TABLE OR VIEW DOES NOT EXIST" OCCURS EVEN THOUGH THERE IT IS. |
99 | PH13706 | PH13706: XQE-PLN-0004 FOUND AN INTERNAL ERROR ON NODE ‘V5EDGE’. GETTYPE()? (MIGRATED REPORTS FROM 10.2.2 > 11.0.13) |
100 | PH13411 | PH13411: XQE-PLN-0174 THE COLUMN C2 MUST BE CONTAINED IN AN AGGREGATE FUNCTION OR THE GROUP BY CLAUSE. |
101 | PH13710 | PH13710: CALCULATION IN DATA MODULE ARE NOT DISPLAYED WITH CORRECT HEADERAND DATA FORMAT |
102 | PH12954 | PH12954: DSS-GEN-0002 UNABLE TO FIND COLUMN <> IN DATA SET <>. ERROR WHENTRYING TO ADD ANOTHER VIEW TO A DATA MODULE. |
103 | PH17134 | PH17134: PROMPTS IN CUSTOM CONTROL NOT WORKING PROPERLY WHEN REPORT RUN TO EXCEL FROM THE PORTAL |
104 | PH11902 | PH11902: HTML COMPARE IN LIFECYCLE MANAGER GIVES FALSE POSITIVES. IT DOESNOT DETECT ALL FONT OR FORMATTING DIFFERENCES |
105 | PH11900 | PH11900: OPTION TO RUN REPORTS IN DQM DOES NOT WORK IN COGNOS ANALYTICS LIFECYCLE MANAGER |
106 | PH12841 | PH12841: CONTENT MANAGER WITH GATEWAY INSTALLATION OF 11.1.2 FAILS TO RESTART |
107 | PH11875 | PH11875: REPORT PROMPTS IN LIFECYCLE MANAGER DO NOT FUNCTION PROPERLY WHEN THE HOSTNAME FOR THE COGNOS ANALYTICS SERVER … |
108 | PH13636 | PH13636: NULL POINTER EXCEPTION USING TM1 CONNECTION TO PA |
109 | PH12473 | PH12473: XQE-PLN-0307 REFERENCE TO MULTIPLE CUBES AND NAMESPACES |
110 | PH13432 | PH13432: POWER CUBE PACKAGE ERRORS OUT WHEN DISPLAYING METADATA IN DASHBOARD |
111 | PH13678 | PH13678: XQE-GEN-0005 FOUND AN INTERNAL ERROR FOR QUERY WITH MASTER DETAIL AND CROSS JOIN |
112 | PH13755 | PH13755: XQE-PLN-0296 THE ARGUMENT AT POSITION 4 OF ‘MEMBER’ FROM THE DATA ITEM ‘DATAITEM’ CANNOT BE COERCED INTO A … |
113 | PH13699 | PH13699: ERROR "XQE-GEN-0005 FOUND AN INTERNAL ERROR: JAVA.LANG.NULLPOINTEREXCEPTION" USING SHORTCUTS IN FM PROJECT … |
114 | PH13748 | PH13748: !MAPSUCCESS ERROR WHEN USING PA SUBSET PROPERTIES NESTED IN A SINGLE EDGE XTAB REPORT |
115 | PH14622 | PH14622: QUERY STUDIO NOT DISPLAYING CANCEL BUTTON |
116 | PH13430 | PH13430: CUSTOM VIEW RE-SET TO DEFAULT WHEN CLOSING A REPORT VIEWED FROM A SHARED LINK |
117 | PH14496 | PH14496: NEW URL PATH FROM FOLDER TO FILE SYSTEM DOESN’T WORK, THROWS CAFERROR IN CLASSIC VIEWER, INVALID URL ERROR IN … |
118 | PH14610 | PH14610: SERIOUS SYSTEM INSTABILITY. CM-SYS-5173 CONTENT MANAGER FAILED.. |
119 | PH14464 | PH14464: JAVA.LANG.INDEXOUTOFBOUNDSEXCEPTION WHEN USING A SID/CM/RID URL IN R13 |
120 | PH14145 | PH14145: REFERENCEERROR IS DISPLAYED WHEN CHANGING NUMBER STYLE IN AUTHORING |
121 | PH14244 | PH14244: AFTER DRILL THROUGH, TOGGLING A CONDITIONAL BLOCK IN TARGET REPORT CAUSES PROMPT PAGE TO SHOW |
122 | PH14257 | PH14257: DIFFERENCE IN TIME TAKEN TO OPEN AN ANALYSIS |
123 | PH14108 | PH14108: DASHBOARD DRILL THROUGH TO REPORT NOT APPLIED TO ALL TABS/ ALL WIDGETS |
124 | PH14236 | PH14236: WHEN USING A PARENT MEMBER WITH SPECIAL CHARACTER (APOSTROPHE), THE CHILD MEMBERS ARE NOT DISPLAYED IN … |
125 | PH13991 | PH13991: DATA TAG EDIT TO REMOVE AN OBJECT IS NOT DELETED |
126 | PH14065 | PH14065: EXCEL 2007 DATA TRANSLATION INTO RUSSIAN IS WRONG IN OLD UI AREAS |
127 | PH14096 | PH14096: CONTEXT MENU FOR THEMES AND EXTENSIONS DOES NOT OPEN SINCE IF1016 AND STILL EXIST IN IF1018 |
128 | PH14165 | PH14165: POOR PERFORMANCE IN PA USING REST APIS AFTER MUN CHANGES |
129 | PH14173 | PH14173: UNABLE TO DRILL THROUGH TO TARGET REPORT WHEN FULL INTERACTIVITYIS SET TO NO. DPR-ERR-2079 FIREWALL SECURITY … |
130 | PH13944 | PH13944: THEME WITH TEXT CONTAINING AN APOSTROPHE DOES NOT DISPLAY PROPERLY IN 11.1.2 |
131 | PH13689 | PH13689: WHITE SPACE ADDED TO THE TEAM CONTENT SLIDE-OUT PANE WHEN SWITCHING THE BROWSER TO FULL SCREEN |
132 | PH14052 | PH14052: SPELLING MISTAKE IN DISPATCHERMESSAGES_DE.PROPERTIES |
133 | PH16022 | PH16022: QUERY SERVICE RUNS OUT OF MEMORY WHILE EXECUTING THE PREDICT QUERY. |
134 | PH15855 | PH15855: UNABLE TO COPY/PASTE A DETAIL FILTER TO ANOTHER REPORT WHEN USING 11.1.3. |
135 | PH15668 | PH15668: COGNOS DOES NOT WORK FOR CAST FUNCTION DUE TO DQM IS SETTING WITH DECIMAL IS OFF. |
136 | PH15923 | PH15923: UNABLE TO ADD CROSSTAB SPACE ON THE LEFT AND RIGHT OF AN EXISTING CROSSTAB SPACE WHEN GUIDED REPORT LAYOUT IS … |
137 | PH14614 | PH14614: JOB DELIVERY EMAIL DOES NOT CONTAIN HTML OUTPUT IN THE BODY OF THE EMAIL. IT SENDS REPORT AS AN ATTACHMENT. |
138 | PH09780 | PH09780: BACKGROUND REPORT CONTINUES TO RUN AFTER BEING CANCELLED IN DISTRIBUTED ENVIRONMENT |
139 | PH09785 | PH09785: CROSS TAB SHOWS NO DATA WHEN FILTERED ON A STRING CONTAINING AN APOSTROPHE ‘ (SOURCE: DATA MODULE ON UPLOADED … |
140 | PH10061 | PH10061: NUMBER AND SPECIAL CHARACTER SORT ORDER FOR COPY/MOVE IS DIFFERENT TO THE MAIN UI FLYOUT |
141 | PH10009 | PH10009: IF A CUSTOM FOLDER NAME IS TOO LONG IT IS NOT DISPLAYED ON THE TOP OF THE LIST WHEN CLICKING ON CUSTOM FOLDER … |
142 | PH15235 | PH15235: ERROR IN REPORT AFTER MIGRATING FROM CA 11.0.13 TO CA 11.1.1 |
143 | PH14439 | PH14439: DMR BASED DASHBOARD ERROR, WHEN PROMPT MACROS ARE USED IN THE DATA SOURCE AND SCHEMA DEFINITION IN FM. |
144 | PH15371 | PH15371: ADDING A ROLE TO A CUSTOM FOLDER IN CUSTOMIZATION WILL CAUSE A VERY SLOW LOGIN PROCESS |
145 | PH15672 | PH15672: DEFINED A CONCATENATION WHICH DQM IS PUSHING TO GOOGLE BIGQUERY,THE DB VENDOR REJECTS THE EXPRESSION |
146 | PH15539 | PH15539: ‘RUN AS’ AND ‘NEW JOB’ PANELS ARE EMPTY IF EMBEDDED_CONTENT/PRELOGINSAMPLE.HTML HAS BEEN ACCESSED IN ANOTHER … |
147 | PH15064 | PH15064: REPORT PRODUCE A CROSS JOIN IF A DATA MODULE IS USED WITH A PACKAGE AND UPLOADED FILE |
148 | PH15752 | PH15752: DRILL THROUGH ON A VISUALIZATION FAILS WITH TYPEERROR WHEN USING"DO NOT PASS PARAMETER" |
149 | PH11990 | PH11990: CREATING A JOB AND ADDING REPORTS TO BE SEND VIA EMAIL WITH A LINK TO THE REPORT, THE EMAIL CONTAINS "XHTML" … |
150 | PH10647 | PH10647: DRILL-THROUGH TO SAME REPORT FAILS BY CM-CAM-4005 AFTER LOGON SESSION TIMEOUT IN LTPA SSO ENVIRONMENT. |
151 | PH11750 | PH11750: DRILL THROUGH ISSUE (BAD PERFORMANCE OR EVEN ERROR) IN COGNOS ANALYTICS 11.0.13 AFTER UPGRADE FROM COGNOS BI … |
152 | PH05396 | PH05396: REPORT APPEARS IN SEARCH RESULTS IF USER DOES NOT HAVE PERMISSION TO ACCESS FOLDER STRUCTURE AND REPORT |
153 | PH15418 | PH15418: UNABLE TO DELETE, DOWNLOAD AND UPDATE ANY THEMES AFTER APPLYING 11.0.13 IF1019 |
154 | PH15230 | PH15230: ALL TEXTS UNDER VISUALIZATION CHART LEGEND OPTIONS ARE NOT TRANSLATED FOR NON-ENGLISH PRODUCT LANGUAGE |
155 | PH15270 | PH15270: CUSTOMIZATION FOLDER NOT VISIBLE |
156 | PH15249 | PH15249: OPEN TARGET REPORT FROM SOURCE REPORT, THE NAME DOES NOT CHANGE TO TARGET REPORT, IF THERE IS VIEW VERSIONS … |
157 | PH14988 | PH14988: WHEN CANCEL REPORT FROM VIEW TABULAR DATA, COGNOS DIRECT BACK TOWELCOME PAGE INSTEAD OF CUSTOM DEFAULT HOMEPAGE |
158 | PH15046 | PH15046: UNABLE TO RUN ./TRIGGER.SH FROM COMMAND LINE. |
159 | PH14995 | PH14995: SLOW PERFORMANCE AGAINST PLANNING ANALYTICS WITH REPORT THAT CONTAINS MANY SIMPLE CALCULATIONS |
160 | PH08235 | PH08235: EXTERNAL DATA WITH CQM PACKAGE CAUSE DATA ITEMS LIST AS UNDEFINED AND RE-PUBLISH THROUGH ERROR |
161 | PH08347 | PH08347: SCHEDULING AN EVENT RETURNS – SAXEXCEPTION: INVALID ELEMENT |
162 | PH14997 | PH14997: ADDING OR MODIFYING ADVANCED CONDITIONS ON CHARTS THROWS TYPENULL ERRORS |
163 | PH06701 | PH06701: DELIVERY SERVICE(DLS) IS NOT CALLED WITHOUT RECIPIENT ON E-MAILTASK |
164 | PI99537 | PI99537: QS REPORT PASSING DATE PARAMETER AS STRING IF PROMPT TYPE IS SELECT VALUE |
165 | PH11901 | PH11901: IN A SCHEDULE THE RECIPIENT LIST WILL BE OVERLAPPING WHEN THE FOLDERS ARE IN TO MANY SUBFOLDERS |
166 | PH10890 | PH10890: DRAGGING A TEXT ITEM TO A LAYOUT COMPONENT REFERENCE GIVE TYPEERROR: CANNOT READ CHILD PROPERTY ‘CHILDNODES’ … |
167 | PH11951 | PH11951: XQE-DAT-0001 INVALID USE OF KEYWORD DISTINCT OR ALL WITH FUNCTION COUNT |
168 | PH11689 | PH11689: SNOWFLAKE User Defined FUNCTIONS DO NOT APPEAR IN METADATA IMPORT |
169 | PH11865 | PH11865: FILTER AND GROUPBY CLAUSE DROPPED FOR A COMPATIBLE QUERY MODE CONNECTION AGAINST VERTICA DATABASE |
170 | PH15144 | PH15144: XQE-GEN-0005 NULLPOINTEREXCEPTION ERROR WHEN ITEMS HAVE DETAIL AGGREGATION = NOT APPLICABLE |
171 | PH12839 | PH12839: HTML REPORT OUTPUT IS NOT WELL FORMED. IF YOUR REPORT USES "HTMLITEM" ELEMENTS ENSURE THAT THEY RESULT IN … |
172 | PH11992 | PH11992: ORA-12704 CHARACTER MISMATCH WHEN USING STRING LITERAL IN ANY CONSTRUCT IN ORACLE DQM |
173 | PH12355 | PH12355: XQE-DAT-0001 ORA-12704: CHARACTER SET MISMATCH WHEN RUNNING AUDIT REPORTS IN 11.0.13 FP1 |
174 | PH13140 | PH13140: XQE-GEN-0002 AN UNEXPECTED EXCEPTION OCCURRED: JAVA.LANG.NULLPOINTEREXCEPTION |
175 | PH16277 | PH16277: DATA MODULE BASED DASHBOARD FAILS WITH ERROR ‘V5 SYNTAX ERROR FOUND IN EXPRESSION’ WHEN ADDING FILTER ON … |
176 | PH12308 | PH12308: CNC-ASV-0050 ERROR WHEN USING THE CONDITION 1=1 |
177 | PH11956 | PH11956: ANALYSIS STUDIO CROSSTAB WITH A MEASURE WHICH INCLUDES A AGGREGATION RULE LAST BASED ON DIMENSION – ERROR |
178 | PH12265 | PH12265: VERTICAL SCROLLBAR DOES NOT APPEAR WHEN APPLYING SECURITY FILTERS ON DATAMODULE |
179 | PH11682 | PH11682: COMPLEX CALCULATION LOCALLY PROCESSED IN DQM |
180 | PH11326 | PH11326: DB2 ERROR WHEN USING DATA ITEM VALUE AS COLUMN HEADER AND CROSS JOIN |
181 | PH12903 | PH12903: DATA MODULE CUSTOM SQL VALIDATION FAILS WITH LARGE SQL QUERY WHEN USING A WEB SERVER |
182 | PH13208 | PH13208: LEGEND TITLE IS VISIBLE IN PDF/EXCEL FORMAT EVEN THOUGH ITS BEEN DISABLED FOR VISUALIZATION |
183 | PH13677 | PH13677: LIMITED FUNCTION SET RETURNS WARNING FOR TRUNC |
184 | PH16454 | PH16454: XQE-PLN-0248 ERROR OCCURS IN A REPORT USING ?COUNT DISTINCT? ON THE ON-DEMAND TOOLBAR |
185 | PH13788 | PH13788: SUMMARY ROW OF A TABLE VISUALIZATION IN A DASHBOARD DOES NOT CORRECTLY AGGREGATE CUSTOM CALCULATION COLUMN. |
186 | PH14117 | PH14117: IN 11.1.2, REPORT STILL RUNS IN HTML USING SHARE LINK WHEN DEFAULT REPORT FORMAT IS SET TO PDF |
187 | PH09528 | PH09528: COGNOS 11.1 R2 DOES NOT PRODUCE THE CORRECT OUTPUT WHEN TOP FUNCTION AND FILTER IS USED |
188 | PH15052 | PH15052: USER WITHOUT UPLOAD FILE CAPABILITY CAN SEE DRAG AND DROP FILES,OPEN QUICK LAUNCH OR BROWSE SECTION ON HOME … |
189 | PH08789 | PH08789: EMAIL BODY SHOWING AS NULL WHEN REPORT IS CONTAINED WITHIN A JOB |
190 | PH06703 | PH06703: NO ERROR MESSAGE IF YOU SET AGENT ON EVENT STUDIO WITHOUT RECIPIENTS |
191 | PH11249 | PH11249: GEN-ERR-0002 ERROR RUNNING REPORTS AFTER UPGRADE TO 11.0.13 |
192 | PH10395 | PH10395: WITH A SEARCH, USER CAN SEE CONTENT IN A RESTRICTED FOLDER |
193 | PH04636 | PH04636: SAPBW: DIMENSIONS GROUPS CANNOT BE IMPORTED BECAUSE DYNAMIC QUERY MODE SET LANGUAGE TO EN-US |
194 | PH09674 | PH09674: WHEN A USER HAS A LARGE NUMBER OF HTS ITEMS (12K) THE INBOX WIDGET IN WORKSPACE WILL RETURN A DIALOG BOX … |
195 | PH12268 | PH12268: CREATING A DASHBOARD OFF A DATA MODULE REQUIRES A CLOSE OF THE DASHBOARD TO SEE DATA AFTER RELOAD |
196 | PH12807 | PH12807: UNABLE TO CHANGE THE TITLE COLOR OF A DASHBOARD VISUALIZATION USING ‘FAVORITES’ LIST |
197 | PH16989 | PH16989: WEBPAGE ERROR: UNABLE TO GET PROPERTY ‘XXXXX’ OF UNDEFINED OR NULL REFERENCE |
198 | PH11507 | PH11507: REPORT FAILS WITH JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION XVECTORCASTLONGTODOUBLE |
199 | PH16785 | PH16785: DRILL THROUGH PASSING LARGE LIST OF VALUES |
200 | PI86287 | PI86287: RQP-DEF-0326 ERROR (RUNNING/VALIDATING A REPORT WITH SQL QUERY OBJECT THAT FAILS) WHEN TESTING A USER-DEFINED … |
201 | PH08728 | PH08728: WARNING POP-UP WHEN RUNNING INTERACTIVE REPORT AS A USER WITH NOREAD PERMISSION ON THE REPORT OR DATA MODULE |
202 | PH10334 | PH10334: CREATING JOB WITH ‘SAVE THE REPORT AS A REPORT VIEW’ CLEARS OUT JOB STEPS IN U |
203 | PH13016 | PH13016: COPY AND PASTE FROM ONE QUERY TO ANOTHER BETWEEN 2 REPORTS NOT POSSIBLE |
204 | PH11522 | PH11522: UNNECESSARY OIDC LOGIN WHEN RUNNING A PROMPTED CLASSIC VIEWER REPORT IN THE BACKGROUND THAT RETURNS AN ERROR … |
205 | PH12184 | PH12184: HTML report output is not well formed |
206 | PH13412 | PH13412: LIMITED FUNCTION SET RETURNS WARNING FOR TO_CHAR |
207 | PH13697 | PH13697: ADVANCED SETTING FOR WHITELISTING EMAIL DOMAINS |
208 | PH14388 | PH14388: JAVASCRIPT ERROR POPS UP WHEN RUNNING REPORT WITH FULL INTERACTIVITY IN FIREFOX 68 |
209 | PH15930 | PH15930: INCORRECT DASHBOARD CALCULATION PREVIEW OCCURS REGARDLESS OF DASHBOARD, DATA, FUNCTION AND TEMPLATE TYPE. |
210 | PH15506 | PH15506: JS ERRORS WHEN SELECTING DATA CONTAINER IN QUERY EXPLORER |
211 | PH06122 | PH06122: USERS WHO HAVE RUN PERMISSION ON REPORT ARE ABLE TO OPEN IT UP IN EDIT MODE AFTER REFRESHING THE BROWSER WHILE … |
212 | PH15189 | PH15189: CALCULATION USING A CASE STATEMENT WITH AGGREGATE MINIMUM ONLY RETURNS 1 VALUE IN LIST VISUALIZATION |
213 | PH14970 | PH14970: EASY INSTALLATION CHANGE YOUR PASSWORD FUNCTIONALITY REMOVED WITH 11.1.X |
214 | PH07751 | PH07751: ERROR DUE TO COGNOS SQL WITH WHERE CLAUSE |
215 | PH11141 | PH11141: ERROR DESCRIPTION SHOWN IN CUBE DESIGNER SAYS COGNOS 10 INSTEAD OF COGNOS 11 |
216 | PH14682 | PH14682: NAVIGATION BAR SETTINGS CAUSES DISAPPEARANCE OF DASHBOARD WIDGETFILTER ICONS |
217 | PH09329 | PH09329: DRILL TARGETS REFERRING TO REPORT ID INSTEAD OF REPORT REF PATH |
218 | PH11656 | PH11656: NO DATA AVAILABLE WHEN DRILLING FROM DASHBOARD TO REPORT ON NULLVALUE |
11.1.1: https://cognospaul.com/2018/11/27/ibm-cognos-analytics-11-1-1-fix-list/
11.1.2: https://cognospaul.com/2019/06/26/ibm-cognos-analytics-11-1-2-fix-list/
11.1.3: https://cognospaul.com/2019/07/22/ibm-cognos-analytics-11-1-3-fix-list/