In SAS Financial Management, you can load transactions using the Load Data Wizard in SAS Financial Management Studio, the fm_1100_load_base_data job or the fm_1100_load_base_data_unlock_periods in SAS Data Integration Studio, or user-written code that calls either the %ETLLDFCT macro or the %ETLLDFTU macro.

When you use the jobs in SAS Data Integration Studio or user-written code, you must specify the dimension member selection list to use in selecting which transactions are loaded. Here is an example:

It is important to note that the observations in this table must be in dimension type order as shown above.

If the dimension member selection table contains observations that are not sorted by dimension type (as shown below) and you select Replace all, the existing fact records for these crossing might not be deleted. This could result in the fact values being inadvertently doubled.

To correct this problem, unzip this ZIP file and extract the contents to the relevant location:

Operating System and Release Information