cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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
Version history
Last update:
‎03-02-2023 09:44 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy