• Jim Thomas

Sisense Data Models Data Dictionary

Updated: Jul 25

isense documentation lists Data Dictionary as one of the product features. Documentation for that is shown here: Creating Data Dictionaries. However, this feature only supports the creation of table and column description information. This is helpful, but in working with Sisense since 2014, I've often wished for a centralized solution that brought the table and column metadata (including descriptions) to a centralized location. In the olden days, Sisense late v5 and v6, there was a community plugin that exported an ElastiCube's metadata to a .csv file. It stopped working around v7.

Long story short, recently I decided to develop a desktop app (Windows/Mac) that utilizes several Sisense REST API's to build a Data Dictionary for a selected Data Model (Live or ElastiCube). My app (Sisense Linux only) is now at the MVP stage. It functions as follows:

  • When launched it presents a login window for a Sisense admin user. See screen shot below:

  • On a successful login, it presents a selection window that allows you to select the Data Model (Live or ElastiCube) to generate a data dictionary for from a drop down list of all data models on your Sisense server . See screen shot below:

  • Once a selection is made, an Excel file containing the selected Data Model metadata is exported to a folder on your local machine user root directory.

  • That Excel file is copied from your local directory to a predefined folder in the Sisense My Files file store: Admin > System Management > File Management > DataModels_DataDictionaries

  • As you update your individual Data Model Data Dictionary files they are exported and the previous versions are overwritten. This ensures you always have the latest versions available.

  • I created an ElastiCube that sources it's data from the Excel files in the My Files folder.

  • Of course this screenshot shows just a few of the columns from the Data Dictionary data model.

I'm very interested in hearing from folks in the community to get your comments and suggestions. Please post in the Comment box below or call/email me using the info at the top of the page.

18 views0 comments