Exploring ElastiCube data with ODBC connection to R
Problem
You want to determine if there are any problems with your dataset from the ElastiCube and whether the question you are asking for Sisense with R integration can be answered by the data that you have.
Solution
Installing the Sisense ODBC driver
- Download and Install Sisense ODBC driver from this link: Sisense ODBC
Note: Sisense ODBC is a licensed feature
Adding new Sisense Data ElastiCube Source to ODBC
- Open ODBC -> System DSN
- Add New Sisense ElastiCube data source.
- From the ElastiCube drop-down list, select the ElastiCube.
- Click Test to verify the connection to the ElastiCube.
Exploring ElastiCube data in R Environment
- Open an R console window.
- Install and load the “RODBC” Package into R
> install.packages("RODBC")> library(RODBC) - Open the connection to an ODBC ElastiCube Database.
>myconn <-odbcConnect("NW-Dan Kushner", uid="", pwd="")- Viewing ElastiCube Data.
- Submit a query and return a result for exploring in R
Discussion
Exploratory data analysis is the process of exploring your data, and it typically includes examining the structure and components of your dataset, the distributions of individual variables, and the relationships between two or more variables.
References
Updated 02-09-2024
