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 MS 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 are available at http://www.ibm.com/support/docview.wss?uid=swg27049229

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. 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.

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
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
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

Related information

Download Planning Analytics releases from Fix Central
Planning Analytics Local Software Environments
Planning Analytics Local 2.0 Fix Lists
IBM Planning Analytics 2.0 New Features

Cross reference information
Segment Product Component Platform Version Edition
Business Analytics IBM Planning Analytics Local Planning Analytics v2.0 for Microsoft Excel 2.0.3, 2.0.2, 2.0.1
Business Analytics IBM Planning Analytics Local Planning Analytics v2.0 - Workspace 2.0.3, 2.0.2, 2.0.1
Business Analytics IBM Planning Analytics Planning Analytics 2.0.3, 2.0.2, 2.0.1

Document information

More support for: IBM Planning Analytics Local

Software version: 2.0.1, 2.0.2, 2.0.3, 2.0.4

Operating system(s): Linux, Windows

Reference #: 7049597

Modified date: 22 May 2018


Translate this page: