Installation Instructions for Hot Fix D73015

Windows

*** Please see the disclaimer regarding this experimental fix at the bottom of this page. ***

Hot fix D73015 addresses the issue(s) in SAS Financial Management 5.2_M1 on Windows as documented in the following SAS Notes

41974   'Template save failed' message when trying to save a form template that has been migrated from SAS® Financial Management release 4.x to release 5.x
42554   table.Model property not working in SAS® Financial Management Add-In API for Microsoft Excel
42657   "Code execution has been interrupted" when VBA code performs a double-click in SAS® Financial Management table
43539   The data validation object in supplemental schedules is limited to 255 total characters
43376   SAS® Financial Management Add-In API for Microsoft Excel does not return correct information for Server, URL, and Port in a Data-Entry form
44082   SAS® Financial Management supplemental schedule detail dimension not updated when driven by a linked dimension
44139   SAS® Financial Management 'template save failed' when adding measure to supplemental schedule if validation list is greater than 255 characters
44181   Writeback of data values using the SAS® Financial Management Add-In API for Microsoft Excel's FMCube Class is slow
42688   SAS® Financial Management functionality disabled if two OLAP reports opened and you log off one of them
44285   Performance might be slow when entering data into a SAS® Financial Management supplemental schedule

D73015 is a "container" hot fix that contains the following "member" hot fixes which will update the software components as indicated. See the Container Hot Fixes section in the Maintenance Install Tool (MIT) Usage Guide for more information about container hot fixes.

D74006 for SAS Financial Management Add-in for Microsoft Excel 5.2
E40003 for SAS Solutions Services Add-in for Microsoft Office 5.2

INSTALLATION

Important Notes

1. Files delivered in this hot fix will be backed up during the installation process. However, it is good general practice to back up your system before applying updates to software.

2. You must have Administrator Privileges on your CLIENT or SERVER machine.

3. This hot fix should be installed using the same userid who performed the initial software installation.

Downloading the hot fix

1. This hot fix must be installed on each machine where the updated components of the product, listed above, are installed. The installation process will determine which components of SAS Financial Management 5.2_M1 are installed on each machine, and apply the appropriate updates.

2. If the updated components of this product are installed on multiple operating systems, you must download the hot fix for the appropriate operating system(s) and follow the installation instructions provided to complete the deployment of this hot fix.

3. When downloading SAS 9.2 hot fix packages, you must choose to Save the hot fix to disk, then execute the install from the saved location. Attempting to install a hot fix directly from the download page results in the error documented in SAS Note 37104.

4. The installer downloaded is D73015wn.exe.

Prior to executing the hot fix

1. Exit out of all Microsoft Office applications.

2. Exit out of SAS Financial Management Studio, the SAS Financial Management Add-In for Microsoft Excel and the SAS Information Delivery Portal.

Installing the hot fix

1. Select Start > Run and enter cmd to invoke a command prompt.

2. Change your directory to the location where D73015wn.exe was saved (c:\temp in the following example) and enter the following

   C:\temp> D73015wn.exe -alwaysoverwrite

   to invoke the SAS Maintenace Install Tool. The wizard will guide you through the application of the hot fix. Accept the defaults, select ‘Start Install’ when prompted, and be sure to select ‘Finish’ when you are prompted with ‘Installation Complete’.

3. Re-start your SAS Financial Management client application(s) and all of the changes should be in effect.

See the Maintenance Install Tool (MIT) Usage Guide for more details on the installation of hot fixes.

This completes the installation of D73015. You must perform any "Post-Installation Instructions" documented below to successfully complete the deployment of this hot fix.

POST-INSTALLATION INSTRUCTIONS

Once this fix is applied, you should access your form(s) on a client machine that has the fix installed and then re-save your form(s) to enable the longer validation lists to be properly handled. If your form set is already published, you might want to consider re-setting, re-saving and re-publishing the form set, though this is not required.

If you then access the form(s) from a client machine that does not have the fix applied, you will find that your validation will not work; the fix must be installed on all clients that access the forms(s).

After applying a hot fix to SAS Financial Management Add-in for Microsoft Excel or SAS Solutions Services Add-in for Microsoft Office

If you encounter Visual Basic Application errors in your reports/forms after applying the hot fix, such as

("Type mismatch" error)
Compile error: Object library feature not supported
Object variable or With block variable not set

1. Log off of the Financial Management or SAS Solutions Add-In.

2. From the report/form, select Alt + F11 to open Visual Basic for Applications window.

3. Select Tools > References and de-select the SASSESExcelAddin.

4. Click OK.

5. Select Tools > References. Notice that the previous SASSESExcelAddIn reference is now missing from the list.

6. Select Browse, navigate to SASSESExcelAddIn.tlb and select Open

   (file location is typically C:\Program Files\SAS\SASFinancialManagementAdd-InforMicrosoftExcel\5.2\SASSESExcelAddIn.tlb).

7. The new SASSESExcelAddIn reference will appear in the list and will be selected.

8. Select OK.

9. Select File > Save.

10. Exit our of your Excel session.

11. Open the report/form and log on to the Financial Management or SAS Solutions Add-In.

12. The report/form should now recognize the reference to the latest SASSESExcelAddIn.tlb with no errors.

This completes the deployment of hot fix D73015 on Windows.



SAS Institute Inc.

License Agreement for Corrective Code or Additional Functionality

SAS INSTITUTE INC. IS PROVIDING YOU WITH THE COMPUTER SOFTWARE CODE INCLUDED WITH THIS AGREEMENT ("CODE") ON AN "AS IS" BASIS, AND AUTHORIZES YOU TO USE THE CODE SUBJECT TO THE TERMS HEREOF. BY USING THE CODE, YOU AGREE TO THESE TERMS. YOUR USE OF THE CODE IS AT YOUR OWN RISK. SAS INSTITUTE INC. MAKES NO REPRESENTATION OR WARRANTY, EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, NONINFRINGEMENT AND TITLE, WITH RESPECT TO THE CODE.

The Code is intended to be used solely as part of a product ("Software") you currently have licensed from SAS Institute Inc. or one of its subsidiaries or authorized agents ("SAS"). The Code is designed to either correct an error in the Software or to add functionality to the Software, but has not necessarily been tested. Accordingly, SAS makes no representation or warranty that the Code will operate error-free. SAS is under no obligation to maintain or support the Code.

Neither SAS nor its licensors shall be liable to you or any third party for any general, special, direct, indirect, consequential, incidental or other damages whatsoever arising out of or related to your use or inability to use the Code, even if SAS has been advised of the possibility of such damages.

Except as otherwise provided above, the Code is governed by the same agreement that governs the Software. If you do not have an existing agreement with SAS governing the Software, you may not use the Code.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. (r) indicates USA registration. Other brand and product names are registered trademarks or trademarks of their respective companies.