[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//钻取
}