允许探索立方体元数据
Usage
explore(olapCnn, cube = NULL, dimension = NULL, hierarchy = NULL, level = NULL)
Arguments
olapCnn
类对象“OlapConnection” 返回 OlapConnection()
cube
一个指定立方体名称的字符串
dimension
一个指定维度名称的字符串
hierarchy
一个表示层级名称的字符串
level
一个指定关卡名称的字符串
详细信息
explore
价值
打印立方体元数据。 返回 NULL。 如果参数无效，将引发错误。
备注
参数必须按顺序指定。 例如：为了探索层级结构，必须指定一个维度和一个立方体。
References
请参阅 execute2D 或 executeMD 获取参考资料。
示例
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