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
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.