| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | keywords | monikerRange | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
explore function (olapR) |
Allows for exploration of cube metadata. |
rothja |
jroth |
07/15/2019 |
sql |
machine-learning |
reference |
|
>=sql-server-2016||>=sql-server-linux-ver15 |
Allows for exploration of cube metadata
explore(olapCnn, cube = NULL, dimension = NULL, hierarchy = NULL, level = NULL)
Object of class "OlapConnection" returned by OlapConnection()
A string specifying a cube name
A string specifying a dimension name
A string specifying a hierarchy name
A string specifying a level name
explore
Prints cube metadata. Returns NULL. An error is thrown if arguments are invalid.
Arguments must be specified in order. For example: In order to explore hierarchies, a dimension and a cube must be specified.
See execute2D or executeMD for references.
query, OlapConnection, executeMD, execute2D
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