execute2D: olapR execute2D Methods
Takes a Query object or an MDX string, and returns the result as a data frame.
Usage
execute2D(olapCnn, query)
execute2D(olapCnn, mdx)
Arguments
olapCnn
Object of class "OlapConnection" returned by OlapConnection()
query
Object of class "Query" returned by Query()
mdx
String specifying a valid MDX query
Details
If a query is provided:
execute2D
validates a query object (optional), generates an mdx query string from the query object, executes the mdx query across, and returns the result as a data frame.
If an MDX string is provided:
execute2D
executes the mdx query, and returns the result as a data frame.
Value
A data frame if the MDX command returned a result-set.
TRUE
and a warning if the query returned no data.
An error if the query is invalid
Notes
Multi-dimensional query results are flattened to 2D using a standard flattening algorithm.
References
Creating a Demo OLAP Cube (the same as the one used in the examples):
See also
Query, OlapConnection, executeMD, explore, data.frame
Examples
cnnstr <- "Data Source=localhost; Provider=MSOLAP;"
olapCnn <- OlapConnection(cnnstr)
qry <- Query()
cube(qry) <- "[Analysis Services Tutorial]"
columns(qry) <- c("[Measures].[Internet Sales Count]", "[Measures].[Internet Sales-Sales Amount]")
rows(qry) <- c("[Product].[Product Line].[Product Line].MEMBERS")
pages(qry) <- c("[Sales Territory].[Sales Territory Region].[Sales Territory Region].MEMBERS")
result1 <- execute2D(olapCnn, qry)
mdx <- "SELECT {[Measures].[Internet Sales Count], [Measures].[Internet Sales-Sales Amount]} ON AXIS(0), {[Product].[Product Line].[Product Line].MEMBERS} ON AXIS(1), {[Sales Territory].[Sales Territory Region].[Sales Territory Region].MEMBERS} ON AXIS(2) FROM [Analysis Services Tutorial]"
result2 <- execute2D(olapCnn, mdx)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें