Multiple share
dimension tables where viewed as a collection of stars, called galaxy schema or fact tables' fact constellation (Fig 8)
Profit statement analysis star schema mainly includes: fact table of profit statement (including accounting time, profit and loss index code, accrual, accumulated accrual, changes, change ratio, etc.),
dimension table of profit statement (including index code, index name, etc.),
dimension table of time.
Dimension tables are attributes of the fact tables.
Therefore, it's useful to create a
dimension table that contains ranged values of critical recency, frequency and sales measures.
Star schema uses star join operation between fact table and dependent
dimension tables. Star join is efficient and performances are good, if the index is correctly defined.
* Each
dimension table has a "current row flag" regardless of whether the slowly changing dimension approach is Type 1 or Type 2 currently.
The results presented in Table 2 show that the incorporation of residues in the calculation of scores provided an improvement to the
dimension tables in the sense that the coordinates had higher correlation to data grouped hierarchically considering the average linkage method.
