Data Dictionary

Douglas

July 14, 2016 00:12

Introduction

Having a centralized place to keep track of the tables and fields in an ElastiCube is useful for many reasons, including version control, design, information sharing, etc. The data dictionary plugin gives a single place to see all the tables and fields of an ElastiCube.

Purpose/Benefits

The data dictionary is a single place to research all the ElastiCubes' metadata.

Example

A link will be created in the header of Sisense.

That link will bring you to this page. You will need to select the server and the Elasticube you like. From there you can download the data to a CSV.

Steps

You will need to have previously implemented the 'Additional Links' plugin here. Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\Resources\ folder. After those files have been unzipped there, you may also have to restart the web server.

Comments

26 comments

Official comment

Jason Singer September 17, 2018 18:46

Hi Everyone.

Sisense is working on a Productized solution to expose the data dictionary functionality to additional user types in an upcoming version. We will be sure to keep you posted on the timeline of this important feature as development continues.

Best,

Jason

Permalink
Andrew Block July 14, 2016 00:31

Who all has security to see this? Will it be just Super and Designers? Or is it everyone?

0

Permalink
Douglas July 14, 2016 00:44

Hi Andrew,

As of right now the plugin is setup so that everyone can see the link, however only Admins will be able to interact with the dropdowns.

0

Permalink
Michael Becker July 14, 2016 08:07

Great thing Douglas!

One thing I found missing, back button to homepage or to previous page :) Alternatively Data Dictionary could open in new tab maybe.

Regards,

Michał

0

Permalink
Douglas July 14, 2016 18:02

Hi Michal,

Thank you for the input! I added links back to the home/admin pages for you.

0

Permalink
Michael Becker July 18, 2016 12:15

Thanks Douglas, works nicely :)

0

Permalink
Michael Becker July 18, 2016 12:15

Thanks Douglas, it works nicely!

0

Permalink
Michael Becker August 01, 2016 18:22

Hi Douglas,

This stopped working on 6.4. ElastiCube list does not populate anymore.

Regards,

Michał

0

Permalink
Douglas August 01, 2016 18:33

Hi Michal,

I tested after the upgrade and it is still working. Can you try to re-implement the plugin?

0

Permalink
Michael Becker August 01, 2016 19:38

Indeed, reloading plugin did the trick, thanks :)

0

Permalink
admin September 13, 2016 21:40

does this work on v6.0.2?

0

Permalink
Douglas September 16, 2016 16:28

Hello,

Yes it should. If that is not the case, please let us know.

0

Permalink
Ahuva Shabtai September 22, 2016 21:19

Hi Douglas,

I am on version 6.2.2.35, and I am able to select the 'localhost' server (it is the only option), and the cube that I would like to see the data for. This returns the Created date, and the last built date.

I do not see the fields in my elasticube though. Instead I see: "Note: The 'undefined' rows are joins in the ElastoCube".

Any ideas what I might be doing wrong?

0

Permalink
David Wit September 27, 2016 14:56

Can you export the list? It would be nice to be able to export it into MS Excel so that we can keep track of tables and columns used in all our ElastiCubes to ensure we know the effect of schema changes.

0

Permalink
Frank Esteve October 26, 2016 19:42

Users of the data dictionary have requested the ability to view the formulas used to generate the custom fields within the elasticube. This would be helpful in developing the necessary documentation for our dashboard content.

0

Permalink
Douglas November 01, 2016 21:00 (Edited November 01, 2016 21:00)

@David, The list is exportable. The download button is at the top left of the page next to the words 'Data Dictionary'.

@Frank, unfortunately this is currently unavailable. The page is based on the API's and that is not part of the information that is available. I apologize for the inconvenience.

1

Permalink
Jim Thomas May 19, 2017 19:09

Douglas,

Doesn't appear to work in v6.5 or v6.6. There are no choices presented for the server or ElastiCube even if on the host machine. Are you planning to update? We have some new users that this would be helpful for.

Thanks, Jim

0

Permalink
Mohamed May 31, 2017 15:37

Hi Douglas,

Would it be possible to allow designers to use this somehow?

Best,

Mohamed

0

Permalink
Douglas May 31, 2017 16:06

Hi Mohamed,

Unfortunately it is not possible to allow any users other than Admin users. The basis for this plugin is an API that only allows admin access. My apologies.

Thank you

Douglas

0

Permalink
Robert Choquette January 31, 2018 20:43

This doesn't seem to work with V7. Is there an update in the works?

Cheers,

Robert

5

Permalink
Tim St.Cyr March 08, 2018 19:43

Doesn't work in V7 any updates?

1

Permalink
Todd Winton April 19, 2018 14:00

Add my name to the list of needing this in v7 until data viewer role is added to the web based ecube manager is made available.

2

Permalink
Eric Pouliot August 29, 2018 00:42

Douglas, can you fix this for V7? Thanks!

0

Permalink
Alon Ahronberg December 09, 2018 09:40

Hi All,

In v7.2 we released the ability to create Data Dictionaries, providing you greater flexibility and improved ease-of-use when modeling your data, you can now tag your data and add descriptions to it.

For more information, please refer to our documentation .

Regards

Alon Ahronberg

Product Manager

0

Permalink
Matthias Braier April 12, 2019 13:04

Hi Alon,

will the descriptions and tags be part of the REST API anytime soon. We want to make Sisense Elasticubes to be the Single-Source-Of-Truth regarding definitions for metrics and dimension but would like to avoid maintaining the dictionary via web frontend.

FYI - I also already created a ticket for this.

Best,

Matthias

1

Permalink
Sai Krishna May 26, 2019 09:46

Hi,

We are using 7.2 version and want to create Data Dictionary. I would like to list all the tables and columns in Sisense and explain each column in excel. Please guide me the approach.

Regards,

Sai Krishna.

0

Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?