[saiku] 通过 saiku 的 DEMO 分析 connection

示例: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//钻取
}
上一篇:Asp.Net Core实战(干货)


下一篇:[luogu2571][bzoj1857][SCOI2010]传送门【三分套三分】