Skip to Main Content
Spotfire Ideas Portal

Data Lineage in Analyst

Hello

Sometime, before removing a column, we need to know where it is used in the DXPL file ?

Another calculated colomn, a visualisation, etc...

I would be really helpful to be able to ask "Where is it used?" and have in the answer all links to the place where we can found it

 

Thanks

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      May 25, 2018

      Thanks.
      As soon as the web site is not over (security problems right now), i get a look.

    • Guest
      Reply
      |
      May 25, 2018

      Hi, you are lucky as I wrote the queries for Oracle. Have a look at this article I wrote:

      https://community.tibco.com/wiki/tibco-spotfire-metadata-queries#toc-4

      The Library Items query should do most of what you want, you might need to tweak it a bit. The Data Sources query shows you a technique on how to get the data out of a BLOB. When you have a solution post it for the rest of the community to benefit from it. 

    • Guest
      Reply
      |
      May 25, 2018

      We use Oracle V11.

      The idea of Information Link looks good !

      Do you have example (sql query) please?

    • Guest
      Reply
      |
      May 25, 2018

      We tryed that, but the data we need is under a blob we can't use. => BLOBs can be converted.

       

      second point is that all users don't have access to the metadata database (lucky for us) => You don't need to give themn access to the database. If the query you want works you can build an Information Link and develop a Spotfire report that users can use to query your Spotfire Database securely and safely without having direct access to the database itself.

       

      What database version do you use?

    • Guest
      Reply
      |
      May 25, 2018

      Hello  Christian, second point is that all users don't have access to the metadata database (lucky for us)

    • Guest
      Reply
      |
      Mar 23, 2018

      If you have any example of query working, or information link based on the metadata database,and used in a dxp file, would be happy.

    • Guest
      Reply
      |
      Mar 23, 2018

      Hello Christian
      We tryed that, but the data we need is under a blob we can't use.

    • Guest
      Reply
      |
      Jun 30, 2017

      This could be done querying the metadata database which will show the Info Link to columns dependencies and the Info Link to Analysis.