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 |