A Dimension Type Code error might occur in the SAS® Financial Management solnsvc_2200_create_dimension job


The solnsvc_2200_create_dimension job might fail with an error similar to the following when it runs in an I18N environment:

Dimension Type Code error (Value: Account). The value cannot contain more than 32 characters.

Resolution

To correct this problem, you must update the following:

Complete the following steps to update the "create_dimension" transformation:

  1. Log on to SAS® Data Integration Studio as the Solutions Administrator (slnadm).
  2. Click the Transformations tab.
  3. Expand SAS Financial Management.
  4. Right-click the create_dimension transformation and select Properties.
  5. Click the Code Options tab.
  6. Select Dimension Type Code and then select Edit.
  7. Click the Prompt Type and Values tab.
  8. Change the Maximum length value from 32 to 96.
  9. Click OK.
  10. Click OK.
  11. If prompted to confirm changes, click Yes.

Screenshot of the "Edit Prompt" window

Complete the following steps to update the "solnsvc_2200_create_dimension" job:

  1. Click the Folders tab.
  2. Select Products ► SAS Financial Management ► 5.4 Jobs.
  3. Open the solnsvc_2200_create_dimension_job.
  4. Delete the create_dimension transformation from the job.
  5. Click the Transformations tab.
  6. Drag the create_dimension transformation onto the job.
  7. Close and save the job.