BI Project notes Select output Analysis cube

Original: BI project notes Select output Analysis cube

Data Source settings:

Data processing logic:

--I_gbgradeidSELECT  * fromT_npick_pkgmovWHEREI_gbgradeid not inch(SELECTI_gbgradeid fromT_gbgradecode)DELETE   fromT_npick_pkgmovWHEREI_gbgradeid not inch(SELECTI_gbgradeid fromT_gbgradecode)--V_customeridSELECT  * fromT_npick_pkgmovWHEREV_customerid not inch(SELECTC_custcode fromt_custominfo)ALTER TABLET_npick_pkgmovALTER COLUMNV_customeridVARCHAR(5) not NULL   --New business Date businessdate fieldALTER TABLET_npick_pkgmovADDBusinessdateINT NULL--Convert datetime to intUPDATET_npick_pkgmovSETBusinessdate= CAST(REPLACE(CONVERT(CHAR(Ten), D_time, -),'-',"') as INT)

Main indicators:

N_weight Weight _ Total

I_piece Number of pieces _ Total

Dimension tables that need to be extracted:

Serial number	Table name	Description	Note
1	T_gbgradecode	Tobacco leaf Grade
2	T_distinction	Tobacco Grade
3	T_origin	Origin
4	T_purchasetype	Acquisition Type
5	T_tlproctype	Type of processing
6	T_custominfo	Customer

The fact table that needs to be extracted:

Serial number	Table name	Description	Note
1	T_npick_pkgmov	Select Outputs	V_cyclenode 01 selection of outputs

Project structure:

Browsing effect:

Client:

BI Project notes Select output Analysis cube