Get CSV of ElastiCubes, Tables, and Fields Metadata

Follow

Sam Ovenshine

April 17, 2018 20:00

Introduction

This script exports to CSV a complete list of your ElastiCube servers, ElastiCubes, tables, fields, and field data types.

Pairs well with https://support.sisense.com/hc/en-us/community/posts/360004369133-Get-CSV-Of-ElastiCube-Dependencies.

Prerequisites
Tested in Python 3.6. Requires Sisense 7.1+.

Python Packages
Requests
JSON
Pandas

Steps

1. Download and unzip the file here.

2. Update the configuration section. For authentication, you can hard-code a token or use the program to generate a token.

3. Run the script

Sample Output

2

• 

  Ian Tebbutt July 16, 2018 03:43

  Hi Sam,

         We've been using this script to document our Elasticubes, now I'm trying 7.2 it's stopped working reports that the keys from the datasource API call aren't right. I can't call that API from Swagger as it requires a / character for the fully formed Data Source name.

  I'd also be interested in seeing the table Tag, Description and field Description fields in the output - is that possible?

  Cheers

   

  Ian

  0

  Comment actions Permalink

Please sign in to leave a comment.