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

Sairamreddy shared this question 2 years 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