Cube Data and MDX Queries in R
jul 25,
2018
Using Microsoft olapR to Bring Analysis Services OLAP Data Into R Online Anaytical Processing (OLAP) and the R statistical language are both children of the 1990s. However, for much of the intervening time they inhabited different worlds. OLAP, and its query language MDX, lived in the world of databases and queries while R was the […]
Querying Analysis Services Data from Matlab
dec 14,
2016
Virtually all major statistical and analytical software packages have provision for obtaining data from a relational data source using SQL queries. Unfortunately, many of the tools that work with SQL do not help when the data source is an Analysis Services database and the query language is MDX or DAX. As mentioned in the previous […]
Writing DAX Summary Queries Using PowerPivot and Excel QueryTable Objects
feb 15,
2015
Don’t get me wrong. Excel PivotTables are one of the best things since pizza and beer. (And considering how much I enjoy that particular combination of snack and beverage, that’s really saying something.) Nevertheless, there are times when you want to take full control, write your own DAX query, and display the results in a […]