The logical design process begins with the analysis of the data source in the warehouse in order to identify clearly the dimensions and the facts contained in the star schema as data model for data warehouse, it is based on this analysis and according to the nature of the supported data the researcher uses one fact table and (7) dimension tables figure(3) explain Star schema of Local site as follows