Microsoft SQL Server Edition Dependencies

To use all of the dimensions and measures in Analysis Cubes, you must have Microsoft SQL Server™ Enterprise Edition installed. If you are using the Standard Edition, not all dimensions and measures are included in the data cubes.

General Ledger Data Cube

All of the dimensions in the Presentation Currency dimension group.

Project Data Cube

Presentation Currency

  • All the dimensions in the Presentation Currency dimension group.

Accounts Receivable Trending

  • All the measures in the AR Trending measure group (including the measures in the Multicurrency subfolder).

Days Sales Outstanding (DSO)

  • The DSO 90 and DSO 360 measures in the Accounts Receivable measure group.
  • The DSO 90 in Billing Currency and DSO 360 in Billing Currency measures in the Multicurrency folder in the Accounts Receivable group.
  • The DSO 90 in Project Currency and DSO 360 in Project Currency measures in the Multicurrency folder in the Accounts Receivable group.

Days Work-In-Progress Outstanding (DWO)

  • The DWO 90 and DWO 360 measures in the Unbilled folder in the Values group.
  • The DWO 90 in Billing Currency and DWO 360 in Billing Currency measures in the Unbilled – Multicurrency folder in the Values group.
  • The DWO 90 in Project Currency and DWO 360 in Project Currency measures in the Unbilled – Multicurrency folder in the Values group.