允許探索立方體的元資料
使用量
explore(olapCnn, cube = NULL, dimension = NULL, hierarchy = NULL, level = NULL)
論點
olapCnn
類別物件「OlapConnection」由 OlapConnection()
cube
一個指定立方體名稱的字串
dimension
一個指定維度名稱的字串
hierarchy
一個指定階層名稱的字串
level
一個指定關卡名稱的字串
詳細資料
explore
價值
列印立方體元資料。 傳回 NULL。 如果引數無效，則會擲回錯誤。
Notes
參數必須依序指定。 例如：為了探索階層結構，必須指定一個維度和一個立方體。
References
請參閱 execute2D 或 executeMD 以獲取參考資料。
Examples
cnnstr <- "Data Source=localhost; Provider=MSOLAP;"
ocs <- OlapConnection(cnnstr)
#Exploring Cubes
explore(ocs)
#Analysis Services Tutorial
#Internet Sales
#Reseller Sales
#Sales Summary
#[1] TRUE
#Exploring Dimensions
explore(ocs, "Analysis Services Tutorial")
#Customer
#Date
#Due Date
#Employee
#Internet Sales Order Details
#Measures
#Product
#Promotion
#Reseller
#Reseller Geography
#Sales Reason
#Sales Territory
#Ship Date
#[1] TRUE
#Exploring Hierarchies
explore(ocs, "Analysis Services Tutorial", "Product")
#Category
#Class
#Color
#Days To Manufacture
#Dealer Price
#End Date
#List Price
#Model Name
#Product Categories
#Product Line
#Product Model Lines
#Product Name
#Reorder Point
#Safety Stock Level
#Size
#Size Range
#Standard Cost
#Start Date
#Status
#Style
#Subcategory
#Weight
#[1] TRUE
#Exploring Levels
explore(ocs, "Analysis Services Tutorial", "Product", "Product Categories")
#(All)
#Category
#Subcategory
#Product Name
#[1] TRUE
#Exploring Members
#NOTE: -> indicates that the following member is a child of the previous member
explore(ocs, "Analysis Services Tutorial", "Product", "Product Categories", "Category")
#Accessories
#Bikes
#Clothing
#Components
#Assembly Components
#-> Assembly Components
#--> Assembly Components