If you use SAS^® Activity-Based Management to import a model from Microsoft Excel, you might encounter the following error if a staging table contains an empty row.

For example, if a dimensionMember table defined in Microsoft Excel contains empty row(s), importing SAS Activity-Based Management staging tables results in the above error message.

The screenshot below contains an example of a dimensionMember table that contains an empty row. The DimensionMember named range contains the cells $A$1:$F$54. The 54th row is empty.

To resolve the error, edit the dimensionMember table to exclude the empty row. In the above example, re-define the DimensionMember named range to contain cells $A$1:$F$53. See the screenshot below for an example.

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 Server 2003 for x64	7.1	7.2	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2008	7.1	7.2	9.2 TS2M3	9.3 TS1M1
		Microsoft Windows Server 2008 for x64	7.1	7.2	9.2 TS2M3	9.3 TS1M1

* 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.

---

If you use the SAS® Activity-Based Management client to import a model from Microsoft Excel, you might encounter this error if one of your staging tables contains an empty row.

Type:	Problem Note
Priority:	high

Date Modified:	2011-10-04 17:46:04
Date Created:	2010-11-08 14:37:38