executeMD: olapR executeMD Methods
Takes a Query object or an MDX string, and returns the result as a multi-dimensional array.
Usage
executeMD(olapCnn, query)
executeMD(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:
executeMD
validates a Query object (optional), generates an mdx query string from the Query object, executes the mdx query across an XMLA connection, and returns the result as a multi-dimensional array.
If an MDX string is provided:
executeMD
executes the mdx query across an XMLA connection, and returns the result as a multi-dimensional array.
Value
Returns a multi-dimensional array. Returns an error if the Query is invalid.
Notes
References
Creating a Demo OLAP Cube (the same as the one used in the examples): Multidimensional Modeling (Adventure Works Tutorial)
See also
Query, OlapConnection, execute2D, explore, array
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 <- executeMD(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 <- executeMD(olapCnn, mdx)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें