示例：FOODMART
connection: foodmart catalog: FoodMart schema: FoodMart cube： Sales/HR/Sales 2/.../ =========================== Cube 1 ：Sales ============================== 关注三个属性：【Dimensions】、【measures】、【properties】 【Dimensions：5个】 [[Customer], [Product], [Promotion], [Store], [Time]] (1) name:Customer hierarchies：[[Customer].[Customers], [Customer].[Education Level], [Customer].[Gender], [Customer].[Marital Status], [Customer].[Yearly Income]] (2) name:Product hierarchies：[[Product].[Products]] (3) name:Promotion hierarchies：[[Promotion].[Media Type], [Promotion].[Promotions]] (4) name:Store hierarchies：[[Store].[Stores], [Store].[Store Size in SQFT], [Store].[Store Type]] (5) name:Time hierarchies：[[Time].[Time], [Time].[Weekly], [Time].[Date Only]] 【measures:8个】 (1) name:Unit Sales uniqueName:[Measures].[Unit Sales] measureGroup: Sales dimensionUniqueName:[Measures](其他一样) hierarchyUniqueName:[Measures](其他一样) levelUniqueName:[Measures].[MeasuresLevel](其他一样) (2) name:Store Cost uniqueName:[Measures].[Store Cost] measureGroup: Sales (3) name:Store Sales uniqueName:[Measures].[Store Sales] measureGroup: Sales (4) name:Sales Count uniqueName:[Measures].[Sales Count] measureGroup: Sales (5) name:Customer Count uniqueName:[Measures].[Customer Count] measureGroup: Sales (6) name:Promotion Sales uniqueName:[Measures].[Promotion Sales] measureGroup: Sales (7) name:Profit uniqueName:[Measures].[Profit] measureGroup: null (8) name:Profit Growth uniqueName:[Measures].[Profit Growth] measureGroup: null 【properties】 { org.saiku.query.explain=true,//解释 org.saiku.connection.scenario=false,//场景 saiku.olap.query.drillthrough=true//钻取 } =========================== Cube 2 ： HR ============================== 【Dimensions：5个】 [[Actual VS Budget], [Department], [Employee], [Store], [Time]] (1) name:Actual VS Budget hierarchies：[[Actual VS Budget].[Type]] (2) name:Department hierarchies：[[Department].[Department], [Department].[Department Description]] (3) name:Employee hierarchies：[[Employee].[Employees], [Employee$Closure].[Employee$Manager Id$Parent], [Employee].[Position], [Employee].[Manager Id], [Employee].[Employee Id], [Employee].[Store Id], [Employee].[Store Type], [Employee].[Pay Type], [Employee].[Management Role], [Employee].[Position Title], [Employee].[Marital Status], [Employee].[Gender], [Employee].[Salary], [Employee].[Education Level]] (4) name:Store hierarchies：[[Store].[Stores], [Store].[Store Size in SQFT], [Store].[Store Type]] (5) name:Time hierarchies：[[Time].[Time]] 【measures:5个】 (1) name:Org Salary uniqueName:[Measures].[Org Salary] measureGroup: HR dimensionUniqueName:[Measures](其他一样) hierarchyUniqueName:[Measures](其他一样) levelUniqueName:[Measures].[MeasuresLevel](其他一样) (2) name:Count uniqueName:[Measures].[Count] measureGroup: HR (3) name: Number of Employees uniqueName:[Measures].[Number of Employees] measureGroup: HR (4) name:Employee Salary uniqueName:[Measures].[Employee Salary] measureGroup: null (5) name:Avg Salary uniqueName:[Measures].[Avg Salary] measureGroup: null 【properties】 { org.saiku.query.explain=true,//解释 org.saiku.connection.scenario=false,//场景 saiku.olap.query.drillthrough=true//钻取 } 其他的也差不多，就不一一列举了
示例：EARTHQUICKS
connection: earthquakes catalog: Global Earthquakes schema: Global Earthquakes cube: Earthquakes(1个) =========================== Cube：Earthquakes ============================== 关注三个属性：【Dimensions】、【measures】、【properties】 【Dimensions：3个】 (1)日期 name:Date uniqueName:[Date] caption：Date hierarchies：[[Date].[Time]] visible:true (2)位置 name:Location uniqueName:[Location] caption：Location hierarchies：[[Location].[Place], [Location].[Latitude], [Location].[Longitude]] visible:true (3)网络 name:Network uniqueName:[Network] caption：Network hierarchies：[[Network].[Name]] visible:true 【measures:11个】 (1) 平均海拔 name: Average Magnitude uniqueName:[Measures].[Average Magnitude] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (2)平均深度 name: Average Depth uniqueName:[Measures].[Org Salary] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (3)平均裂缝 name: Average Gap uniqueName:[Measures].[Average Gap] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (4) name: Average Reporting Stations uniqueName:[Measures].[Average Reporting Stations] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (5) name: Sum Magnitude uniqueName:[Measures].[Sum Magnitude] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (6) name: Sum Reporting Stations uniqueName:[Measures].[Sum Reporting Stations] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (7) name: Max Magnitude uniqueName:[Measures].[Max Magnitude] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (8) name: Max Depth uniqueName:[Measures].[Max Depth] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (9) name: Max Gap uniqueName:[Measures].[Max Gap] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (10) name: Max Reporting Stations uniqueName:[Measures].[Max Reporting Stations] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] (11) name: Number of quakes uniqueName:[Measures].[Number of quakes] measureGroup: Average dimensionUniqueName:[Measures] hierarchyUniqueName:[Measures] levelUniqueName:[Measures].[MeasuresLevel] 【properties】 { org.saiku.query.explain=true,//解释 org.saiku.connection.scenario=false,//场景 saiku.olap.query.drillthrough=true//钻取 }