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

34 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

Comment actions 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

Comment actions 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

Comment actions 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

Comment actions 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

Comment actions Permalink
Michael Becker July 18, 2016 12:15

Thanks Douglas, works nicely :)

0

Comment actions Permalink
Michael Becker July 18, 2016 12:15

Thanks Douglas, it works nicely!

0

Comment actions 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

Comment actions 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

Comment actions Permalink
Michael Becker August 01, 2016 19:38

Indeed, reloading plugin did the trick, thanks :)

0

Comment actions Permalink
admin September 13, 2016 21:40

does this work on v6.0.2?

0

Comment actions Permalink
Douglas September 16, 2016 16:28

Hello,

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

0

Comment actions 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

Comment actions 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

Comment actions 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

Comment actions 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

Comment actions 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

Comment actions Permalink
Mohamed May 31, 2017 15:37

Hi Douglas,

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

Best,

Mohamed

0

Comment actions 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

Comment actions 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

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

Doesn't work in V7 any updates?

1

Comment actions 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

Comment actions Permalink
Eric Pouliot August 29, 2018 00:42

Douglas, can you fix this for V7? Thanks!

0

Comment actions 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

Comment actions 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

Comment actions Permalink
Siva 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

Comment actions Permalink
Dennis Gerads June 20, 2019 16:38

@Jason Singer

Back on September 17, 2018 you had posted that Sisense is working on a Productized solution to expose the data dictionary functionality to additional user types in an upcoming version.

Is there any update on it or document that we can reference to get it enabled?

Thanks,

- Dennis Gerads

0

Comment actions Permalink
Jason Singer June 20, 2019 17:16

@alon, the PM who commented previously can likely answer this best @dennis.

0

Comment actions Permalink
Dennis Gerads June 25, 2019 13:55

Thanks Jason. I reviewed that document on what was done and that just expanded what you can all enter into Sisense for the Data Dictionary. But there's still no way for users (non-admin) to interactively access the Data Dictionary. We'll look to see what the API can provide and maybe export it and use some other reporting tool for them. Is there any timeline when this Plug-in will updated to work with 7.4 and non-admin users?

Thanks everyone,

- Dennis

0

Comment actions Permalink
Paul Furman January 17, 2020 19:30

Any updates on this project? It definitely doesn't work in 8.x+

1

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?