ExoInsight enables you to create Tableau Hyper files directly off your Oracle Essbase data and hierarchies to create visualizations and dashboards. Tableau Hyper files allows you to consolidate millions or even billions of records into a single file. For more information on Tableau Hyper files, please refer to Tableau's online documentation.
This guide will walk you through setting up and working with ExoInsight to create Tableau Hyper files.
Prerequisites
- ExoInsight must be installed, configured, and enabled at your organization.
- You must know the name of the ExoInsight Essbase environment(s) that you would like to connect to. If you do not know the name of the ExoInsight Essbase environment name, please contact your ExoInsight admin.
Creating the Tableau Hyper File
ExoInsight exposes a REST API to provide an easily accessible way to perform most ExoInsight tasks. The REST API call to create a Tableau Hyper file is below.
POST: http(s)://ServerName:PortNumber/ExoInsight/tableau
BODY:
{
"license":"Enterprise",
"env":"ExoInsightEnvironmentName",
"user":"username",
"password":"password",
"application":"ApplicationName",
"cube":"CubeName",
"pov":"POVString"
}
For more details on this REST call, please see the REST API - Oracle Essbase Module article..
This REST call can be utilized from any application that can make a REST call. In the example below, the call is made from a regular PowerShell script using the pov method.
Param(
[string]$ExoInsightUrl = "http://localhost:9090/ExoInsight/tableau",
[string]$filename = "Tableau.zip",
[string]$destination = ""
)
$JSON = @'
{
"license":"Enterprise",
"env":"ProdEB",
"user":"admin",
"password":"password",
"application":"Sample",
"cube":"Basic",
"pov":"NONEMPTY;Children(Year);Children(Profit);Children(Product);Children(Market);Actual",
"dimensions":"Measures|Product|Market|Year|Scenario"
}
'@
try {
Invoke-RestMethod -Uri $ExoInsightUrl -Method Post -Body $JSON -ContentType "application/zip" -OutFile $filename
#Uncomment the following line to extract hyper file to $destination directory
#Expand-Archive -Path $filename -DestinationPath $destination
} catch {
$exception = $_.Exception
Write-Host "StatusCode:" $exception.Response.StatusCode.value__
Write-Host "StatusDescription:" $exception.Response.StatusDescription
}
Depending on how the REST call is made, the Tableau Hyper file will be created and contain the data specified as well as all the dimensions specified.
Upon opening the file in Tableau, you can access the data and dimensions specified. The PowerShell example above provides the following data and hierarchies in the Hyper file:
The data in contained in the Data table and provides the data in the standard ExoInsight format, which is perfect for building visualizations in Tableau. The dimension and hierarchy information are contained in the tables with the same name as the dimension, one table per dimension.
You can now build a visualization in Tableau, combine this Hyper file with others, or publish to Tableau Server.
Casabase Software