Structure of the Samples database

Many of the examples given, and the syntax of functions, reference the database of the Samples application, which can be enabled in on-premises environments. Samples is not available in the Infor cloud. For your reference, this topic describes the structure of the Samples database.

Cubes

The database has several cubes, but the two that are referenced in the examples are Analysis and Sales. The majority of references are to the Analysis cube.

Analysis cube

The Analysis cube has this structure:

Dimension Hierarchy Default value
Measure Measure Gross Margin
Period Period All Years
Point of Sales Point of Sales All POS
Product Product All Tires
Speed Rating All Speed Ratings
Tire Size All Sizes
Region Region All Regions
Channel Channel All Channels
Value Type Value Type Variance

Sales cube

The Sales cube has this structure:

Dimension Hierarchy Default value
Profit (measure) Profit Sales Volume
Time Time YTD
Version Version Actual
Currency Type Currency Type Local Currency
Level Level IFRS
Unit Unit Total Group
Intercompany Intercompany TotalPartner
Product Product All Tires
Speed Rating All Speed Ratings
Tire Size All Sizes

Finance cube

The Finance cube has this structure:

Dimension Hierarchy Default
Version (measure) Version Actual
Time Time YTD
Currency Type Currency Type Local Currency
Level Level IFRS
Unit Unit Total Group
Intercompany Intercompany Total Partner
Account Account IFRS