Original: BI project notes creating cubes cube (1)
There are two fact tables, so there are two measure groups, and the wizard creates a measure for each numeric column in the fact table for non-dimension keys. Since we don't need that much here, we only select some of the measures. Also note that the name of the measure is derived from the column in the fact table, and all names may be the same. However, in a cube, because the name of the measure must be unique, the wizard adds the name of the measure group to which it belongs after the duplicate measure name.
The next time the Cube's wizard recognizes the dimension table associated with the measure group, which is the previous fact table, it will all be displayed here.
Take a name for the cube and save it.
Physical and chemical indicators over the past year analysis cube final effect:
Area dimensions: Ground state, county level
Time Dimension: Year
Level dimension: Large, small
Index: Physical and chemical index mean value
BI project notes creating cubes cube (1)