IBM Support

Cognos Analysis for Microsoft Excel 10.2.2 Fix Lists

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

Issues corrected since IBM Cognos Analysis for Microsoft Excel 10.2.
NumberDescription
PI07324Cognos Analysis for Excel crosstab does not show alias names from TM1 data source.
PI09217Perspectives 10.2 context menu items ("Data Spread", "Holds" and "Active Forms") disappear after launching CAFE
PI10506CAFE Row Limit of 0 not accepted
PI10544RSV-BBP-0022 in CAFE 10.2 when opening TM1 packages
PI10703BI - COGVAL formulas are not solved in the workbook saved using previous release
PI11104CAFE add-in does not load for any user other than the one that installed the product in Excel 2007
PI12066Some member names with special characters (like double quotes) generate error in the annotation editor of CAFE
PI12105Size change for wide values is not respected after commit in CAFE
PI12413TM1 View not displayed in CAFE
PI12974With Refresh All Data selected, tiling windows Horizontally causes Excel to hang
PI13009CAFE 10.2 FP1 - cannot browse "One Level UP" after publishing
PI13032CAFE - Unable to change TM1 server or Package from the System or Package fields
PI13077Search for Alias in set editor with unexpected result
PI13511Cognos tab does not appear in excel when CAFE 10.2 FP1 is installed by SYSTEM account
PI13603Cognos Office Interface - Resizing "Options" window cuts text short
PI16532Unable to drill down on crosstab cell with CAFE 10.2 FP1
PI16653If CAFE workbook is open with other workbook then CAFE formats are applied to all excel files
PM93029Duplicate labels with CAFE formulas accessing TM1 Cube via BI platform
PM93858TM1 - Unable to replace a member in rows and columns with another member, user has to delete existing one insert the new one
Issues corrected since IBM Cognos Analysis for Microsoft Excel 10.2.2.
NumberDescription
PI16651CAFE with split view makes Excel hang
PI16806Cognos Analysis for Microsoft Excel 10.2 Fix Pack 1 causes Microsoft Excel to incorrectly present Document Recovery window
PI17730Published report opens and updates against wrong package.
PI17888CAFE is hanging when switching from TM1 view to Excel file with macros
PI18449Unable to upgrade reports with Flex Views and empty rows and columns from Cafe 10.2. to Cafe 10.2.2
PI18694Element chosen from the dimension editor in crosstable in CAFE 10.2.2 isn't shown
PI18888Creating Flex view sometimes receive error HRESULT: 0x800401A8
PI18924When disabling CAFE in MS Excel then MS Excel closed suddenly
PI19088Index was out of range error when opening dimension editor from a tm1 crosstab view with zero data
PI19212Non committed values lost if a cell is double-clicked
PI19213Unable to see elements when no permission granted for parent element.
PI19320Unable to commit data from Flex View in IBM Cognos Analysis for Microsoft Excel 10.2.2
PI19796Unable to log in to CAFE when a port is not used with the TM1 URL
PI21077Formulas on Sheets are not Refreshed
PI21301#ERR_INVALID_METADATA is displayed for COGVAL formulas
PI21598Right click menu disappear after deleting and recreating Flex view
PI21675Flexview not displayed as current Flexview if an Excel file is opened before the flexview.
PI21931Prompting to save the workbook again even though no changes made to the workbook
PI21954Loosing regional formatting when refreshing data
PI22026Copy and paste under Excel do not work as expected: the paste is only possible one time.
PI22117Can't "Convert to static" if the sheet is unlocked
PI22127Refresh All Data Dialog box re-appears even after 'Do not show again' is checked.
PI22311Can't update formatting
PI22560Parameter "RefreshDropDown" set to PreviewOnly causes TM1Server to fail
PI22730Russian characters in drop down list
PI22732Creating Analysis removes Insert Comments from Excel context menu
PI23222Some Flexview lost or not refresh correctly if an Excel file is opened before the flexview.
PI23236A crosstab published from CAFE to IBM Cognos BI and reopened using Excel 2013 the CAFE toolbar is not displayed.
PI23439Unable to commit changed value when comma is used as decimal symbol
PI23568Publish to content store fails
PI23573Focus is lost from element when changing order
PI23681Cell Copy/Paste operation not possible for second and subsequent operations
PI24265Poor performance on "Convert to Static" with CAFE 10.2.2
PI24351Performance issue when committing TM1 data in crosstable using excel link
PI24369TM1 - Element chosen from the overview dropdown in crosstab isn't shown if set is saved using Edit Set
PI24712Some flex views were missing
PI24897Should not prompt to log on to the server again when refreshing Flexviews in the sheet from the same TM1 server
PI25931CAFE not handling TM1 Elements with brackets in the name
Issues corrected in Cognos Analysis for Microsoft Excel 10.2.2 FP2.
NumberDescription
PI24492Switching between two crosstabs open in different excel files CAFE tab flashes
PI26367Drill doesn't create an 'with children' row definition
PI27499CAFE Crosstab misbehaves on Expand/Collapse on TM1 source set to Expand Above
PI27596Since upgrading CAFE from 10.1.1 to 10.2.2 FP1, Refresh action does not bring back the measure values
PI27776CAFE 10.2.2 slow to convert to Static
PI28190Converting #VALUE to static gets a big negative number
PI28191TM1 - All DBRW formulas show #VALUE if some formulas contains inaccessible members
PI28484In CAFE, saving dynamic dimensions in a view/subset are causing problems
PI28628Subset Error: Specified argument was out of the range of valid values
PI28740Migration from 8.4.1 to 10.2.1 CAFE analysis is not possible
PI28792VBA Project still open when close MS Excel file and GO! Office is opened
PI28899TM1 - Bringing the view with Picklist cells taking long
PI29032CAFE System.ComponentModel.Win32Exception (0x80004005) Handle is invalid
PI29235Flex View not recognized when Alt-tabbing from another Excel file
PI29321Exploration Context broken
PI30491Cafe/GoOffice Menu Bar disappears when opening Excel file via double-click
PI31037TM1- "ObjectNotFound.....error when edit set from overview defined using context Add menu...drag and drop is not the same....
Issues corrected in Cognos Analysis for Microsoft Excel 10.2.2 FP3.
NumberDescription
PI28258COGNOS TAB DOES NOT APPEAR IN EXCEL WHEN CAFE 10.2.2 FP1 IS INSTALLED BY SYSTEM ACCOUNT
PI31842USERS UNABLE TO LOG OUT OF CAFE
PI32019TM1 - CONVERTING EXPLORATION IN A NEW SHEET BY PRESSING THE TOOLBAR BUTTON NOT CREATING THE NEW SHEET FOR THE FLEXVIEW
PI32203CAFE FORMULAS CANNOT BE CALCULATED IF THE ALIAS NAMES ARE SPECIFIED
PI32211ELEMENT CHOSEN FROM THE DIMENSION EDITOR IN CROSSTAB IN CAFE 10.2.2 IS LOST WHEN CHANGING ORDER TO THE LEFT
PI32503DBRA FUNCTION GIVES #VALUES! ERROR EVEN WHEN ATTRIBUTE VALUES EXIST
PI32712SUBNM INDEX VALUE STARTS WITH 0 BUT SHOULD START WITH 1
PI32789WHEN MOVING ELEMENTS THEY DISAPPEAR FROM THE CAFE CONTEXT
PI33184COGNOS ANALYSIS FOR MICROSOFT EXCEL RETURNS #ERR_INVALID_SERVER WHEN WORKSHEET TAB NAME CONTAINS AN APOSTROPHE
PI33744SUBNM FUNCTION ISSUES. ELEMENT SELECTION CAUSES #VALUE ERROR
PI33751CREATING AN ACTION BUTTON FROM A TI PROCESS GENERATES VB ERRORS
PI33956ATTEMPTING TO OPEN A FOLDER CONTAINED WITHIN A QUERY SUBJECT FAI LS WITH OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT
PI33970PROCESSING CELLS MESSAGE STILL DISPLAY AFTER THE REFRESH IS COMPLETED
PI34037CAFE TOOLBAR NOT SCROLLING WHEN THE NUMBER OF CONTEXTS EXCEEDS THE SCREEN WIDTH
PI34505COGVAL IN CAFE EXPLORATION DOES NOT REFRESH DATA AS EXPECTED
PI34522CAFE TOOLBAR IS MISSING
PI34546CAFE REFRESH AFTER LOST AUTHENTICATION REQUESTS ALL TM1 SERVER METADATA
PI34833EXCEL AUTO FILTERS ARE LOST AFTER REFRESH OF FLEX VIEW
PI35053THE TYPE IN REFRESH SETTING FOR FLEX VIEWS DOES NOT PERSIST BETWEEN SESSIONS
PI35054EXCEL FORMULAS ARE REMOVED FROM THE SLICER RANGE OF A FLEX VIEW AFTER THE USER CLICKS 'OK' IN THE FLEX VIEW PROPERTIES DIALOG
PI35055USER IS UNABLE TO SCROLL VERTICALLY AFTER CHANGING THE FLEXVIEW OR SANDBOX DROPDOWNS
PI35543DBR/DBRW displays recalc when one points to an invalid reference
PI35544If 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
PI35572SUBNM OVERWRITES CELL REFERENCES
PI36299Cell properties window does not appear when the cell is blank
PI36329QUOTES ARE NOT ADDED TO A SUBNM FORMULA WHEN THE ELEMENT NAME IS NUMERIC
PI36330UPDATE SYSTEM UTILITY DOES NOT WORK WITH FLEX VIEWS
PI36331DOUBLE CLICK OF SUBNM FUNCTIONS DON'T WORK IN FLEX VIEW RANGES
PI36380VALUE SET AS STIRNG IN PERF MOD CAFE DISPLAYS AS CUSTOM USES 1000 SEPARATORS ON ENTRIES THAT LOOK LIKE NUMBERS
PI36472CLOSE CAFE AND MS EXCEL - USER SESSION STILL EXIST
PI36484NESTED TM1 FUNCTIONS DO NOT RESOLVE
PI36488SLOW LOADING OF METADATA TREE AND SLOW CREATION OF EMPTY CROSSTAB
PI36489SPECIAL CHARACTERS IN MEMBER NAMES CAUSES ERRORS IN FORMULAS
PI36492VALUES FOR YEAR MEMBERS ARE BEING INTERPRETED AS NUMERIC AND NOT WORKING WITH DBRW
PI36494LOGON RE-PROMPT WHEN WORKING WITH FORMULAS
PI36542FLEX VIEW NOT REFRESHING WHEN FORMULA-BASED TITLE VALUE IS CHANGED
PI36543ELEMENT NAME WITH COMMA IS SPLIT INTO 2 LINES. COMMA IS REPLACED WITH LINE BREAK
PI36880UPDATING CROSS TAB IS SLOW WHEN USER HAS EXCEL LINKS WHEN THOSE LINKS ARE EXTERNAL WORKBOOK REFERENCES
PI37470WHEN REFRESH A VIEW IN CAFE WITHOUT PERMISSIONS TO SOME OF THE INTEGRATED ELEMENTS THEN THE TM1 SERVER CRASHED
PI38039LOSING REFERENCE TO EXISTING FLEXVIEWS WHEN MOVING TO A LINKED SHEET
PI38591COPYING ONE CROSSTAB FROM ANOTHER LINKS THEM SO THAT CHANGES TO ONE ARE APPLIED TO ANOTHER. THEY ARE NOT INDEPENDANT.
PI39072CAFE EXPAND/COLLAPSE (TOGGLEDRILLSTATE) CAUSING LONG RUNNING QUERIES
Issues corrected in Cognos Analysis for Microsoft Excel 10.2.2 FP4.
NumberDescription
PI40353CAFE DOES NOT RESPECT TYPEIN AND SPREADING CAPABILITY
PI37946CAFE related work for Tm1 Threads Do Not Cancel (FP3)
PI39533Internal error 500 with CAFE against DMR with nested measure folder
PI39546Unable to add more than 2 measures in a column when the measures are included in a folder
PI40165CROSSTAB TOOLBAR NOT DISPLAYED ON BLANK WORKBOOK
PI40353CAFE DOES NOT RESPECT TYPEIN AND SPREADING CAPABILITY 365
PI41027COGVAL FORMULAS BEING REFRESHED EXCEED TOTAL COGVAL FORMULAS IN EXCEL FILE
PI41110TM1 - 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
PI41638Non CAFE tabs have their shading removed on Convert to Static
PI41749Cancelling a running async process on the server fails with flex views
PI41761MULTIPLE 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
PI42846CURRENT VALUE IS WRONG IN THE COMMIT PREVIEW SCREEN
PI43252Untranslated error message appearing when a user attempts to preview a change
PI43781PMHUB session is not killed when closes Excel without logging off
PI43823FLEX VIEWS ARE LOST WHEN SAVING A SHEET WITH LESS FLEX VIEWS
PI45514While in automation call, do not attempt to show dialogs during UnlinkAllData in flexviews
PI47470THE IBMCOGNOS RIBBON TAB GOES MISSING IN EXCEL 2013
Issues corrected in Cognos Analysis for Microsoft Excel 10.2.2 FP5.
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
 
NumberDescription
PI46033Hierarchies are not maintained after views are saved
PI48506Strange result when using merge function from excel with flexview
PI48622Fix initialization of maps when a protected worksheet is made editable
PI50336Color coding  sometimes  disappears or is not applied when pulling up a crosstab or flexview
PI52357In a sheet with 3 flex views, each cell has links to excel doc to load data, when refreshing, one of them loses the links
PI52360One flex view not refreshed with use-typein refresh, but correct behavior with normal refreshing
PI54512Flex view - refresh selected cells option does not refresh
PI54654Aliases not behaving uniformly in CAFE
PI55431Unable to create a flexview when a private subset exists on the rows axis
PI55486Able to add the same dimension twice in a cross tab
PI56232Single cell flex view does not refresh
PI57008SUBNM is returning wrong cell value
Issues corrected in Cognos Analysis for Microsoft Excel 10.2.2 FP6.
NumberDescription
PI45253Conflict With Cafe 10.2.2 + Fp And Master Data Services Addin: Excel Crashing When Closing It If The 2 Addins Are Active
PI53529Preview Windows For Dynamic Subsets Can Fail To Show Members
PI55195Installing Cafe 10.2.2 Fp4 Shows Errors In Installation Logs
PI59744Copy Paste Issue In Subset
PI60349Named Ranges Not Maintained
PI60716Unable To Enter String Data On A Cross Tab
PI61307Cafe: Searching In A Subset Editor For A Element Name The Code Will Appear Instead Of The Name
PI61379When }Localizeddimensionattribute Is Used Then Replace Member Is Greyed Out Based On A Flex View
PI62038"H" Automatically Committed Into TM1 Server
PI62154DIMIX 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.
NumberDescription
PI47564When asymmetric axis is applied on nested rows, alias is not working as expected anymore
PI64755MDX QUERY CHANGED WITHOUT WARNING - X-TAB
PI64787DRILL DOWN/DRILL UP CAUSES ERROR ON 'EDIT SET' FUNCTION
PI66513CAFE NOT SHOWING MEMBER PROPERTIES FOR ALL DIMENSIONS AT ALL TIMES
PI67315*INVALIDMDXEXPRESSION SYNTAX ERROR AT OR NEAR XX
PI67778FLEW VIEW>PROPERTIES>UPDATE>CHANGE TO OTHER CUBE WITH SAME DIMS
PI74066Square bracket in names aren't being resolved correctly in flex views
PI74182DEFECT 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
PI75867CAFE GOES IN AN INFINITE LOOP IF A DATA QUERY IS BAD


[{"Product":{"code":"SSHM9K","label":"Cognos Analysis for Microsoft Excel"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27041505