Problem Note 42554: table.Model property not working in SAS® Financial Management Add-In API for Microsoft Excel
You might find that the table.Model property in the SAS Financial Management Add-In API for Microsoft Excel's FMTable Class does not return the expected results.
When you submit Visual Basic (VBA) code to programmatically change the model that a SAS Financial Management table references, you will see that the table model is not correctly changed.
For example, if your current table reads from the model 'Financial(Financial)' and you want to programmatically change the model to 'Budget(Budget)', you might submit the following VBA code to utilize the table.Model property in the SAS Financial Management Add-In API for Microsoft Excel's FMTable Class.
Public Sub change_model()
Dim addin As FMAddIn
Dim conn As Connect
Dim table As FMTable
Set conn = Application.COMAddIns.Item("SASSESExcelAddIn.Connect").Object
Set addin = conn.FMAddIn
Set table = addin.Tables("NewTable0")
If table.Model = "Financial" Then
table.Model = "Budget"
Else
table.Model = "Financial"
End If
addin.RefreshAll
table.Refresh (True)
End Sub
However, after you run this code, you will find that the table is not updated properly. Specifically, if you select
Tables > Properties
and then select the 'Dimensions' tab, you will likely see that the model is changed to 'Financial(Budget)' instead of to 'Budget(Budget)'.
This is marked as fixed in release 5.3 of SAS Financial Management.
For additional information please contact SAS Technical Support.
For more information on the SAS Financial Management Add-In API for Microsoft Excel, please refer to the SAS Solutions Services Customization Guide.
Operating System and Release Information
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
*
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.
The table.Model property does not change the table's model. The code string is changed but the actual table cube is not changed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-03-24 10:07:34 |
| Date Created: | 2011-03-01 10:42:25 |
