Report on views

Peter Ruth shared this question 3 years ago
Answered

Hi,

We're looking on a way to be able to easily report and drill down on views in the system (showing active fields and associated reports). Also the same for reports that are using the views with their active fields.

I know there is 'usage' info that can be gathered using the canned reports but we need the data that you can find when clicking on each view or report, in an easier format than clicking each one.

I've attached a file with some YF images which might help.

Essentially we want to be able to (against our views/reports) go:

View->Reports->Columns, or

View->Columns->Reports

As a minimum we want to be able to see all the fields/columns in the views if they're available for use in the reports or not currently displayed.

Regards,

Peter

Best Answer
photo

Hi Peter,


In order to get this information you will need to query the configuration database, either through a direct query or through creating a report based off a modification of the Admin package.


I was able to achieve this with the following query:


  1. SELECT c.ReportName, b.ColumnName, d.ViewName
  2. FROM 73yellowfin20170307.reportfield as a
  3. JOIN 73yellowfin20170307.reportfieldtemplate as b
  4. ON b.FieldTemplateId=a.FieldTemplateId
  5. JOIN 73yellowfin20170307.reportheader as c
  6. on a.ReportId=c.ReportId
  7. JOIN 73yellowfin20170307.reportview as d
  8. on b.ViewId=d.ViewId


Please let me know if this works for you or if you have any questions on implementing this.


Regards,

Nathan

Comments (2)

photo
1

Hi Peter,


In order to get this information you will need to query the configuration database, either through a direct query or through creating a report based off a modification of the Admin package.


I was able to achieve this with the following query:


  1. SELECT c.ReportName, b.ColumnName, d.ViewName
  2. FROM 73yellowfin20170307.reportfield as a
  3. JOIN 73yellowfin20170307.reportfieldtemplate as b
  4. ON b.FieldTemplateId=a.FieldTemplateId
  5. JOIN 73yellowfin20170307.reportheader as c
  6. on a.ReportId=c.ReportId
  7. JOIN 73yellowfin20170307.reportview as d
  8. on b.ViewId=d.ViewId


Please let me know if this works for you or if you have any questions on implementing this.


Regards,

Nathan

photo
1

Hi Nathan,

Thanks for the tip. This has got me headed in the right direction now.

Cheers,

Peter

photo
photo
1

Hi Peter,


Glad to hear it! I am going to close this ticket for now, but if you run into any issues, just respond and the case will be re-opened.


Regards,

Nathan


Closed Request Survey