Release Notes
Abstract
A comprehensive list of defect corrections for major releases, refresh packs and fix packs of Cognos Analysis for Microsoft Excel 10.2.2.
Details of the APARs listed below can be accessed by clicking the link for the APAR number. If you have questions about a particular defect, please contact Customer Support.
Content
Cognos Analysis for Microsoft Excel 10.2.2 Fix List
Number | Description |
PI07324 | Cognos Analysis for Excel crosstab does not show alias names from TM1 data source. |
PI09217 | Perspectives 10.2 context menu items ("Data Spread", "Holds" and "Active Forms") disappear after launching CAFE |
PI10506 | CAFE Row Limit of 0 not accepted |
PI10544 | RSV-BBP-0022 in CAFE 10.2 when opening TM1 packages |
PI10703 | BI - COGVAL formulas are not solved in the workbook saved using previous release |
PI11104 | CAFE add-in does not load for any user other than the one that installed the product in Excel 2007 |
PI12066 | Some member names with special characters (like double quotes) generate error in the annotation editor of CAFE |
PI12105 | Size change for wide values is not respected after commit in CAFE |
PI12413 | TM1 View not displayed in CAFE |
PI12974 | With Refresh All Data selected, tiling windows Horizontally causes Excel to hang |
PI13009 | CAFE 10.2 FP1 - cannot browse "One Level UP" after publishing |
PI13032 | CAFE - Unable to change TM1 server or Package from the System or Package fields |
PI13077 | Search for Alias in set editor with unexpected result |
PI13511 | Cognos tab does not appear in excel when CAFE 10.2 FP1 is installed by SYSTEM account |
PI13603 | Cognos Office Interface - Resizing "Options" window cuts text short |
PI16532 | Unable to drill down on crosstab cell with CAFE 10.2 FP1 |
PI16653 | If CAFE workbook is open with other workbook then CAFE formats are applied to all excel files |
PM93029 | Duplicate labels with CAFE formulas accessing TM1 Cube via BI platform |
PM93858 | TM1 - Unable to replace a member in rows and columns with another member, user has to delete existing one insert the new one |
Number | Description |
PI16651 | CAFE with split view makes Excel hang |
PI16806 | Cognos Analysis for Microsoft Excel 10.2 Fix Pack 1 causes Microsoft Excel to incorrectly present Document Recovery window |
PI17730 | Published report opens and updates against wrong package. |
PI17888 | CAFE is hanging when switching from TM1 view to Excel file with macros |
PI18449 | Unable to upgrade reports with Flex Views and empty rows and columns from Cafe 10.2. to Cafe 10.2.2 |
PI18694 | Element chosen from the dimension editor in crosstable in CAFE 10.2.2 isn't shown |
PI18888 | Creating Flex view sometimes receive error HRESULT: 0x800401A8 |
PI18924 | When disabling CAFE in MS Excel then MS Excel closed suddenly |
PI19088 | Index was out of range error when opening dimension editor from a tm1 crosstab view with zero data |
PI19212 | Non committed values lost if a cell is double-clicked |
PI19213 | Unable to see elements when no permission granted for parent element. |
PI19320 | Unable to commit data from Flex View in IBM Cognos Analysis for Microsoft Excel 10.2.2 |
PI19796 | Unable to log in to CAFE when a port is not used with the TM1 URL |
PI21077 | Formulas on Sheets are not Refreshed |
PI21301 | #ERR_INVALID_METADATA is displayed for COGVAL formulas |
PI21598 | Right click menu disappear after deleting and recreating Flex view |
PI21675 | Flexview not displayed as current Flexview if an Excel file is opened before the flexview. |
PI21931 | Prompting to save the workbook again even though no changes made to the workbook |
PI21954 | Loosing regional formatting when refreshing data |
PI22026 | Copy and paste under Excel do not work as expected: the paste is only possible one time. |
PI22117 | Can't "Convert to static" if the sheet is unlocked |
PI22127 | Refresh All Data Dialog box re-appears even after 'Do not show again' is checked. |
PI22311 | Can't update formatting |
PI22560 | Parameter "RefreshDropDown" set to PreviewOnly causes TM1Server to fail |
PI22730 | Russian characters in drop down list |
PI22732 | Creating Analysis removes Insert Comments from Excel context menu |
PI23222 | Some Flexview lost or not refresh correctly if an Excel file is opened before the flexview. |
PI23236 | A crosstab published from CAFE to IBM Cognos BI and reopened using Excel 2013 the CAFE toolbar is not displayed. |
PI23439 | Unable to commit changed value when comma is used as decimal symbol |
PI23568 | Publish to content store fails |
PI23573 | Focus is lost from element when changing order |
PI23681 | Cell Copy/Paste operation not possible for second and subsequent operations |
PI24265 | Poor performance on "Convert to Static" with CAFE 10.2.2 |
PI24351 | Performance issue when committing TM1 data in crosstable using excel link |
PI24369 | TM1 - Element chosen from the overview dropdown in crosstab isn't shown if set is saved using Edit Set |
PI24712 | Some flex views were missing |
PI24897 | Should not prompt to log on to the server again when refreshing Flexviews in the sheet from the same TM1 server |
PI25931 | CAFE not handling TM1 Elements with brackets in the name |
Number | Description |
PI24492 | Switching between two crosstabs open in different excel files CAFE tab flashes |
PI26367 | Drill doesn't create an 'with children' row definition |
PI27499 | CAFE Crosstab misbehaves on Expand/Collapse on TM1 source set to Expand Above |
PI27596 | Since upgrading CAFE from 10.1.1 to 10.2.2 FP1, Refresh action does not bring back the measure values |
PI27776 | CAFE 10.2.2 slow to convert to Static |
PI28190 | Converting #VALUE to static gets a big negative number |
PI28191 | TM1 - All DBRW formulas show #VALUE if some formulas contains inaccessible members |
PI28484 | In CAFE, saving dynamic dimensions in a view/subset are causing problems |
PI28628 | Subset Error: Specified argument was out of the range of valid values |
PI28740 | Migration from 8.4.1 to 10.2.1 CAFE analysis is not possible |
PI28792 | VBA Project still open when close MS Excel file and GO! Office is opened |
PI28899 | TM1 - Bringing the view with Picklist cells taking long |
PI29032 | CAFE System.ComponentModel.Win32Exception (0x80004005) Handle is invalid |
PI29235 | Flex View not recognized when Alt-tabbing from another Excel file |
PI29321 | Exploration Context broken |
PI30491 | Cafe/GoOffice Menu Bar disappears when opening Excel file via double-click |
PI31037 | TM1- "ObjectNotFound.....error when edit set from overview defined using context Add menu...drag and drop is not the same.... |
Number | Description |
PI28258 | COGNOS TAB DOES NOT APPEAR IN EXCEL WHEN CAFE 10.2.2 FP1 IS INSTALLED BY SYSTEM ACCOUNT |
PI31842 | USERS UNABLE TO LOG OUT OF CAFE |
PI32019 | TM1 - CONVERTING EXPLORATION IN A NEW SHEET BY PRESSING THE TOOLBAR BUTTON NOT CREATING THE NEW SHEET FOR THE FLEXVIEW |
PI32203 | CAFE FORMULAS CANNOT BE CALCULATED IF THE ALIAS NAMES ARE SPECIFIED |
PI32211 | ELEMENT CHOSEN FROM THE DIMENSION EDITOR IN CROSSTAB IN CAFE 10.2.2 IS LOST WHEN CHANGING ORDER TO THE LEFT |
PI32503 | DBRA FUNCTION GIVES #VALUES! ERROR EVEN WHEN ATTRIBUTE VALUES EXIST |
PI32712 | SUBNM INDEX VALUE STARTS WITH 0 BUT SHOULD START WITH 1 |
PI32789 | WHEN MOVING ELEMENTS THEY DISAPPEAR FROM THE CAFE CONTEXT |
PI33184 | COGNOS ANALYSIS FOR MICROSOFT EXCEL RETURNS #ERR_INVALID_SERVER WHEN WORKSHEET TAB NAME CONTAINS AN APOSTROPHE |
PI33744 | SUBNM FUNCTION ISSUES. ELEMENT SELECTION CAUSES #VALUE ERROR |
PI33751 | CREATING AN ACTION BUTTON FROM A TI PROCESS GENERATES VB ERRORS |
PI33956 | ATTEMPTING TO OPEN A FOLDER CONTAINED WITHIN A QUERY SUBJECT FAI LS WITH OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT |
PI33970 | PROCESSING CELLS MESSAGE STILL DISPLAY AFTER THE REFRESH IS COMPLETED |
PI34037 | CAFE TOOLBAR NOT SCROLLING WHEN THE NUMBER OF CONTEXTS EXCEEDS THE SCREEN WIDTH |
PI34505 | COGVAL IN CAFE EXPLORATION DOES NOT REFRESH DATA AS EXPECTED |
PI34522 | CAFE TOOLBAR IS MISSING |
PI34546 | CAFE REFRESH AFTER LOST AUTHENTICATION REQUESTS ALL TM1 SERVER METADATA |
PI34833 | EXCEL AUTO FILTERS ARE LOST AFTER REFRESH OF FLEX VIEW |
PI35053 | THE TYPE IN REFRESH SETTING FOR FLEX VIEWS DOES NOT PERSIST BETWEEN SESSIONS |
PI35054 | EXCEL FORMULAS ARE REMOVED FROM THE SLICER RANGE OF A FLEX VIEW AFTER THE USER CLICKS 'OK' IN THE FLEX VIEW PROPERTIES DIALOG |
PI35055 | USER IS UNABLE TO SCROLL VERTICALLY AFTER CHANGING THE FLEXVIEW OR SANDBOX DROPDOWNS |
PI35543 | DBR/DBRW displays recalc when one points to an invalid reference |
PI35544 | If one DBS formula on the worksheet contains an invalid reference all other formulas display a recalc message and do not send data even though they are valid formulasRECALC |
PI35572 | SUBNM OVERWRITES CELL REFERENCES |
PI36299 | Cell properties window does not appear when the cell is blank |
PI36329 | QUOTES ARE NOT ADDED TO A SUBNM FORMULA WHEN THE ELEMENT NAME IS NUMERIC |
PI36330 | UPDATE SYSTEM UTILITY DOES NOT WORK WITH FLEX VIEWS |
PI36331 | DOUBLE CLICK OF SUBNM FUNCTIONS DON'T WORK IN FLEX VIEW RANGES |
PI36380 | VALUE SET AS STIRNG IN PERF MOD CAFE DISPLAYS AS CUSTOM USES 1000 SEPARATORS ON ENTRIES THAT LOOK LIKE NUMBERS |
PI36472 | CLOSE CAFE AND MS EXCEL - USER SESSION STILL EXIST |
PI36484 | NESTED TM1 FUNCTIONS DO NOT RESOLVE |
PI36488 | SLOW LOADING OF METADATA TREE AND SLOW CREATION OF EMPTY CROSSTAB |
PI36489 | SPECIAL CHARACTERS IN MEMBER NAMES CAUSES ERRORS IN FORMULAS |
PI36492 | VALUES FOR YEAR MEMBERS ARE BEING INTERPRETED AS NUMERIC AND NOT WORKING WITH DBRW |
PI36494 | LOGON RE-PROMPT WHEN WORKING WITH FORMULAS |
PI36542 | FLEX VIEW NOT REFRESHING WHEN FORMULA-BASED TITLE VALUE IS CHANGED |
PI36543 | ELEMENT NAME WITH COMMA IS SPLIT INTO 2 LINES. COMMA IS REPLACED WITH LINE BREAK |
PI36880 | UPDATING CROSS TAB IS SLOW WHEN USER HAS EXCEL LINKS WHEN THOSE LINKS ARE EXTERNAL WORKBOOK REFERENCES |
PI37470 | WHEN REFRESH A VIEW IN CAFE WITHOUT PERMISSIONS TO SOME OF THE INTEGRATED ELEMENTS THEN THE TM1 SERVER CRASHED |
PI38039 | LOSING REFERENCE TO EXISTING FLEXVIEWS WHEN MOVING TO A LINKED SHEET |
PI38591 | COPYING ONE CROSSTAB FROM ANOTHER LINKS THEM SO THAT CHANGES TO ONE ARE APPLIED TO ANOTHER. THEY ARE NOT INDEPENDANT. |
PI39072 | CAFE EXPAND/COLLAPSE (TOGGLEDRILLSTATE) CAUSING LONG RUNNING QUERIES |
Number | Description |
PI40353 | CAFE DOES NOT RESPECT TYPEIN AND SPREADING CAPABILITY |
PI37946 | CAFE related work for Tm1 Threads Do Not Cancel (FP3) |
PI39533 | Internal error 500 with CAFE against DMR with nested measure folder |
PI39546 | Unable to add more than 2 measures in a column when the measures are included in a folder |
PI40165 | CROSSTAB TOOLBAR NOT DISPLAYED ON BLANK WORKBOOK |
PI40353 | CAFE DOES NOT RESPECT TYPEIN AND SPREADING CAPABILITY 365 |
PI41027 | COGVAL FORMULAS BEING REFRESHED EXCEED TOTAL COGVAL FORMULAS IN EXCEL FILE |
PI41110 | TM1 - If user has only READ access to all dimensions in the cube and only some elements from some dimensions then user cannot expand the hierarchy and collapsing and expanding gives Read Only access error |
PI41638 | Non CAFE tabs have their shading removed on Convert to Static |
PI41749 | Cancelling a running async process on the server fails with flex views |
PI41761 | MULTIPLE USER LOGONS APPEAR FOR 1 USER WHEN 1 SINGLE USER LOGS INTO CAFE |
PI42482 | UNABLE TO INSTALL CAFE 64 BIT ON A EXCEL 2013 64 BIT THAT COMES WITH OFFICE |
PI42846 | CURRENT VALUE IS WRONG IN THE COMMIT PREVIEW SCREEN |
PI43252 | Untranslated error message appearing when a user attempts to preview a change |
PI43781 | PMHUB session is not killed when closes Excel without logging off |
PI43823 | FLEX VIEWS ARE LOST WHEN SAVING A SHEET WITH LESS FLEX VIEWS |
PI45514 | While in automation call, do not attempt to show dialogs during UnlinkAllData in flexviews |
PI47470 | THE IBMCOGNOS RIBBON TAB GOES MISSING IN EXCEL 2013 |
March 8, 2016 - The fix for the following APAR was confirmed in this release after the fix list was initially published. PI51333 Allow flex views to be copied by copying an Excel worksheet |
|
Number | Description |
PI46033 | Hierarchies are not maintained after views are saved |
PI48506 | Strange result when using merge function from excel with flexview |
PI48622 | Fix initialization of maps when a protected worksheet is made editable |
PI50336 | Color coding sometimes disappears or is not applied when pulling up a crosstab or flexview |
PI52357 | In a sheet with 3 flex views, each cell has links to excel doc to load data, when refreshing, one of them loses the links |
PI52360 | One flex view not refreshed with use-typein refresh, but correct behavior with normal refreshing |
PI54512 | Flex view - refresh selected cells option does not refresh |
PI54654 | Aliases not behaving uniformly in CAFE |
PI55431 | Unable to create a flexview when a private subset exists on the rows axis |
PI55486 | Able to add the same dimension twice in a cross tab |
PI56232 | Single cell flex view does not refresh |
PI57008 | SUBNM is returning wrong cell value |
Number | Description |
PI45253 | Conflict With Cafe 10.2.2 + Fp And Master Data Services Addin: Excel Crashing When Closing It If The 2 Addins Are Active |
PI53529 | Preview Windows For Dynamic Subsets Can Fail To Show Members |
PI55195 | Installing Cafe 10.2.2 Fp4 Shows Errors In Installation Logs |
PI59744 | Copy Paste Issue In Subset |
PI60349 | Named Ranges Not Maintained |
PI60716 | Unable To Enter String Data On A Cross Tab |
PI61307 | Cafe: Searching In A Subset Editor For A Element Name The Code Will Appear Instead Of The Name |
PI61379 | When }Localizeddimensionattribute Is Used Then Replace Member Is Greyed Out Based On A Flex View |
PI62038 | "H" Automatically Committed Into TM1 Server |
PI62154 | DIMIX Formula Not Returning Data In Cafe |
Issues corrected in Cognos Analysis for Microsoft Excel 10.2.2 FP7. * APAR or Defect fix was confirmed after the fix list was initially published. |
|
Number | Description |
PI47564 | When asymmetric axis is applied on nested rows, alias is not working as expected anymore |
PI64755 | MDX QUERY CHANGED WITHOUT WARNING - X-TAB |
PI64787 | DRILL DOWN/DRILL UP CAUSES ERROR ON 'EDIT SET' FUNCTION |
PI66513 | CAFE NOT SHOWING MEMBER PROPERTIES FOR ALL DIMENSIONS AT ALL TIMES |
PI67315* | INVALIDMDXEXPRESSION SYNTAX ERROR AT OR NEAR XX |
PI67778 | FLEW VIEW>PROPERTIES>UPDATE>CHANGE TO OTHER CUBE WITH SAME DIMS |
PI74066 | Square bracket in names aren't being resolved correctly in flex views |
PI74182 | DEFECT WHEN PULLING FROM MULTIPLE TM1 DB'S IN SAME FILE |
PI74222* | CAFE SPREAD ERROR WHEN THE SPREAD CAPABILITY FOR ALLOW SPREADING IS SET TO DENY |
PI75867 | CAFE GOES IN AN INFINITE LOOP IF A DATA QUERY IS BAD |
Related Information
Cognos Analysis for Excel 10.2.2 Software Environments
Download Cognos Analysis for Microsoft Excel 10.2.2
Download Cognos Analysis for Microsoft Excel 10.2.2 FP2
Download Cognos Analysis for Microsoft Excel 10.2.2 FP3
Download Cognos Analysis for Microsoft Excel 10.2.2 FP4
Download Cognos Analysis for Microsoft Excel 10.2.2 FP5
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27041505