示例：FOODMART

connection:        foodmartcatalog:        　  FoodMartschema:            FoodMartcube：         　　 Sales/HR/Sales 2/.../=========================== Cube 1 ：Sales ==============================关注三个属性：【Dimensions】、【measures】、【properties】【Dimensions：5个】[[Customer], [Product], [Promotion], [Store], [Time]](1)name:Customerhierarchies：[[Customer].[Customers], [Customer].[Education Level], [Customer].[Gender], [Customer].[Marital Status], [Customer].[Yearly Income]](2)name:Producthierarchies：[[Product].[Products]](3)name:Promotionhierarchies：[[Promotion].[Media Type], [Promotion].[Promotions]](4)name:Storehierarchies：[[Store].[Stores], [Store].[Store Size in SQFT], [Store].[Store Type]](5)name:Timehierarchies：[[Time].[Time], [Time].[Weekly], [Time].[Date Only]]    【measures:8个】(1) name:Unit SalesuniqueName:[Measures].[Unit Sales]measureGroup: SalesdimensionUniqueName:[Measures](其他一样)hierarchyUniqueName:[Measures](其他一样)levelUniqueName:[Measures].[MeasuresLevel](其他一样)(2)name:Store CostuniqueName:[Measures].[Store Cost]measureGroup: Sales(3)name:Store SalesuniqueName:[Measures].[Store Sales]measureGroup: Sales(4)name:Sales CountuniqueName:[Measures].[Sales Count]measureGroup: Sales(5)name:Customer CountuniqueName:[Measures].[Customer Count]measureGroup: Sales(6)name:Promotion SalesuniqueName:[Measures].[Promotion Sales]measureGroup: Sales(7)name:ProfituniqueName:[Measures].[Profit]measureGroup: null(8)name:Profit GrowthuniqueName:[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 Budgethierarchies：[[Actual VS Budget].[Type]](2)name:Departmenthierarchies：[[Department].[Department], [Department].[Department Description]](3)name:Employeehierarchies：[[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:Storehierarchies：[[Store].[Stores], [Store].[Store Size in SQFT], [Store].[Store Type]](5)name:Timehierarchies：[[Time].[Time]]    【measures:5个】(1) name:Org SalaryuniqueName:[Measures].[Org Salary]measureGroup: HRdimensionUniqueName:[Measures](其他一样)hierarchyUniqueName:[Measures](其他一样)levelUniqueName:[Measures].[MeasuresLevel](其他一样)(2)name:CountuniqueName:[Measures].[Count]measureGroup: HR(3)name: Number of EmployeesuniqueName:[Measures].[Number of Employees]measureGroup: HR(4)name:Employee SalaryuniqueName:[Measures].[Employee Salary]measureGroup: null(5)name:Avg SalaryuniqueName:[Measures].[Avg Salary]measureGroup: null【properties】{org.saiku.query.explain=true,//解释org.saiku.connection.scenario=false,//场景 saiku.olap.query.drillthrough=true//钻取}其他的也差不多，就不一一列举了

 

示例：EARTHQUICKS

connection:        earthquakescatalog:        Global Earthquakesschema:            Global Earthquakescube:            Earthquakes(1个)=========================== Cube：Earthquakes ==============================关注三个属性：【Dimensions】、【measures】、【properties】【Dimensions：3个】(1)日期name:DateuniqueName:[Date]caption：Datehierarchies：[[Date].[Time]]visible:true(2)位置name:LocationuniqueName:[Location]caption：Locationhierarchies：[[Location].[Place], [Location].[Latitude], [Location].[Longitude]]visible:true(3)网络name:NetworkuniqueName:[Network]caption：Networkhierarchies：[[Network].[Name]]visible:true    【measures:11个】(1) 平均海拔name: Average MagnitudeuniqueName:[Measures].[Average Magnitude]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](2)平均深度name: Average DepthuniqueName:[Measures].[Org Salary]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](3)平均裂缝name: Average GapuniqueName:[Measures].[Average Gap]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](4)name: Average Reporting StationsuniqueName:[Measures].[Average Reporting Stations]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](5)name: Sum MagnitudeuniqueName:[Measures].[Sum Magnitude]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](6)name: Sum Reporting StationsuniqueName:[Measures].[Sum Reporting Stations]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](7)name: Max MagnitudeuniqueName:[Measures].[Max Magnitude]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](8)name: Max DepthuniqueName:[Measures].[Max Depth]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](9)name: Max GapuniqueName:[Measures].[Max Gap]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](10)name: Max Reporting StationsuniqueName:[Measures].[Max Reporting Stations]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel](11)name: Number of quakesuniqueName:[Measures].[Number of quakes]measureGroup: AveragedimensionUniqueName:[Measures]hierarchyUniqueName:[Measures]levelUniqueName:[Measures].[MeasuresLevel]【properties】{org.saiku.query.explain=true,//解释org.saiku.connection.scenario=false,//场景 saiku.olap.query.drillthrough=true//钻取}