Document toolboxDocument toolbox

Support center for flex.bi version 3.2

HansaWorld Sales Orders

Owned by Gvido
Last updated: Sept 07, 2016
1 min read

HansaWorld Sales Orders cube demo

Dimension Table

 

Dimension Dimension HierarchyDefault properties
TimeYear / Quarter / Month / Week / Day-
CustomerCategory / CustomerCustomer category
Customer person code
Customer classification
Customer export flag
PersonSales Group / Person-
CurrencyCurrency-
ItemGroup / ItemSales Order item code
Alternative code
Item unit
Item group
Item classes
Item objects
Project (Job)Class / Project / Project item-
LocationGroup / Location-
Sales OrderSales Order Class / Sales Order / Sales Order Item

Sales Order date
Planned ship date
Sales Order class
Sales Order currency
Sales Order customer name
Sales Order person code
Sales Order project code
Sales Order objects
Closed
Item Variety
Invoice address 1
Invoice address 2
Invoice address 3
Invoice address 4
Invoice address 5
Invoice country
Delivery address 1
Delivery address 2
Delivery address 3
Delivery address 4
Delivery address 5
Delivery country

 

Measures Table

CubeLevelMeasures
Sales OrdersRecordSales Order amount
Discount amount
Tax amount
Sales Order base amount
Discount base amount
Tax base amount
Sales Order count
Item

Item amount
Item quantity
Item base amount
Gross profit
Gross profit base amount
Open amount
Open base amount
Open quantity

Stock (Shared)RecordIn stock
Stock on order