There are two fact tables, so there are two measurement value groups, and the wizard creates a measurement value for each value column in the fact table that is not a dimension key. Because we don't need that much here, we only select some measurement values. In addition, the measurement value names are derived from columns in the fact table, and all names may be the same. However, in a multidimensional dataset, the name of a measurement value must be unique. Therefore, the wizard adds the name of the measurement value group after the duplicate measurement value name.
In the next step, the multi-dimensional dataset wizard identifies the measurement value group, that is, the dimension table associated with the previous fact table. Therefore, all the dimension tables are displayed here.
Take a name for the cube and save it.
Analyze the final effect of cube by physical and chemical indexes over the years:
Region: prefectures, counties
Time Dimension: Year
Level dimension: Big level, small level
Indicator: average value of physical and chemical indicators
Bi project notes create cube