BI project notes creating Cubes Cube (2)

Original: BI project notes creating Cubes Cube (2)

This section establishes:

analysis of the change of water mean value of smoke in the past years Cube:
Area dimensions: Ground state, county level
Time Dimension: Year
Level dimension: Large, small
Indicator: Moisture mean value

Data Source view:

Data processing:

ALTER TABLET_qualmoisture_middleALTER COLUMNv_produce_idVARCHAR( -) ALTER TABLET_qualmoisture_middleALTER COLUMNv_batch_idVARCHAR( -) DELETE   fromT_qualmoisture_middleWHEREv_produce_id+v_batch_id not inch(SELECTProductionno+Formulano fromVroastingplan)

Dimension usage:

Partition:

Final Browser effect:

BI project notes creating Cubes Cube (2)