Filters in Union Not Pulling Values from Union Subquery (multiple connections)

Larry Beasley shared this problem 36 days ago
Completed

I have a report that uses multiple connections in order to act as a master query. The filter in the master query is tied to A_CONN while the sub query (union) is tied to B_CONN but when I cache the filter for department as an example I'm only getting the departments from A_CONN. I think it has something to do with the connections but the info is not pulling forward. If there is a work around please advise.

Replies (6)

photo
1

Hello Larry,

My name is Deepak Chaganti from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #32397
Case Title: Filters in Union Not Pulling Values from Union Subquery (multiple connections)


Request for Additional Information:

To better understand and expedite the resolution of your case, please provide me following details:

  • The info.jsp file for this instance in HTML format. In order to get this file please follow the instructions in the following link:

https://community.yellowfinbi.com/topic/how-to-get-the-info-jsp

  • A screenshot to illustrate the current master and sub query setup that you have in your report.
  • Have we used the advanced subquery and selected the required data source?:
    0e1eee1c2b247bba5d38265170f9d9a9
  • Which of the following options are we using to cache the values from second source? :
    0f6f5df811b0653b5132b9d4f36a0dbc
  • What happens when we click 'Refresh now'? Do we see the correct values? :


Sincerely,

Deepak Chaganti

Yellowfin Technical Support Engineer

photo
1

Hi Deepak,

My install is through Credible so you should easily find it. Lastly, the method described above is the standard method and does not pull data from the underlying union.

photo
1

Hi Larry,

Thanks for letting me know.

I am trying to setup a similar report in my environment to test the scenario. Could you please help with the information:

1. Which of the following options are we using - Filter value:

0f6f5df811b0653b5132b9d4f36a0dbc


2. What values are displayed when we click on 'Refreh now'?

Thanks,

Deepak

photo
1

Hi Larry,

Hope you had a great weekend.

Just wanted to check-in and see if you had a chance to looking into my previous response requesting further details about the report/filter options.

Kind regards,

Deepak Chaganti

photo
1

Hello Larry,

I wanted to follow up with you regarding the information I requested in my last email. This will allow me to further troubleshoot this issue and work towards a resolution. I know you may be busy but this information is necessary to solve this issue.

If you are unavailable right now, you can always contact us again at a later time by opening a new ticket. I will close this ticket by the end of business tomorrow if I do not receive a reply.

Please reply to this email and I will continue to work to resolve this issue.

Thank you,

Deepak Chaganti

Yellowfin Technical Support

photo
1

Hi Larry,


I hope things are going well with you.


Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.


Kind regards,

Deepak Chaganti

Leave a Comment
 
Attach a file