Problem Note 68063: Copying and pasting into multiple roll-up cells in Microsoft Excel might fail in the SAS® Intelligent Planning Suite
 |  |  |  |  |
In the SAS Intelligent Planning Suite, copying and pasting a value into multiple roll-up cells in Microsoft Excel might fail. This problem is likely to occur if disaggregation generates a larger number of facts.
For example, if you copy and paste a value into a cell (Rollup Cell A), the application disaggregates and writes back 100,000 facts successfully. Then, if you copy and paste a value into another cell (Rollup Cell B), the application also disaggregates and writes back 100,000 facts successfully. However, if you copy and paste values into both cells simultaneously, the disaggregation fails.
To work around this issue, you should copy and paste values into one roll-up cell at a time.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Intelligent Planning Suite | Linux for x64 | 8.23 | 2020.1.5 | Viya | Viya |
| SAS System | SAS Demand Planning | Linux for x64 | 8.23 | 2020.1.5 | Viya | Viya |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-07-08 09:24:32 |
| Date Created: | 2021-06-21 08:18:26 |