Problem Note 42490: SAS® Financial Management formulas do not validate if they contain the Property function used inside brackets
If you create a formula for a calculated dimension member in SAS Financial Management, the formula does not pass validation if the Property function is included inside brackets within the formula.
For example, the Property function works as expected if you submit a formula such as
IF((PROPERTY("ACCOUNT","AccountType")="Asset" )...
However, once you enclose the Property function in brackets, such as
IF["ACCOUNT"=PROPERTY("ACCOUNT","...
the function is no longer valid.
Selecting 'Validate Expression' in the SAS Financial Management Studio Formula Editor returns the result:
Invalid to apply the function PROPERTY inside the address bracket syntax
For additional information please contact SAS Technical Support.
For more information about creating formulas and using functions in SAS Financial Management, please refer to the SAS Financial Management Formula Guide or to the •SAS Financial Management User's Guide.
Please note that this documentation is intended for use only by existing SAS Financial Management customers.
Please contact SAS Technical Support if you need User name or Password information to access any of this documentation.
Click the Hot Fix tab in this note to access the hot fix for this issue.
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.
A formula for a calculated dimension member that uses the property function inside brackets does not pass formula validation in SAS Financial Management Studio.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2012-05-07 08:55:09 |
Date Created: | 2011-02-23 09:31:38 |