SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 20084: "Failed to insert a data item for the expression" error when generating a cube

DetailsHotfixAboutRate It
If you log on to the SAS® Profitability Management 1.2 Client as a user who is defined with a blank password at the Logins tab in the User Manager plug-in within SAS Management Console, and you attempt to Generate a cube at the Reports Workspace, the request will fail and you will see the following message:

   The program produced an error. Refer to the error log.

If you select the Details button, the log file will contain errors, such as:

   ERROR: Failed to insert a data item for the expression
   "<<Measures.CountSum>>".

or

   ERROR: Failed to insert a data item for the expression
   "<<Measures.AMTSum>>".

The error message displayed will be dependent upon the measures available within the model. You should expect to see one error message for each measure.

To apply the fix for this issue, click the Hot Fix tab in this note.

Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Profitability ManagementMicrosoft Windows Server 2003 Enterprise Edition1.21.39.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Professional1.21.39.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server1.21.39.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server1.21.39.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows XP Professional1.21.39.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition1.21.39.1 TS1M3 SP49.1 TS1M3 SP4
* 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.