Discovery Data Catalog Export

Dave_Carbery
1 yr ago
12replies
Answered

Hello folks.
Is it possible to export the data catalog from a discovery object in a format which is not .pdf?
I see I can export the data catalog from a data model object as a json file, which allows me to analyze in more detail.

Thanks, Dave

- NPANS
- 1 yr ago
- Reported - view
You can import/export the definitional aspects from the admin. The Data Catalog export in Discovery is for end users - who typically would not want to use a JSON file.
- Dave_Carbery
  
  1 yr ago
  
  Reported - view
  NPANS Brilliant - many thanks for that. I hadn't been able to find my way to that location, knowing that there must be a way to retrieve that information as the .pdf catalog must have been generated from a .json (well, to my eye at least).
  Cheers, Dave
- "making the sophisticated simple"
- AviPerez
- 1 yr ago
- Reported - view
- Dave_Carbery
  
  1 yr ago
  
  Reported - view
  Avi Perez I was just about to ask for another pointer on where to find...many thanks!
- Dave_Carbery
- 1 yr ago
- Reported - view
Avi Perez Actually, I may have communicated the original question poorly. Or, more likely as I'm still learning, I might be missing something. What I'm trying to find out...are the 'instructions' for generating a discovery (e.g. a json file) available.
My actual context is: if a model has multiple tables and in two different tables there exist a column in each with the same name, can I identify from the discovery object which table in the model that column originates from?

Thanks, Dave
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Reported - view
Hi Dave,

Discover objects are not available as JSON exports.

Hope that helps.

Ian
- Dave_Carbery
  
  1 yr ago
  
  Reported - view
  Ian Macdonald Hi Ian, thanks for confirming what I suspected - I reckoned I would have found some way forward with finding some doc wrt that.
  It might be naivety, but, the rationale for not being able to access a json export for a discovery, as per a model object....is this technical, lack of need, conceptual? I'm working on trying to deconvolute some complex discoveries that have evolved over time and working with an 'in' and and 'out' json would have made this a massively more tractable task.
  Hope you're well, all the best, Dave
- Senior Director of Product
  
  Ian_Macdonald
  
  1 yr ago
  
  Reported - view
  Dave Carbery we may have a different approach / solution. Watch yhis dpace.
- Dave_Carbery
  
  1 yr ago
  
  Reported - view
  Ian Macdonald hmmmmm...will do
- David_Gordon
- 1 yr ago
- Reported - view
Hi Dave,

You can use the Pyramid usage model that will allow you to create a discovery with all the required columns.

Instructions on how to implement the model can be found here Pyramid Usage Model and Analysis - Tech Blogs - Pyramid Analytics Community Forum

In this example I have used the item name, the column type and the column unique name (this will display both the table and the column name.) You can then export the results to excel if required.
- Michael_Raam.1
- 1 yr ago
- Reported - view
Hi,

If you want to know what table a column is coming from, one option is to open a custom member / measure in script mode and drag the column into it.

The table name should be visible as a part of the unique name of the column.

It would be useful to have a popup or something similar that shows the unique name when hovering over the column
- "making the sophisticated simple"
- AviPerez
- 1 yr ago
- Reported - view
The new API 3.0 in our latest release Pyramid 2023.10 as this functionality.