Abstract: According to the actual needs of the local mobile communications,you need to design the hierarchy of data marts,and its structure consists of comprehensive query-oriented data,and data layers of detail-oriented queries,which focuses on the overall design and the primary table design for account theme,business theme,competition theme,user theme,new theme,major clients theme,such as modules.

Key words: Data marts,Hierarchy,Theme module