Working with OLAP Cubes in R/R-Studio

shiny
rstudio
r

#1

Hi experts,

I have a given OLAP cube which is modeled as a star scheme using classical dimensions and facts. Work has been invested to create this reporting view using the star schema. I am looking for ways to report on this star scheme without programming everything from scratch.

How do you work with an OLAP cube within R/R-Studio/Shiny (Slicing, Dicing, Pivoting, Drill-Down etc.) ? Is there a package which provides a good "Framework" or is R/R-Studio the wrong platform ?

Br,

Dennis


#2

Never done anything with them myself, but I did find this article:
https://docs.microsoft.com/en-us/sql/advanced-analytics/r/using-data-from-olap-cubes-in-r?view=sql-server-2017 (though it seems to involve SQL Server too, so ¯\(°_o)/¯)

Couple other possible leads:

https://jangorecki.gitlab.io/data.cube/library/data.cube/html/data.cube.html