Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
To understand what is data cube - please read about Basic Concepts of Flex.bi
Read more about each cube and its possibilities
HansaWord Invoices
HansaWorld Financials
HansaWorld Sales Orders
HansaWorld Quotations
HansaWorld CRM
HansaWorld Stock
HansaWorld Stock Depreciations
HansaWorld Stock Movements
HansaWorld Goods Receipts
HansaWorld Stock Job Costing
HansaWorld Invoices
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Note |
---|
Goods Receipt, Stock Depreciation, Stock Movement cubes require that the Stock cube is also imported with locations and the optional location classes and location types. |
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Read more about Basic Concepts of Flex.bi.
What is data Cube ?
Imported data is stored in multi-dimensional data cubes. Cubes contain fact data that are divided by dimensions and each detailed fact "cell" contains measure values about that fact. This is an example of a Sales cube that has Customers, Products and the Time dimensions and has two measures - Sales amount and Units sold. Each detailed cube "cell" contains sales amount and units sold for particular product, customer and time period:
What is
dimensionDimension ?
Typical cube dimensions are Time, Customers, Products, Locations, Employees, Projects etc. Use dimensions that are best suited to your business domain.
Each dimension can have either just detailed level of all dimension members or you can define hierarchy with several levels. For example, Customers dimension could have Country, State and Customer Name levels:
All measures are automatically aggregated (typically as sum of detailed level values) in upper hierarchy levels. E.g. looking at Sales amount measure at Country level will give total sales amount for this country.
Read more about Basic Concepts of Flex.bi.