Abstract: Data warehouse and OLAP are two of the significant new technologies in the database area.The positive results given by internal scholars lay particular emphasis on multidimensional model.This paper focuses on data analysis based OLAP technology and it is may be more useful to enterprise users.After giving basic concepts about OLAP and MDX,this paper illustrates the application procedure of multidimensional analysis technologies through an appliance wholesale company.

Key words: OLAP, MDX, data warehouse