Problem Note 35114: Export to Excel results in a Microsoft Excel worksheet with missing Period - Scenario information
 |  |  |  |  |
If you are at the OLAP page in the SAS® Activity-Based Management client and your OLAP view includes Period - Scenario data, when you select OLAP > Export to Excel, the resulting Microsoft Excel worksheet will not include Period - Scenario information in the heading.
For example, if your OLAP view includes Period data of 2008 and Scenario data of Actual, both as column headings, and you select OLAP > Export to Excel, you would expect the Microsoft Excel worksheet to include "2008 Actual" in the column headings but "2008 Actual" would be missing.
This only applies if your SAS Activity-Based Management 6.4.2 server is configured with Microsoft SQL Server Analysis Services (SSAS) 2005.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Activity-Based Management | Microsoft Windows XP Professional | 6.4.2 | 6.4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Standard Edition | 6.4.2 | 6.4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 6.4.2 | 6.4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 6.4.2 | 6.4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 6.4.2 | 6.4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 6.4.2 | 6.4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Advanced Server | 6.4.2 | 6.4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for Enterprise Guide 4.1 is available at:
http://www.sas.com/techsup/download/hotfix/ent_guide41.html#035114| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-08-11 16:30:55 |
| Date Created: | 2009-03-12 12:09:38 |