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
Thanks.
As soon as the web site is not over (security problems right now), i get a look.
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.
We use Oracle V11.
The idea of Information Link looks good !
Do you have example (sql query) please?
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?
Hello Christian, second point is that all users don't have access to the metadata database (lucky for us)
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.
Hello Christian
We tryed that, but the data we need is under a blob we can't use.
This could be done querying the metadata database which will show the Info Link to columns dependencies and the Info Link to Analysis.