How to make single report to take data from two different views ?

Sairamreddy shared this question 23 months ago
Answered

Dear Yellowfin Team,


In Client Organization Setup, We have two different Data Sources with them we created two different Views, Now how to make a report based on these two views, so that based on clients it should show relevant data.

Requested your immediate response

Thanks and Regards

Comments (2)

photo
1

Hi Siramreddy,

This is a two part solution:

Joining data between two different views at the report level is done with advanced sub-queries.

http://wiki.yellowfin.com.au/display/USER74/Sub+Queries

Limiting data based on what client is viewing the report is done with access filters:

http://wiki.yellowfin.com.au/display/USER74/Restricting+Data+with+Access+Filters

Getting these to work within your current set-up may be a bit tricky and may require a couple levels of access filters, but this is the general framework to build off of.

Let me know if this works for you.

Regards,

Nathan

photo
1

Hi Siramreddy,

I am going to close this for now, but let me know if there is anything else I can do to help.

Regards,

Nathan