SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 35114: Export to Excel results in a Microsoft Excel worksheet with missing Period - Scenario information

DetailsHotfixAboutRate It

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Activity-Based ManagementMicrosoft Windows XP Professional6.4.26.4.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition6.4.26.4.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition6.4.26.4.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition6.4.26.4.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server6.4.26.4.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server6.4.26.4.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server6.4.26.4.29.1 TS1M3 SP49.1 TS1M3 SP4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.