IBM Support

IBM Planning Analytics - PA Workspace and PA for Microsoft Excel Fix List

Release Notes


Abstract

A comprehensive list of defect corrections for Planning Analytics Workspace and Planning Analytics for MS Excel components in Planning Analytics 2.0.

PA Workspace and PA for Microsoft Excel are released independently from the rest of IBM Planning Analytics to provide defect corrections and enhancements more quickly.

Content

As of Planning Analytics V2.0, IBM maintains the source code and product documentation for Planning Analytics using a continuous delivery methodology, with one code base serving both cloud and local Planning Analytics deployments.

PA Workspace and PA for Microsoft Excel are released independently from the rest of IBM Planning Analytics to provide defect corrections and enhancements more quickly. Fix lists for Planning Analytics 2.0 releases can be seen at http://www.ibm.com/support/docview.wss?uid=swg27049229.

The Reference Number in the table below corresponds to either the APAR (and is linked to the full APAR record) if the defect was first reported by a Local customer, or to an internal defect number if the defect was first reported by a cloud customer.  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.

Planning Analytics Local 2.0.x Fix List

 

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release and Planning Analytics Workspace Release 46.

Reference Number Description
PH06849 PASTING IN PLANNING ANALYTICS WORKSPACE NEEDS TO BE DONE 2 TIMES TO PASTE THE VALUE CORRECTLY
PH08258 PLANNING ANALYTICS FOR MS EXCEL 39 - SUBSET CREATED VIA A TI THAT START WITH A } CHAR
PH12031 ZOOM SLIDER IN EXCEL GETS DISABLED WHEN BOTH OR EITHER ONE OF THE PA FOR EXCEL ADDINS ARE ENABLED
PH12065 AFTER OPENING BOOK OR REBUILDING SHEET, SOME SUBNM DISPLAY #VALUE! ERROR
PH12206 PLANNING ANALYTICS FOR MS EXCEL 42 ACTION BUTTON WITH SOURCE TYPE OF DBRW AND TARGET TYPE OF SUBNM BREAKS THE SUBNM AS THE ELEMENT PASSED IS MISSING QUOTES
PH13919 LOGOUT IN PLANNING ANALYTICS WORKSPACE RESULT IN 404 AND 500 ERROR MESSAGE VISIBLE IN FIDDLER TRACE
PH14639 PLANNING ANALYTICS FOR MS EXCEL API EXPLORATION CREATED BY CREATE EXPLORATION FROM MDX CREATES AN EXPLORATION WITH WRONG PROPERTIES
PH14654 VIEW DISPLAY COLUMN SIZE VARIES BY USER
PH14875 DELETING TEXT IN PLANNING ANALYTICS WORKSPACE LEAVES A "C" IN THE CELL
PH15159 ISSUE WHEN DRAGGING GROUPS MEMBER TO THE RIGHT HAND SIDE OF A RULE AND GETTING SQUARE BRACKETS AROUND THEM
PH15414 SORT ASCENDING/DESCENDING IN PLANNING ANALYTICS WORKSPACE INFLATES RAM USAGE
PH15656 CASE PLANNING ANALYTICS WORKSPACE BOOK MIGRATION ERROR MESSAGE IS MISLEADING
PH15810 SAVING BUTTON PATH CHANGES RESULT IN PLANNING ANALYTICS WORKSPACE LOOPING ONCE BOOK IS CLOSED
PH16028 CONVERT QUICK REPORT TO SNAPSHOT "TYPO MISTAKE"
PH16064 UNABLE TO REMOVE "NAVIGATION TO TARGET" FROM BUTTON IN PLANNING ANALYTICS WORKSPACE

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release and Planning Analytics Workspace Release 45.

Reference Number Description
PH04521 CONDITIONAL FORMATTING NOT WORKING IN PLANNING ANALYTICS FOR MS EXCEL
PH06583 TM1 'PASTE AS VALUE' SHOWING DBRW FORMULA
PH10165 DRAGGING REPORT CELLS ONTO CELLS WITH DATA IN PLANNING ANALYTICS FOR MS EXCEL BREAKS THE REPORT
PH11567 USING THE ORDER() FUNCTION IN MDX TO SORT DIMENSION MEMBERS ENDS WITH AN ERROR IN THE DIMENSION ELEMENT PICKER
PH11591 SELECTING ELEMENT IN CONTEXT DIMENSION RESETS THE OVERVIEW PANEL IN EXPLORATION REPORT
PH12206 PLANNING ANALYTICS FOR MS EXCEL 2.0.42 ACTION BUTTON WITH SOURCE TYPE OF DBRW AND TARGET TYPE OF SUBNM BREAKS THE SUBNM AS THE ELEMENT PASSED IS MISSING QUOTES
PH13037 UNABLE TO CONVERT EXPLORATION TO CUSTOM REPORT IN PLANNING ANALYTICS FOR MS EXCEL 2.0.42 AGAINST CA 11.1.2
PH13577 PLANNING ANALYTICS WORKSPACE DIMENSION EDITOR RESETS WEIGHTING WITH EVERY POSITION CHANGE OF A CHILD ELEMENT

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release and Planning Analytics Workspace Release 44.

Reference Number Description
PH06737 IN PLANNING ANALYTICS WORKSPACE, IT TAKES A LONG TIME TO DOWNLOAD CSV FILE WITH DRILL THROUGH RESULTS
PH07410 EXPLORATION CONTEXT TILE NOT ADJUSTING TO DYNAMIC SUBSET CONTENT IN PLANNING ANALYTICS FOR MS EXCEL
PH09795 REFRESHING BOOK IN PLANNING ANALYTICS FOR MS EXCEL IS CAUSING FORMATTING TO BE LOST
PH11148 GIF BACKGROUND WITH TRANSPARENCY COLOR NOT WORKING ANYMORE IN ACTION BUTTON
PH11167 TEMPLATE FROM PERSPECTIVES SHOWING #VALUE IN PLANNING ANALYTICS FOR MS EXCEL
PH11329 SUBNM() DISPLAYS #VALUE! IN DYNAMIC REPORT
PH12066 UNABLE TO HIGHLIGHT AND COPY SOURCE RULE FROM PLANNING ANALYTICS WORKSPACE IN EDGE BROWSER
PH12136 QUICK REPORT PROPERTIES DOES NOT PROPERLY SHOW CUBE NAME
PH12228 PLANNING ANALYTICS FOR MS EXCEL 2.0.42 INCORRECT VALUE FORMAT IN AN EXCEL DYNAMIC REPORT
PH12574 EDITING TI PROCESS PARAMETERS IN PLANNING ANALYTICS FOR MS EXCEL : SYSTEM.NULL REFERENCE EXCEPTION ERROR IF PARAMETER IS EMPTY
PH13022 AN ACTION BUTTON GETS PROGRESSIVELY SLOWER
PH13086 PLANNING ANALYTICS WORKSPACE COPY PASTE ISSUE WITH BROWSER LANGUAGE IN FINNISH FOR DECIMAL NUMBER
PH13171 PLANNING ANALYTICS WORKSPACE: IF BROWSER LANGUAGE IS NOT SET TO ENGLISH, ONE CANNOT PROVIDE FULL CONTROL PERMISSION TO WORKBOOKS AS THE PERMISSION COLUMN IS RIGHT JUSTIFIED
PH13302 PLANNING ANALYTICS FOR MS EXCEL 42 RETRIEVES DATA IN INCORRECT FORMAT (TEXT "." INSTEAD DECIMAL",") IN POLISH LANGUAGE
PH13458 PLANNING ANALYTICS WORKSPACE UNABLE TO ENTER DECIMALS IN WEBSHEET
PH13518 REFRESH PREVIEW WITH "REPLACE EXISTING VARIABLES NAMES AND TYPES" CORRUPTS TI PROCESS IF ENABLES AND BOX DIMENSION ENABLED
PH14596 MIGRATE BUTTON IS NOT AVAILABLE IN PLANNING ANALYTICS WORKSPACE USING CHROME 75.0.3770.100
PH14727 PLANNING ANALYTICS WORKSPACE NAVIGATION BUTTON NO LONGER WORKS AFTER UPGRADE
 

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release and Planning Analytics Workspace Release 43.

Reference Number Description
85694 / PH06457 HEBREW CHARACTER IN PLANNING ANALYTICS WORKSPACE SHEET TITLE AND BOOK NAME SHOWN AS # IN PDF
86090 / PH07450 HIERARCHY TAKES OVER 5 MINUTES TO EXPAND IN PLANNING ANALYTICS
86312 / PH07378 PLANNING ANALYTICS ADMINISTRATION: THE RESTART OF A TM1SERVER SHUTDOWNS THE SERVER AND DOES NOT RESTART WHEN TRANSACTION LOG (TM1S.LOG) IS LARGE
86672 / PH06433 [Chrome] SQUARE SHAPE WITH BACKGROUND-COLOR IS NOT VISIBLE IN WEB-BROWSER CHROME
87332 / PH09174 QUICK REPORTS DO NOT REFRESH ON OPEN - WORKBOOK_OPEN
87430 / PH09169 PLANNING ANALYTICS FOR EXCEL LOST A DIMENSION WHEN TRY CANCEL DRAG AND DROP
87463 / PH11092 "REPORTING.CUSTOMREPORTS.CREATE" PLANNING ANALYTICS FOR EXCEL API FUNCTION CAUSES AN ERROR
87558 / PH11407 PLANNING ANALYTICS WORKSPACE41 -- ACTIVE DIRECTORY AUTHENTICATION -- AN UNEXPECTED AUTHENTICATION FAILURE HAD OCCURRED
87609 / PH11482 PLANNING ANALYTICS WORKSPACE 41 - MDX FAILS TO PARSE
87634 Failed to copy a child member to other parent member when Alias is active
87686 / PH11671 PLANNING ANALYTICS WORKSPACE - MONGO DB "DETECTED UNCLEAN SHUTDOWN - C:\DATA\DB\MONGOD.LOCK IS NOT EMPTY."
87687 / PH11697 TEXT PROPERTIES FOR BUTTON IN PLANNING ANALYTICS WORKSPACE DOESN'T WORK FINE FOR BOLD AND UNDERLINE
87828 / PH12030 EXPORTING FROM PLANNING ANALYTICS WORKSPACE TO EXCEL DOES NOT SHOW ATTRIBUTES.
88141 / PH13036 UNABLE TO FETCH DATA. INVALID CHAR ENCOUNTERED
 

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release and Planning Analytics Workspace Release 42.

Reference Number Description
73989 Planning Analytics for Excel report shows pending_Transactions.xlsm while this same reports works fine on PAW
87543 In Planning Analytics Workspace, error occurs when selecting a large file as a TI datasource
87422 Incorrect Memory Consumption by TM1 Server Shown in Planning Analytics Administration:
87203 PLANNING ANALYTICS ADMINISTRATION IN PLANNING ANALYTICS WORKSPACE 39 IS NOT ABLE TO CONNECT TO A TM1 SERVER WHEN THIS TM1 SERVER IS CONFIGURED TO USE A CUSTOM CERTIFICATE
87195 Secure Gateway Connection Intermittent with 2 SG Client Installations that Access to the same PA Cloud Environment
87623 When a numeric parameter is set to zero, the value is lost when re-opening the process editor.
85592 / PH06115 SELECTED ELEMENT IN DIMENSION IS NOT KEPT ONCE DRAGGING THE ITEM
87382 / PH08023 PLANNING ANALYTICS FOR EXCEL CUBE VIEWER THREADS CONTINUE TO RUN WHEN PAW PROXY TIMEOUT HAS BEEN ENCOUNTERED
87298 / PH10274 PLANNING ANALYTICS FOR EXCEL EXPLORATION - SUBSET EDITOR LOSING CURRENT SELECTION FROM CONTEXT TO ROWS/COLUMNS
87378 / PH08022 CLOSURE OF CUBE VIEWER IN PLANNING ANALYTICS FOR EXCEL DOES NOT CANCEL RUNNING THREAD
87190 / PH09881 MDX FAILS TO PARSE
87114 / PH06845 EXCEL BUTTONS DISAPPEARING IN PLANNING ANALYTICS FOR EXCEL
87188 / PH09989 PLANNING ANALYTICS FOR EXCEL 40 COLLAPSING A CONSOLIDATION IN AN ASYMMETRIC DIMENSION ERRORS
86191 / PH06978 Data entry in Planning Analytics for Excel viewer returns error
87095 / PH10133 SCROLL DOWN IN TREE IS NOT POSSIBLE IF NEW A DIMENSION AND PROCESS ARE CREATED IN PLANNING ANALYTICS WORKSPACE
86716 / PH09418 Filter does not work in Pick an element dropdown list in set Parameters dialog of an action button
87258 / PH10674 Planning Analytics Workspace view - Latency when using Conditional Formatting
86699 / PH09246 CONDITIONAL FORMATTING LOST IF CALCULATED MEMBER RENAMED IN PLANNING ANALYTICS WORKSPACE
87479 / PH11202 PLANNING ANALYTICS WORKSPACE EXPORT TO EXCEL MUCH SLOWER THAN TM1WEB EXPORT
86741 / PH09420 PLANNING ANALYTICS WORKSPACE ACTION BUTTON: SCROLL BAR DOES NOT SHOW ALL THE ELEMENTS
87214 / PH07509 PLANNING ANALYTICS FOR EXCEL GIVING UNHANDLED EXCEPTION ERROR WHEN USING REMOVE OPTION FOR MEMBER IN EDIT SET WINDOW
 

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release and Planning Analytics Workspace Release 41.

Reference Number Description
76901 System Name is changing when uploading with Planning Analytics For Microsoft Excel
82119 Tm1WebException is seen in Planning Analytics For Excel when try to logon to an environment where Planning Analytics Workspace and TM1 server are SSL enabled.
85761 [Windows 10][Edge] The date picker calendar popup is not displayed in Simplified Chinese when windows browser application language is set to Simplified Chinese
85802 Context element in the cube view does not get updated when user selects a root element in the subset editor.
85846 Dimension selector is not updated if the element chosen is a leaf element in a dynamic subset.
85861 Unable to select dimensions while doing Relative Proportional Spread in Planning Analytics Workspace
86038 User need not to be alerted if the DB resource usage spike was instantaneously only
86138 ODBC DRILL THROUGH DOESN'T RETURN ALL ROWS FROM RELATIONAL DATABASE (ONLY 60 ROWS)
86159 backup.sh creates an artifact with user/group of root
86425 Slow performance when opening a book that has multiple sheets with multiple views synchronized.
86862 TM1 INSTANCE MISSING FROM THE PLANNING ANALYTICS FOR MICROSOFT EXCEL PAGE WHEN IN STOPPING STATE
79787 / PI95612 Too many items cause slow folder navigation
85144 / PH04734 Planning Analytics Workspace local Admin tool - missing security header
85170 / PH01785 VISIBLE OR SCALABLE ACTION BUTTON PROPERTIES.
85324 / PH04985 PLANNING ANALYTICS FOR MICROSOFT EXCEL GIVING ERRORS ON CUSTOM AND DYNAMIC REPORTS
85325 / PH04603 EXCEL FLASHING WITH PLANNING ANALYTICS FOR MICROSOFT EXCEL 34 ADDIN ENABLED
85458 / PH05087 TYPE-IN REFRESH DOESN'T WORK.TWO QUICK REPORTS ARE NOT REFRESHED
85967 / PH06974 MDX UNKNOWN ERROR ERROR IN PLANNING ANALYTICS FOR MICROSOFT EXCEL
85975 / PH08109 TI process run from Planning Analytics Workspace uses data from a file used on the previous run of the same TI
85987 / PH07254 DRILL THROUGH FROM VIEWER IN PLANNING ANALYTICS FOR MICROSOFT EXCEL FAILS WITH SYNTAX
86162 / PH07092 OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT
86182 / PH06978 Data entry in Planning Analytics Workspace viewer returns error
86243 / PH02780 RUN TIME ERROR '1004' RETURNED IF THE PLANNING ANALYTICS FOR MICROSOFT EXCEL ADD ON INSTALLED ON THE EXCEL WHEN MACRO EXECUTED
86304 / PH06482 ERROR OCCURS WHEN REFRESHING PLANNING ANALYTICS FOR MICROSOFT EXCEL SHEET
86365 / PH08446 TI PROCESS EDITOR IN PLANNING ANALYTICS WORKSPACE UNABLE TO SET EMPTY THOUSAND SEPARATOR
86415 / PH07063 STRING MEASURES FORMATTED ES NUMBERS IN PLANNING ANALYTICS FOR MICROSOFT EXCEL
86451 / PH08269 PLANNING ANALYTICS WORKSPACE SHARE (DOWNLOAD) IS NOT WORKING AS SOON AS IMAGES ARE EMBEDDED INTO THE BOOKS
86517 / PH08388 INSECURE CROSS ORIGIN RESOURCE SHARING POLICY
86720 / PH09409 DRILL THROUGH DOWNLOADS ALL DATA TO 1 COLUMN IN CSV FILE
86778 / PH08878 UNABLE TO RENDER QUICK REPORTS IN A SINGLE PLANNING ANALYTICS FOR MICROSOFT EXCEL SESSION FROM MULTIPLE SERVERS
85189 / PH05794 PLANNING ANALYTICS WORKSPACE HOMEPAGE IS SHOWING GERMAN LANGUAGE IN IE BROWSER INSTEAD OF ENGLISH
87044 / PH09980 SET EDITOR IS NOT POPULATED IN PLANNING ANALYTICS WORKSPACE WHEN SUBNM HAS NO DEFAULT ELEMENT DEFINED
87142 / PH10362 PLANNING ANALYTICS WORKSPACE 2.0.39 CONTEXT DIMENSION TITLE INCORRECT AFTER CHANGING VIA SET EDITOR
86862 / PH09589 TM1 INSTANCE MISSING FROM THE PLANNING ANALYTICS ADMINISTRATION PAGE WHEN IN STOPPING STATE
83733 / PH09349 INCORRECT CPU ALERTS FROM PLANNING ANALYTICS ADMINISTRATION AT THE DATABASE LEVEL
86731 / PH09327 FUNCTION "VIEWEXTRACTSKIPCONSOLIDATEDSTRINGSSET" IS NOT WORKING IN PLANNING ANALYTICS WORKSPACE
 

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release 40.

Reference Number Description
85072 DATA GRID VIEW ERROR IN ADVANCED OPTIONS OF MIGRATED BUTTON
85400 / PH04455 OUT OF RANGE ERROR MESSAGE WHEN A USER NOT HAVING ACCESS TO MEMBERS SLICES TO AN EXPLORATION FROM POP UP VIEWER
85406 / PH04876 DIMIX FUNCTION NOT WORKING AS EXPECTED IN PLANNING ANALYTICS FOR EXCEL
85564 / PH06034 FOCUS GETS LOST WHEN DELETING OR RENAMING ANY ITEM. WITH CTRL+M AND T YOU GET BACK INTO TREE, HOWEVER YOU CANNOT MOVE UP/DOWN
85816 / PI99514 ONCE PLANNING ANALYTICS FOR EXCEL IS CONNECTED, THE CONTEXT MENU KEY ON KEYBOARD IS DISABLED
85887 / PH06614 OPEN PLANNING ANALYTICS FOR EXCEL WORKBOOK AND SELECT OPEN FOLDER AND THEN SELECT UP ONE LEVEL
85890 / PH06006 UNABLE TO COPY/PASTE VALUE TRUE/FALSE IN QUICK REPORTS
85996 / PH06658 DBSS DOES NOT WORK IN PLANNING ANALYTICS FOR EXCEL AS IT DID IN PERSPECTIVES, WHEN CONNECTED TO TWO TM1 SERVERS
86009 / PH06842 RUNNING A FAILED TI PROCESS FROM ANOTHER TI PROCESS REPORTED THAT THE PARENT PROCESS SUCCEEDED USING ODATA REST API
86010 / PH05404 DBRW FIELD SHOWING #VALUE AFTER RUNNING TI FROM ACTION BUTTON IN
86068 / PH06635 SLOW PERFORMANCE ON A PLANNING ANALYTICS FOR EXCEL TEMPLATE
86069 / PH06117 DIMIX CELLS NOT UPDATING CORRECTLY USING REFRESH IN PLANNING ANALYTICS FOR EXCEL
86181 / PH06715 CUSTOM REPORT IN PLANNING ANALYTICS FOR EXCEL DISPLAYS #VALUE!
86235 / PH06795 JAPANESE ALIAS IS NOT DISPLAYED. INSTEAD, THE ORIGINAL ELEMENT NAME SHOWN
86238 / PH06770 AFTER INSTALLING PLANNING ANALYTICS FOR EXCEL, THE EXCEL SPREADSHEET IS NOT WORKING IN MS WORD
 

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release and Planning Analytics Workspace Release 39.

Reference Number Description
75844 Corrupted extra characters are shown in cube File Import dialog
83733 Planning Analytics Administration: CPU Alert Is Sent Out to Client For CPU Usage Which Is Service Related Not TM1 Related On the Data Tier
84408 Set editor and have drilled down on the left, change Aliases, and the left hand side returns to parent level
84511 / PH03391 BAD PERFORMANCE IN OPEN A DIMENSION IN PLANNING ANALYTICS WORKSPACE COMPARED TO PLANNING ANALYTICS FOR EXCEL
84975 / PH04395 LARGE PLANNING ANALYTICS WORKSPACE CROSS TABS WITH A LOT OF COLUMNS ARE NOT SHOWN CELL DATA PROPERLY - CELLS ARE EMPTY
84976 / PH04399 SELECTING A CELL IN A LARGE PLANNING ANALYTICS WORKSPACE REPORT IN IE 11 - JUMPS BACK TO THE BEGINNING OF THE CROSS TAB
85021 If the private Default set is selected from the set list in the left pane of the set editor, the left member pane shows the members from the public Default set.
85029 / PH04668 PH04668 ONLY FIRST CHART CAN BE SHARED AND DOWNLOAD
85220 / PH05153 APAR 137283: PH05153 PLANNING ANALYTICS WORKSPACE BOOKS NO LONGER RENDER IN 2.0.37 - ERROR HTTP 409 THROWN *
85266 Search in Set Editor returns multiple results of the search parameter from all hierarchies
85340 / PH04408 SORTING IN PLANNING ANALYTICS WORKSPACE HANGS PA ENVIRONMENT
85409 / PH05811 INCORRECT CSV FORMAT OF DRILL-THROUGH RESULTS IN PLANNING ANALYTICS WORKSPACE
85426 / PH05402 CREATING A NEW BOOK OR OPENING AN EXISTING ONE TAKES TOO LONG
85617 / PH06217 ERROR WHEN TRYING TO PASTE TEXT CELLS ACROSS DIFFERENT LEVELS IN A HIERARCHY
85632 / PH06069 THE THREAD TO GET THE RESULTS FOR NLP TAKES REALLY LONG TO COMPLETE
85641 SUBNM formulas lose the named set and get cleared when Synchronization is enabled.
85690 WHEN USING IE VS CHROME. THE DOWNLOAD IN PDF DOESN'T LOOK THE SAME AS THE WORKSHEET
85790 / PH06735 IN PLANNING ANALYTICS WORKSPACE, IF DRILL THROUGH TI PROCESS FAILS, THERE IS NO UI MESSAGE TO A WORKSPACE USER THAT IT FAILED AND WHY.
83952 Planning Analytics Workspace - Top 10 filter error (timeout) does not stop thread
85826 Planning Analytics Workspace doesn't allow the update of element attribute using a dimension editor if there is a picklist defined for the attribute
85910 If any of the elements in a selection widget are deleted in the TM1 cube, an error is thrown in the widget and widget gets disabled on clicking OK.
86027 / PH07450 HIERARCHY FAILS TO EXPAND IN PLANNING ANALYTICS FOR EXCEL VIEWER CAUSING LONG RUNNING THREAD ON SERVER
80052 Message from Planning Analytics for Excel Action button/process determined without sheet refresh
80944 Unable to see a workbook saved with special characters within Planning Analytics for Excel
82824 / PH05266 Dynamic report - rebuild sheet not working on first open of MS Excel
83429 Copy/paste from Excel with Planning Analytics for Excel ribbon selected loses precision in Planning Analytics for Excel 34 and 35
83547 / PH01106 Error when editing nested row when calculation is present
84399 / PH03033 ACTIVATING SHEET STARTS UNNECESSARY CALCULATIONS.
84727 / PI99548 PLANNING ANALYTICS FOR EXCEL 33 DBSW DOESN'T UPDATE ALL COLUMNS AS EXPECTED
84938 / PH04392 PASTE SHORTCUT (CTRL + V) DOES NOT WORK ON PLANNING ANALYTICS FOR EXCEL TAB WHEN IMAGE COPIED TO CLIPBOARD ON OTHER BOOK
84940 / PH03912 PLANNING ANALYTICS FOR EXCEL CONNECTION TO TM1 CHANGES CLIPBOARD BEHAVIOR
85022 / PH02862 DBS NOT SENDING VALUES TO THE DATABASE AS EXPECTED IN PLANNING ANALYTICS FOR EXCEL
85023 / PH03863 SUBNM AND DBRA FORMULAS ARE NOT REFRESHING CORRECTLY WHEN CONNECTED TO TWO TM1 SERVERS
85117 / PH03420 PARTLY PROTECTED SHEETS LOSE DBRW FORMULAS ON PROTECTED CELLS IN PLANNING ANALYTICS FOR EXCEL
85325 / PH03420 EXCEL FLASHING WITH PLANNING ANALYTICS FOR EXCEL 34 ADDIN ENABLED
86497 / PH07962 CHANGING PARAMETERS IN PLANNING ANALYTICS ADMINISTRATION ERASES MTQ = ALL
86391 / PH07956 CHANGING THE PARAMETERS IN PLANNING ANALYTICS ADMINISTRATION DOESN'T CREATE A BACKUP OF TM1S.CFG FILE
83733 Planning Analytics Administration: CPU Alert Is Sent Out to Client For CPU Usage Which Is Service Related Not TM1 Related On the Data Tier
82082 Planning Analytics Administration 'Internal error with the database. Please try again later" message returned for some TM1 instances
80765 Expiration token can't be updated
73544 For database alerts, Event>Memory Usage, the memory usage calculation appears to consider 1 gb as 1 %.
85240 / PH02945 BUTTON LINKS TO OTHER BOOKS DO NOT MIGRATED IN PLANNING ANALYTICS WORKSPACE
 

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 38.

Reference Number Description
80765 Expiration token can't be updated
82824 Dynamic report - rebuild sheet not working on first open of MS Excel
83627 Unable to completely cancel a Commit happening in Quick Reports
83853 Unable to Authenticate to a 2nd CAM secured TM1 server behind the same Planning Analytics Workspace host
84511 / PH03391 BAD PERFORMANCE IN OPEN A DIMENSION IN PLANNING ANALYTICS WORKSPACE COMPARED TO PLANNING ANALYTICS FOR MICROSOFT EXCEL
84544 / PH03385 PLANNING ANALYTICS FOR MICROSOFT EXCEL ACTION BUTTON PASSING PARAMETERS TO ANOTHER WORKBOOK FAILS
84574 / PH03355 Users are trying to create a Quick Report and getting the following error: "Object reference not set to an instance of an object" 
84590 / PI99286 PLANNING ANALYTICS FOR MICROSOFT EXCEL: MAKING MULTIPLE COPIES OF QUICK REPORT SHEETS AT ONCE CAUSES THEM TO LOSE CONNECTION TO TM1 AND BECOME STATIC
84606 / PH03245 PLANNING ANALYTICS FOR MICROSOFT EXCEL: DRILL THROUGH OPTION IS NOT ENABLED FOR DYNAMIC OR CUSTOM
84646 / PH02462 PLANNING ANALYTICS FOR MICROSOFT EXCEL SHEET IS GETTING CORRUPTED SHOWING PENDING IN TM1RPTEROW
84860 / PI96178 MULTI-TABBED REPORT IN PA FOR EXCEL DOES NOT REFRESH AS EXPECTED.
84576 Detailed Error Messages Revealed in Planning Analytics Workspace
84584 Navigation button links to other books are not migrated properly
85090 / PH05607 Snapshots saved from Create snapshot screen do not appear in Manage snapshots screen

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 37.

Reference Number Description
79654 Corrupt view in Planning Analytics Workspace that doesn't suppress zero
80460 Planning Analytics Workspace: Share Email content can be tampered
82214 User Report is Unable to Drill Down More than Two Levels
82366 PLANNING ANALYTICS WORKSPACE: General Style --> Fill/Border Colors not working for Dimension Selector
82843 / PI96185 PLANNING ANALYTICS FOR MICROSOFT EXCEL CELLS DO NOT REFRESH CORRECTLY USING PA FOR EXCEL REFRESH. THE FORMULA REFRESHES CORRECTLY IF DONE INDIVIDUALLY.
82967 Rename an element and then removing it via the context menu is not working
83198 DIMIX will return #VALUE when defined over a large number of cells
83337 PLANNING ANALYTICS WORKSPACE: TI process fails but in UI it says succeeds
83593 PLANNING ANALYTICS FOR MICROSOFT EXCEL 34 - FORMAT AND FORMULA LOST
83608 / PH01327 IN PLANNING ANALYTICS FOR MICROSOFT EXCEL IN ADVANCED OPTIONS WINDOW THERE IS NOT A SHORTCUT OR KEY COMBINATION TO DELETE ROWS
83615 / PH01326 IN PLANNING ANALYTICS FOR MICROSOFT EXCEL IN ADVANCED OPTIONS WINDOW THERE IS NOT A SHORTCUT OR KEY COMBINATION TO SORT THE COLUMNS
83660 / PH01182 PLANNING ANALYTICS FOR MICROSOFT EXCEL EXPLORATION : CANNOT DRILL DOWN A NESTED CELL WHEN SUPPRESS ZEROS ENABLED
83777 / PH01795 DOCUMENT STEPS TO UNINSTALL PLANNING ANALYTICS WORKSPACE WILL UNINSTALL MORE THAN ONLY PLANNING ANALYTICS WORKSPACE
83865 / PH02213 ERROR OPENING EMBEDDED WEBSHEET FOR FIRST TIME WHEN USING INTEGRATED LOGIN WITH PLANNING ANALYTICS WORKSPACE.
83866 / PH02189 PLANNING ANALYTICS WORKSPACE WITH CAM SECURITY RESULTS INTO AN ERROR 401 - UNABLE TO FETCH DATA FOR CONTENT TREE
83891 Process, Dimension and Setting Editors are always appearing when selected, even if another object is placed on top of them in top order to display.
83952 / PH02657 Planning Analytics Workspace - Top 10 filter error (timeout) does not stop thread
83978 / PH02392 SINCE PLANNING ANALYTICS WORKSPACE 2.0.35 : PERFORMANCE DEGRADATION WITH CONDITIONAL FORMATTING
80460 Planning Analytics Workspace: Share Email content can be tampered
84027 / PH02166 PLANNING ANALYTICS WORKSPACE 35 CONSOLIDATION TYPE IN SPREADING SET TO DENY DOESN'T PREVENT COPY AND PASTE INTO CONSOLIDATED CELLS
84055 / PH00142 PERFORMANCE DEGRADATION ON ANY TYPES OF EXCEL FILES IF PLANNING ANALYTICS FOR EXCEL TAB HAS BEEN ACTIVATED EVEN ONCE
84319 Process, Rules and Chore modeling widgets are not lazy loaded if they exist on other tabs in the book.
84375 / PH01039 CREATE NEW VIEW FROM JAPANESE CUBE USING PLANNING ANALYTICS FOR EXCEL, ERROR OCCURS WHEN SAVE FIRST VIEW.

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 36.

Reference Number Description
80032 / PH00413 Improve scrolling of the overview bar to be element by element instead of page by page
81470 ProportionSpreadToZeroCells to False is not working as expected on Planning Analytics Workspace
81677 Planning Analytics Workspace synchronization of subsets; subset not updating correctly
81731 Planning Analytics Workspace Indent option doesn't work when Subset is set to "Showing Totals Trailing"
81822 Planning Analytics for MS Excel cannot resolve Excel Left function whose target cell is a DBRW
81978 Data Spread not working when applying a Hold while using Alternate Hierarchies
82026 Planning Analytics for MS Excel Task Pane is grey after login. No cubes or dimensions are displayed.
82107 Planning Analytics Workspace importing data into a cube by the drag and drop method fails "file cannot be parsed" for one file
82695 Planning Analytics for MS Excel indicating user is connected in task pane and drop down even though they have disconnected
82705 / PI99643 CANVAS OBJECT SHOWS INCORRECT VALUE WITH ITALIAN BROWSER LANGUAGE SETTINGS
82732 Object reference error using spreading when DBRW formula contains a variable
82780 Planning Analytics for MS Excel continues to run Workbook / Worksheet Activate logic every time a workbook is activated instead of caching state
82814 / PI99750 More than 2 Admin Host Server entered in the Planning Analytics Workspace configuration - not all cubes are visible in Planning Analytics Workspace
82824 Dynamic report - rebuild sheet not working on first open of Excel
82828 Planning Analytics for MS Excel rebuild sheet causing exponential Excel memory growth
82958 "Insert" button is not displayed on "Add related hierarchy" if there are too many hierarchies
83052 Sandbox in Planning Analytics Workspace Websheet auto-commits to all sandbox and base upon entry in 1 of the sandboxes
83097 Cannot export to Excel views with Korean characters in name
83125 / PH02712 Changes in Private View not save if done in Rows
83136 Syntax error is shown when multiple variable assignment statements happen on the same line
83144 Wrong selected element in context dim is appearing after saving view in Exploration
83147 Changing alias in a particular exploration dimension causes unexpected behavior
83173 / PI99209 ERROR APPEARED WHEN DIMENSION SWITCHED IN THE EXPLORATION ROW
83199 / PH00752 Autocomplete HTML Attribute Not Disabled for Password Field
83216 / PH00753 Missing or insecure Cross-Frame Scripting Defense
83217 / PH00754 Missing or insecure "X-Content-Type-Options" header
83218 / PH00756 Missing or insecure "Content-Security-Policy header
83219 / PH00757 Missing or insecure HTTP Strict-Transport-Security Header
83447 HResult error when opening a Cognos Analytics for MS Excel sheet in Planning Analytics for MS Excel 34
83514 Unable to open a view in Planning Analytics for MS Excel 34
83517 Edit Set is pointing to an incorrect dimension in Planning Analytics for MS Excel after an upgrade from Cognos Analytics for MS Excel
83620 / PH01711 PROXYTIMEOUTSECONDS IN PLANNING ANALYTICS WORKSPACE DOES NOT WORK AS EXPECTED
83733 Planning Analytics Administration: CPU Alert Is Sent Out to Client For CPU Usage Which Is Service Related Not TM1 Related On the Data Tier
84013 / PI98739 Planning Analytics for MS Excel doesn't fire off a DELETE on the cellset when the cancel button is clicked for Explorations with a row limit set

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 35.

Reference Number Description
50920 Planning Analytics Workspace: Exploration value sorting is not preserved in visualization
81118 Planning Analytics for Excel viewer does not show CubeName and Database name
81263 / PI97493 APPLICATION FILES STORED AS REFERENCE ARE NOT CORRECTLY UPGRADED
81522 / PI97014 EXPLORATIONS DO NOT WORK IF TASK PANE IS UN-DOCKED
81630 Planning Analytics for Excel viewer does not show CubeName and Database name
81668 CHARTS NOT REFRESHING AFTER LIFECYCLE MANAGER SNAPSHOT IS MIGRATED TO DIFFERENT TM1 SERVER
81669 NO ASSET IMPORTED FROM SNAPSHOT IF BROWSER LANGUAGE SET TO FRENCH

81699 / PI97087

Planning Analytics Workspace:  Copy and Paste when Suppress Zero (measure)

81670  / PI95955

MIGRATE ASSETS: UNABLE TO FETCH HIERARCHY MODEL DATA. 
81732 Planning Analytics Workspace doc help doesn't show in IE
81800 Getting unable to fetch data for content tree once drilling into a dimension member with a special character

82020 / PI98819

CLEAR THE LEVEL FILTER SETTING AND RESULT BY PRESSING 'CLEAR' BUTTON, THEN EXECUTE FILTER BY NAME STILL EXECUTE FILTER BY LEVEL
82049 /  PI98570 Drill through on blank cells doesn't work on quick reports and explorations
82052 / PI98674 REFRESH SHEET,  UNHIDES HIDDEN COLUMNS IN EXPLORER VIEW AND REMOVES ALL THE FORMAT CHANGES
82066 / PI98880 PUBLISH FILE TO PRIVATE FOLDER USING 'ADD FILE REFERENCES' DOES NOT STORE FILE SHORTCUT TO FOLDER
82068 / PI98968 Members/Levels doesn't expand if cube has alias name
82164 Filebeat is causing the tm1server.log to grow to a huge size and can't be deleted until filebeat is stopped.
82242 / PI98674 Planning Analytics Workspace -local cannot handle requests with headers > 8KB
82303 Text added to cells in inserted column or row in PA for MS Excel overwritten with dbrw formula
82556 Applying conditional formatting to nested attributes causes incorrect formats

Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 34.

* APAR or Defect fix was confirmed after the fix list was initially published.

Reference Number Description
75168 Poor performance of Planning Analytics Workspace using IE 11 compared to other browsers such as Chrome
75428 Planning Analytics Workspace 29 Text type attribute filter list not loading
76761 Drag and drop into a dimension does not work on Local install
76879 / PI95867 * Unable to logout from Planning Analytics Workspace Local _WIN2016
77430 Execute MDX process building View doesn't end if executed in Planning Analytics Workspace but is ok in Architect
77939 Drill Thru from Planning Analytics Workspace hangs on a second drill view event
78891/ PI95809 Planning Analytics Workspace Suppress zeros doesn't work when selecting SUM with nested dimensions
79804 Planning Analytics Workspace users cannot load the content of their tabs after being idle for a period of time
80079 Book shared as PDF/Image is missing spaces from Title Text
80183 Planning Analytics Workspace workbook freezes for end users
80336 Planning Analytics Workspace- unable to swap columns with context dimension : Unable to modify the view hierarchy
80459 Planning Analytics Security (Planning Analytics Workspace): Share Email function is vulnerable to CSRF and Replay attack
80460 Planning Analytics Security (Planning Analytics Workspace): Share Email content can be tampered
80461 Planning Analytics Security (Planning Analytics Workspace): Information leakage from error messages
80702* Too many HTTP calls when opening a complex workbook leading to slow performance
80721 Planning Analytics Workspace text and numbers in row are not aligned in the table
80807 Planning Analytics Workspace Exploration view not automatically changing members based on subset
80887 Cannot add a dimension as a selector widget to the canvas with view and synchronization enabled
81133 / PI97747 Trace Cell function not returning correct result when the cell includes reference to multiple hierarchies
81295 Planning Analytics Workspace synced dimensions with an alias lose the alias when drill down occurs in visualization
81342 Attribute query in set editor leading to recursion error
81402 Charts failing with error after upgrading to Planning Analytics Workspace 33
81406 [Canvas] Show Totals Trailing not rendering correctly
81461 Planning Analytics Workspace TI editor removes variable labels when changing file source
81491 TM1 Server Monitor doesn't work the way Control Page used to
81496 TM1 Servers Stopped in Planning Analytics Administration Now No Longer Appear in Planning Analytics Administration and After Restarted Directly on the Data Tier Appear With Threads Blocked: Unavailable
81661 Secure gateway: Create DSN fails
81774 TM1 instance is crashing when sorting column on Planning Analytics Workspace
82025 Planning Analytics Administration showing database as started when it is stopped in IE
78787 Planning Analytics for Excel 30 is losing the format of C Elements when using TM1RPTFILTer function in a dynamic Sheet
79283 Large Workbook with Quick Reports throws Error when Opening in PAx
80790 DIMENSION ELEMENT (CALCULATION): MEMBER ALREADY EXISTS (RTE 94)
80957 Quick reports lose functionality when moved to a new workbook in Planning Analytics for Excel
81026/ PI97778 PLANNING ANALYTICS FOR EXCEL IS NOT SHOWING CHILD MEMBER FOR A DIMENSION
81250 After saving view in Planning Analytics for Excel, MDX saved with unnamed set with expand Above causes indent to to be lost on re-opening the view and going into the set editor
81360 Set editor is blank after a double click launch from a SUBNM
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 33.

* APAR or Defect fix was confirmed after the fix list was initially published.
Reference Number Description
80736 Exiting the SetEditor after expanding an element and returning to an exploration is spawning a long running thread
80551 Unable to connect with Planning Analytics for Microsoft Excel 2.0.31 or 2.0.32
80249 Long running threads seem to be being spawned by few users that are running Planning Analytics for MS Excel 31 reports
79436 The element name in Planning Analytics for MS Excel does not change when I use the alias swap command in Turbo Integrator
78852 Planning Analytics forMS Excel: Long running TI processes executed via Action Button returns a "Process Failed" message after 300 seconds
PI96773 Unprotected SUBNM cell asks for unprotected sheet password
PI97115 SWITCHING SHEET CAUSE TIME DELAY TO ACTIVATE SHEET IF THEY CONTAIN DBRW FUNCTION
71715 Planning Analytics Workspace: Cubeview refresh when dragging vertical scrollbar is poor (IE only)
80406 Planning Analytics Workspace: Expanding drill through window does not react to the resize before it is rendered
80334 Drill through grid, unable to perform a search on a picklist or enter text in text popup
80118 Drill through issue with Subset and '}'-prefix
78186 Consolidated element^Leaf element":member not found (rte 81) In Planning Analytics Workspace
77610 Unable to open Cube Views when placed under the Applications folder in Planning Analytics Workspace
73913 Planning Analytics Workspace Export to PDF or Powerpoint function in planning analytics dropping parts of graphics
77660 Planning Analytics Administration is not sending an email alert for memory usage despite the limit being exceeded
PI96188 'ERROR' WHEN TRYING TO SEARCH ON AN ELEMENT IN AN MDX SUBSET IN PLANNING ANALYTICS WORKSPACE
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 32.

* APAR or Defect fix was confirmed after the fix list was initially published.
Reference Number Description
73738 Error Failed to toggle "Show Totals" Mode. [Cube, State]
75688 Planning Analytics Workspace Export to Image, PDF, PPT and Excel only works with non-English names
77445 After a synchronize dimensions in a view, the whole view gets empty without error
78785 Unable to export Planning Analytics Workspace content to Watson Analytics due to certificate issues.
78908 Planning Analytics Workspace generate Member already exists (rte 94) when admin create a member in Planning Analytics with the same name as the user created calculation member.
79392 Unable to perform a CTRL C or copy of a cell on a Relational Drill through window
79417 Font in widgets changes sizes when focus moves away and back
79618 Planning Analytics Workspace selector widget issues
77900 Planning Analytics Workspace - At opening dimension there is an error "toIndex =1"
76788 Planning Analytics Administration Alerts don't work for Threads waiting and Threads in run state
PI92173 PA-GATEWAY ERROR: MAKES PLANNING ANALYTICS WORKSPACE UNAVAILABLE
79274 Unable to export data from Planning Analytics to Watson Analytics
PI93870 UNABLE TO UPGRADE EXISTING PLANNING ANALYTICS WORKSPACE LOCAL INSTALL TO PLANNING ANALYTICS WORKSPACE 29. PLANNING ANALYTICS WORKSPACE DOES NOT START.
73989 Planning Analytics for Excel report shows pending_Transactions.xlsm while this same reports works fine on PA Workspace
PI94092 [Hierarchies, Alias] Non-default hierarchy alias is not displayed in tree
77017 Planning Analytics for Excel MDX Exploration created websheet displays elements out of order compared to Architect
77708 Drill through doesn't work fine if you have 2 dimension in row or column
PI94924 If an element moves and the cached reference has become invalid during the Excel session, no visible error message is returned to the user on refresh even though the QR did not update
77912 Annotations not working as expected in Planning Analytics for Excel
77982 Edit elements manually in cell in context area of Dynamic Report does not automatically refresh sheet
78047 Multiple SUBNM`s dropdown lists in Planning Analytics for Excel not working as expected
78108 Planning Analytics for Excel Action button not running on TI merged cell parameter
78125 No drop down for picklist cell in Planning Analytics for Excel
PI92939 FILTER TREE OPTION IN PLANNING ANALYTICS FOR EXCEL DOESN'T WORK WITH DIMENSIONS HAVING MULTIPLE HIERARCHIES
78361 Entering a value in a cell takes longer time to complete in Planning Analytics for Excel
79073 Drill through in Planning Analytics for Excel does not show the correct drill processes
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 31.

* APAR or Defect fix was confirmed after the fix list was initially published.
Reference Number Description
PI90914 SPREAD DATA FROM CONSOLIDATED CALCULATED CELLS
PI90925 SUBNM using a cell reference from the result of another subnm is not displaying the same output
PI91003 Consolidations in context do not reflect the same format in Planning Analytics for Excel as Planning Analytics Workspace Subset Editor Totals Trailing Reversed when cell security is configured
PI91525 Attribute header text color matches background in blue table style
PI92785 Unable to search for Metadata in Planning Analytics for Excel from 'DIMENSIONS' section
71408 Unable to open Set Editor when non-admin user has none access to all members of a dimension in the 1st cube of the server
71882 Planning Analytics Workspace: unable to perform a cube to cube drill through
73479 Convert to static subset not working from Definition View
74561 Refresh does not update Canvas Summary View widget after data is updated via process
74563 Dynamic unnamed set becomes static and member ID is selected after view is saved with alias
75202 Planning Analytics for Excel Subset Editor Totals Trailing Reversed
75550 Performance degradation in Planning Analytics for Excel when switching worksheet tabs and closing workbook
75572 Planning Analytics Workspace Wrapped Text in TI Process does not work
75598 Logon Box keeps popping up in Planning Analytics for Excel
75963 Date incorrectly displayed in Planning Analytics for Excel version 2.0.29.10
76441 Issue with editing multiple cells (Control+Enter)
76522 Large Workbook with Quick Reports not Connected after Published and Opened
76811 Planning Analytics for Excel: Indentation in Set Editor lost after opening a saved view as a new Exploration
76865 Issue with DNEXT amd DFRST functionality in Planning Analytics for Excel
76895 Error when logging into Planning Analytics for Excel ", hexadecimal value 0x01, is an invalid character. Line 1, position 1."
77340 Converting sheet or book to Snapshot is locking up Excel in Planning Analytics for Excel
77470 Performance issues after upgrading from CAFE
77702 List of drill not available in Drill through in Planning Analytics for Excel only
77745 Saved views in Planning Analytics Workspace corrupted after last Planning Analytics Workspace upgrade
77211* Data Source Name empty in Architect when creating process from Planning Analytics Workspace
77212* New processes created with Planning Analytics Workspace with a cube as a datasource are not accessible via Architect
77213* Getting error "EOF reached before encapsulated token finished" when using some file as datasource comma separated
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 30.

* APAR or Defect fix was confirmed after the fix list was initially published.
Reference Number Description
PI84962 Planning Analytics for Excel automation does not work with logon
PI84997 Planning Analytics Workspace becomes inaccessible due to looping Welcome Page
PI87457 [Hierarchies, Alias] Non-default hierarchy alias is not applied in Planning Analytics for Excel working area and selecting alias incorrectly applies
PI87737 * Cannot search in Subset Editor - Planning Analytics Workspace / Planning Analytics for Excel
PI89462 * Top or Bottom filter applied to zero supression on view takes much longer to render view
PI90440 Large thread/user counts in PM Hub
PI90721 Planning Analytics for Excel error when server name is referenced
PI90914 Not possible to spread data from consolidated calculated cells
PI91139 Wrong dropdown elements populated in dimension cell
PI91736 Turkish environment, uploaded file in application does not display in Planning Analytics for Excel
PI91878 Planning Analytics for Excel Set Editor does not apply element attributes
28577 #VALUE! errors are seen when rebuilding an active form in a protected worksheet
69808* Planning Analytics Workspace Calculations is not working on multiple hierarchies
72660* Attempting to logon to a tenant where a userID has not access to results in a non helpful error condition, white screen looping, etc
73658 SUBNM not working as expected for Planning Analytics for Excel
74177 Incorrect Hierarchy being Referenced on Commit (System.Exception: 'All Countries' can not be found in collection of type 'Element')
74426 Planning Analytics Workspace dim selector blank on load if no user permissions
74561 Refresh does not update Canvas Summary View widget after data is updated via process
74650 Depending on TM1 format on member, comma mistaken as a Period when pasted into Planning Analytics Workspace
74946 Scrolling of crosstab is very choppy and slow
74983 Unable to "Insert Calculation" when you have more than 10 rows selected
74995 Planning Analytics for Excel - Selected DBRW is not being passed to target sheet via Action Button
75035 Planning Analytics Workspace not consistently using localization
75226 Edit Set in context area of Dynamic Report does not automatically refresh sheet
75271 Alias elements are not showing up in Planning Analytics for Excel Explorations or Quick Reports
75417 Planning Analytics Workspace: CCL Runtime error Argument is not a legal value
75488 Planning Analytics Workspace Drill through hangs when we go in to the detailed drill view the second time
74426 Planning Analytics Workspace dim selector blank on load if no user permissions
74561 Refresh does not update Canvas Summary View widget after data is updated via process
74650 Depending on TM1 format on member, comma mistaken as a Period when pasted into Planning Analytics Workspace
74946 Scrolling of crosstab is very choppy and slow
75035 Planning Analytics Workspace not consistently using localization
75417 Planning Analytics Workspace: CCL Runtime error Argument is not a legal value
75488 Planning Analytics Workspace Drill through hangs when we go in to the detailed drill view the second time
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 29.
Reference Number Description
PI88816 Planning Analytics for Excel Changes sheet font to Calibri
42464 DBSA formula does not return consistent values when it refers to empty strings/cells or missing arguments
67963 Invalid DBSW formulas (due to missing dimensions) cause valid DBSW formulas to fail
70175 Set editor only returns one hierarchy when performing a search
71096 Drill Through's from Planning Analytics Workspace to External Data sources fail for non-admin users
71130 Unable to open Set Editor when non-admin user has none access to all members of a dimension in the 1st cube of the server
71328 Dynamic Report created from an exploration with non-named dynamic subset created from Subset editor does not work
72163 Planning Analytics Workspace: Unable to render bar and column chart visualizations as a non-admin user
72283 Planning Analytics Workspace #N/A result from consolidated-level expression in alternate hierarchy
72585 Architect default currency format causes calculation format to be incorrect
72809 Unable to export cubeview to Excel if the user has non-admin permissions in TM1
72966 The button to export the user account list has disappeared
73453 Planning Analytics users cannot change a visualisation of a workbook with 'view and edit' right to that workbook
73481 "Object reference not set to an instance of an object" error throw when opening a cube view with no open/blank workbook
73753 Planning Analytics for Excel Trying to remove columns on asymmetric axis not working as expected
73881 Convert to static subset not working when set editor is opened in Definition View
73939 Set Editor issue when sheet protection is enabled in Planning Analytics for Excel
73996 Available members "Set" should reflect all members established via Filter Query or Right Mouse Click Actions (like Drill Down and Show All Ancestors)
74006 Planning Analytics Workspace 27 Manual refresh required to apply conditional formatting when a dimension is moved from context to row/column
74092 The Planning Analytics Administration option "Download logs" is not respecting the TM1 server configuration parameter LoggingDirectory
74353 Trace Cell feature in Planning Analytics Workspace does not handle continue statements
74754 Planning Analytics for Excel: Deleting over 6000 rows from a report causes Excel to lock up
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 28.
Reference Number Description
68973 When saving a rule in Planning Analytics Workspace the content tree disappears
69129 Unable to expand more than 2 levels with Planning Analytics Workspace when there are multiple hierarchies and an element with no children is expanded
70768 Excel crash when drilling down into dimension on dynamic report
70959 Workbook causes Planning Analytics for Excel to spike in memory usage and hang
70983 Unable to copy and paste into a cell with a pick list
71291 TM1 - Unable to edit set after upgrading workbook from 10.3 to the latest 2.0 version if there is a dimension contains &
72407 Planning Analytics Workspace: Error: Some Data Items Used In This Visualization Are Unavailable
72616 Unable to add multiple calculation for the same set of columns using subset with low level
72733 Double scroll bars within the cube viewer when browser zoom at 67%
73210 Change Visualization cube view tool button doesn't open visualization option time to time on Saved Planning Analytics Workspace book
73483 Poor performance for Planning Analytics for Excel dynamic view
73688 TM1 - Opening any workbook taking very long if Planning Analytics for Excel addin loaded
73778 Right click when multiple columns are selected causes the spread sheet to lag heavily
PI85345 DBs with multipass composite for value argument causes bucket failure
PI85345 IBM Planning Analytics for Excel unexpected and unreliable DBR
PI87405 Copying a Quick Report on it to a new workbook causes the report to become static
PI87734 Planning Analytics for Excel exploration view gets reset
Issues corrected in IBM Planning Analytics 2.0 Release 16.
Reference Number Description
PI74930 Error in cell widget when opening a saved book by a non-admin user with no rights to some of the elements of the context
57862 Information\Error Banners are stacked and require multiple clicks to clear
Issues corrected in IBM Planning Analytics 2.0 Release 17.
Reference Number Description
PI76407 Can't open Members below or slice from viewer to Excel if there is an element name with a forward slash in it ("/")
61434 Synchronization lost in Workspace if Dimension and Cube View are removed and re-added to Sheet
61553 Explorations saved with a 'blue theme' will not open with the Overview Bar showing when saved with the Overview Bar closed (whether they are an exploration or a chart)
61566 Workspace language defaults to DE if Accept-Language is not supplied in IE session
Issues corrected in IBM Planning Analytics 2.0 Release 18.
Reference Number Description
PI71228 ERROR FOR SAP BW INFOQUERY WHEN OPTIONAL PROMPT IS NOT FILLED
PI74286 COR-ERR-2017 THE CURRENT SELECTION DID NOT RETURN ANY DATA
PI74490 Macro Login
PI75623 EXPAND ABOVE SET IN ARCHITECT DOES NOT WORK AS EXPECTED IN PA FOR EXCEL
PI76405 ELEMENT CONTAINING A SLASH IS NOT BEING ADDED TO THE CURRENT SET
PI76446 COPY/PASTE LOSES FORMULAS AFTER ONE PASTE WITH PA FOR EXCEL ADD-IN ENABLED
PI76654 PA for Excel - DBS DBSW DBSS FORMULA NOT WORKING WHEN OVERWRITING EXISTING DBRW
PI77139 UNABLE TO DEFINE SUBNM FORMULA WITHOUT A SUBSET IN THE FORMULA
PI77547 Multiple Metadata Tree panes open for some users
47906 Picklists do not appear on DBR cells (work on DBRWs)
52139 Install finishes with Errors
54028 No data visible after refresh of flexview when caption defined as type Text on dimension and use in a cube view
55325 Missing spread options when an Element contains a simple C: level rule
55714 Excel calculated valued not recognized in DBRW reference
55774 DBSW not working on the whole worksheet when at least one cell is rule calculated
56854 Zeros formatted as percentages show up blank
58368 Receive an error when clicking on the drill up option on the column dimension
59998 Elements not found in the subset editor with dynamic subset
60874 Project Dimensions "Available Members" not in Sync with "All Projects"
61039 Convert to Static doesn't work correctly with Filters on
61140 TM1RPTRow function with "" parameter that worked in Perspectives fails in PA for Excel
61321 One Level Up button not working
61479 Recalc results in RECAL_0_n with non admin user
61508 'Unexpected content in token' error is seen when running a process to create a cube from TM1 view
61807 TM1RPTRow function with MDX formula that worked in Perspectives fails in PA for Excel
61816 Filter with multiple TM1RPTROws in the report works if you only have a single column dim referenced but not if you need 2
61822 Upgrade action buttons freezes Excel if regional settings are in French
61830 DIMNM formula doesn't work correctly in PA for Excel with a User with Restricted Elements Access
62092 If a DBRW errors in the report, then a valid DBRW fails as well
62314 When PA for Excel Plugin is Installed, the Right-Click > Delete Option Does not Work
62356 Picklist does not appear on a DBRW if there is a TM1User function in a parameter
62359 Overwriting a view does not work without closing Excel
62535 Dynamic report multipass dependency in tm1rpttitle fails to calculate on refresh
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics Workspace Release 19.
Reference Number Description
62243 Tenant Selector crops long tenant names
63102 When a dark theme is selected, the Dimension Selector displays white elements on top of a white background
63685 Properties do not update when grid is selected
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics Workspace and Planning Analytics for Microsoft Excel Release 20.

* APAR or Defect fix was confirmed after the fix list was initially published.
Reference Number Description
53133 Member names with square brackets is not recognized by PA for Excel and cannot be applied from Set Editor
54886* Private subset not populated in CAFE crosstab
59636 TI process - 'Pending' remains after selecting 'Clear completed'
62083* TM1User is returning the alias value in PA for Excel and has always returned the root element in Perspectives and TM1 Web
62338* Unable to use renamed View in PA for Excel
62371 When moving elements they may disappear from the PA for Excel context
62381 Duplicate connection added in PA for Excel when opening a cube viewer
62429* Typing a quote in the MDX set editor crashes PA for Excel
62784* Converting to snapshot causes an object reference error
62792* Unable to work with PRIVATE views - 'Object reference not set to an instance of an object'
63105 Synchronization from dimension widget to websheet fails when you select a leaf-level member that roll-up into more than one parent in the default hierarchy
63013 Incorrect display seen when SUBNM selected
63016 Publishing from PA for Excel can cause high memory usage in TM1 Web
63130 Unable to delete an inserted calculation
63145 Exploration View - Keep functionality does not hold
63390 Dynamic Form shows #Value on rebuild, sometimes every other refresh
63396* No drill icons appear on convert to dynamic report from view
63804 Process with Chorequit function doesn't send an error
63805 French translation of 'average' is incorrect ('moyen' instead of 'moyenne')
63806 Warning in PA for Excel when opening a protected book: "COR-ERR-2021 Worksheet protected, IBM® Planning Analytics Styles cannot be populated."
63918 Using a subset with '%' in the name generates error: OBJECT:'A %25 A' could not be found once the subset is in the context filter area of the viewer
63924 Action buttons lose their format when using "Upgrade action buttons" functionality when the regional settings are in French
63970 Picklist on attributes does not work in PA for Excel if controls objects are not displayed
64052 All nested dimensions display top dimension's first element in a row and column overview until sets are modified
64069 Opening a report in PA for Excel causes server instability
64266 The report is not refreshed automatically after button upgrade
64349 Creating a subset using attribute filter and adding the definition to the MDX creates a set not editable anymore
64465 Unable to remove a DBRW formula by clearing the contents of the cell and then replacing it with a number
64586 Preserve user formulas does not work when drilling the hierarchy
64732 PA Workspace alias not visible in visualization
64858 Active Forms - Picklist and DBRW formulas not working as expected
64859 Refresh Workbook does not bring back all the values
64918* DBRA formula is showing RECALC_0_ message and locking up the whole Excel book
65106 When clicking on the hierarchy structure in PA Workspace (+ or - sign) nothing happens
PI52594 * INCORRECT FORMATTING CHOOSING EXCEL FORMATTING
PI75778 * VIEW FORMULA NOT RESOLVED IN PA Excel
PI81585 * EXCEL NATIVE INSERT CELL MENU DOESN'T WORK
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel Release 21.
Reference Number Description
58776 TM1 - Exploration got updated using the first cube listed in the server and selecting the right cube to update reset the exploration
62338 Unable to use renamed View in PA for Excel
62746 TM1 - Expanding members/subsets under Dimensions on the tree causes an error
63396 No drill icons appear on convert to dynamic report from view
63527 SetEditorPreviewOn setting does not retain when "Apply and close" is done in PA for Excel
64401 Exploration copy is not working properly
64444 Context dimensions disappeared when a member name with bracket is selected as context member
64477 PA for Excel - DBSW Formulas in nested IF statements do not load
64918 DBRA formula is showing RECALC_0_ message and locking up the whole Excel book
65824 Convert to Snapshot function in PA for Excel with filter scrambles data
65849 Subset Editor does not work when using cell reference
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 22.
Reference Number Description
62456 DBSW does not return the value in the database, when it fails to writeback to a rule based cell
63675 View does not work in PA for Excel but is OK in Perspectives and Workspace
64434 Member name with square bracket cannot be recognized by PA for Excel and cannot be applied from set editor to exploration and quick report
65412 Complex dynamic report workbooks may abnormally terminate calculation with 'pending_' row headers in the master row
65502 Navigation to the webpage was canceled message after a PA for Excel session timeout instead of re-prompt to login
65809 TM1 - [Save View] Unable to save with dimension name with space
66346 TM1 [Picklist] PA for Excel should be able to clear data for picklist in a consistent way
66349 Syntax error apply row or column set when selected member name contains bracket
67054 Plural use of subnm functions in complex scenario, where they all should evaluate to the same final arguments, results in #value
67077 Unable to see BI packages content in PA for Excel
67154 PA for Excel: Error thrown when moving a dimension from Rows to Columns when column dimension has MDX code using EXCEPT
67173 Unable to open explorations created in previous versions in PA for Excel 21
PI34505 COGVAL in CAFE exploration does not refresh data as expected
PI79447 LOCALIZED DIMENSION NAMES IN CONTEXT FILTER ARE LOST AFTER EDIT SET
PI82482 USE SERVER FORMATTING' OPTION IS DISABLED BY API FUNCTION
PI82665 TM1 - [Special char] ' causes an error when trying to commit
64655 Hierarchy right-click menu lost if a view is duplicated
66422 User must logout after a Workspace workbook with embedded websheets fails with Cannot POST error
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 23.
Reference Number Description
60163 Right-click Selecting Exploration on a renamed view displays the following error message "Value cannot be null"
66252 Instead of the login page when switching to another cloud URI, the following message is displayed "Navigation to the webpage was canceled.."
66302 PA Workspace: French translation of 'Column' is incorrect - it should be "Colonne" instead of "Column"
66840 Using "h" in formatting string results in strange behavior in PA Workspace on Chrome and Firefox
67452 Unable to insert a calculation on the rows
68008 Metadata pane displays hourglass and server metadata never loads
69109 Unable to save a new Workbook if it includes a WebSheet
PI83204 Planning Analytics Workspace session management issue
PI84028 Calculation is inserted in between selected rows instead of after the last selected row and user not able to insert more than one row calculation
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics Workspace Release 24.
Reference Number Description
68437 PA Workspace map charts are not displaying all measures on first switch from exploration
PI85224 Error when retrieving logs
50901 Scrolling issue in Chrome when zoom level are set to 110 , 67 , 35%
59096 First keystroke in Planning Analytics Workspace string picklist cell is required to activate cell and subsequently lost
64183 Stuck on Watson loading icon if Planning Analytics Workspace workbook has an error
68297 Planning Analytics Workspace Dimension widget does not render correctly if not on the first sheet of a book
68713 Planning Analytics Workspace Exploration hanging when selecting more than 1
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 25.
Reference Number Description
PI81830 TM1Server Crash: View being created from TI process has Dimensions with no Elements
PI85333 Unable to restore a Linux based backup to a Windows based PA Workspace
PI86381 Query service uses too much memory if a cube has a very large measure dimension
63952 Planning Analytics for Excel: Logon after timeout requires closing Excel and restarting
64859 Planning Analytics for Excel - Refresh Workbook does not bring back all the values
64921 No visual cue seen in Planning Analytics for Excel when Set Hold is applied
66247 TM1 - 'Syntax error at or near: ...' and 'Convert to' option unavailable when Refresh a customer MDX based report from an older Planning Analytics for Excel version
66427 TM1 - Hitting 'Enter' does not apply filter inside set editor
66782 BI & TM1 - Edit Set is missing from overview area for list
67774 Named set becomes a static list with no warning once selected, apply and close clicked in subset editor
67788 Performance issues with Exploration cube views in Planning Analytics for Excel
67864 Reorder/Rename not working as expected
68542 Default mode for the Hierarchy vs Definition view in the set editor should be to come up in Hierarchy mode
68746 Disable delete option against Leaves hierarchy
68769 Title Elements in Planning Analytics for Excel Exploration do not show selected Alias
69275 The view dragged on Planning Analytics Workspace does not reflect the Architect view (alias "ID_and_Name" are not selected in Planning Analytics Workspace)
69564 Ctrl-Space is brings up the code completion behind the process editor widget on IE
69599 Null reference error on 2nd Reorder
69675 Drill through does not work when the users are in a sandbox, it works fine if [base] has been selected
69678 Planning Analytics Workspace - Selector Widget search is searching only on the ID not on the Alias displayed
69728 Unable to overwrite a Private View
69924 Can't add sort by values if nested dimensions on columns
70476 Planning Analytics Workspace - Visualizations are not rendering for end users with proper security
70505 Planning Analytics Workspace - Slow performance when opening workbook tabs
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics for Microsoft Excel and Planning Analytics Workspace Release 26.
Reference Number Description
62914 Have to double click twice to get drill to work after drilling on a sheet then collapsing to the top and trying to drill again
65468 Excel comment and Planning Analytics for Excel annotation show random box shape, size, and background/foreground color in Planning Analytics Workspace and TM1 Web
66816 [BI] The context menu item "Insert user row / column" is not available until a measure is added to the exploration
68701 Planning Analytics for Excel is dropping leading zeros in Excel for list reports
68818 Unable to remove a member from the asymmetric axis in Exploration
69233 Data doesn't render properly when sheet protection is used in Planning Analytics for Excel
69681 Planning Analytics for Excel: Opening a Workbook in Protected Mode results in the loss of Quick Reports
69842 A dynamic report created in Planning Analytics for Excel will automatically add cafe_validation_temp data validations on SUBNM cells
69843 TM1web - Data validation added to SUBNM cells (by Planning Analytics for Excel) is not ignored when sheet published to TM1web
70283 Planning Analytics for Excel - Sheet that would work in PA 2.0.21 now throw "Merge method of Styles class failed" error, reopening the sheet throws the same error
70334 Refreshing a book with many explorations running into the following error "HResult 0x800AC472 Exception on CustomProperty.set_Value"
70752 Message returned "Registering library \CognosOfficeBI.xll" stays stuck in status bar until you hit the Planning Analytics for Excel tab
71026 Multiple SUBNMs in Planning Analytics for Excel not working as expected
71044 Planning Analytics for Excel - Action buttons do not adjust when drilling down in dimension of TM1RPTROW
71135 TM1PRIMARYDBNAME formula gives #VALUE! error
71220 If a cell is null (undefvals) or formatting in the attribute format is blanking zero's we should still format those with the correct format (not text)
71277 Planning Analytics for Excel: Named cell references do not persist in SUBNM formulas once an element is selected
71722 Unable to add a view into a Exploration
72160 Issue with the subset name having a "." period symbol in the original subset name has been truncated
72336 DBRA formulas not working as expected
PI83091 Copying ELPAR function gives unexpected results
PI86546 Filter tree option in Cognos Analysis for Excel doesn't work with dimensions having multiple hierarchies
PI86626 In nested dynamic report, if outer column does not have an alias override parameter, an inner one does, the alias will not apply on the inner column
PI87401 [Hierarchies] 'Zero suppression' suppresses non-zero values
PI86581 Indentation of row members is displayed wrong for leave nodes without hierarchy in Planning Analytics for Excel
70747 Add value to canvas - loses format
70978 Sum (All) totals are incorrect when Summary Column or Row Moved in the Subset Editor
71224 Items added to canvas are showing 0
71387 In Planning Analytics Workspace scrolling with mouse wheel is not possible using Firefox
Issues corrected in IBM Planning Analytics 2.0 - Planning Analytics Workspace Release 27.
Reference Number Description
PI80926 Sandboxes created in Architect or Perspectives and not shown in Planning Analytics Workspace
PI85900 Planning Analytics Workspace - unable to replace row dimension members of view after doing a "KEEP"
PI86367 Planning Analytics Workspace ODBC Drill thru does not display or download
PI86381 Planning Analytics Workspace resource exhaustion
66879 Relative proportional and percent adjustment spreading is not working on multiple hierarchies
67872 Application access security not applied in Planning Analytics Workspace - All applications visible
71600 Unable to perform a transfer data set to IBM Watson Analytics for a large complex query
71619 MDX fails to refresh a change to a dimension in other cube when stepping upwards in the hierarchy
71686 Cannot scroll over to view the data in columns when we have a number of dimensions stacked in view
72020 Error when adding new member via dimension editor in Planning Analytics Workspace - Add Member Expecting '}'
72052 Planning Analytics Workspace: Widget used on subset synchronizes data but does not keep selected element highlighted when one moves off the selection

[{"Business Unit":{"code":"BU002","label":"Business Analytics"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":""},{"Business Unit":{"code":"BU002","label":"Business Analytics"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Component":"Planning Analytics for Microsoft Excel;Planning Analytics Workspace","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":""}]

Document Information

Modified date:
13 September 2019

UID

swg27049597