New Topic

Community Topic Question Administration

Nathan Schroeder

NA Business Team

Assigned

Category Administration

Product Version 7.2

Report on views

Peter Ruth shared this question 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

Files:

The same question

Best Answer

Nathan Schroeder ●

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:

SELECT c.ReportName, b.ColumnName, d.ViewName
FROM 73yellowfin20170307.reportfield as a
JOIN 73yellowfin20170307.reportfieldtemplate as b
ON b.FieldTemplateId=a.FieldTemplateId
JOIN 73yellowfin20170307.reportheader as c
on a.ReportId=c.ReportId
JOIN 73yellowfin20170307.reportview as d
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

Replies (2)

Nathan Schroeder ● ●

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:

SELECT c.ReportName, b.ColumnName, d.ViewName
FROM 73yellowfin20170307.reportfield as a
JOIN 73yellowfin20170307.reportfieldtemplate as b
ON b.FieldTemplateId=a.FieldTemplateId
JOIN 73yellowfin20170307.reportheader as c
on a.ReportId=c.ReportId
JOIN 73yellowfin20170307.reportview as d
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

Reply URL

Peter Ruth ●

Hi Nathan,

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

Cheers,

Peter

URL

Nathan Schroeder ●

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

Reply URL