示例：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//钻取
}