Dashboard Drill Down Interactions Broken

Hello Justin,

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: #32459
Case Title: Dashboard Drill Down Interactions Broken

Issue Overview:

If the option below is unchecked, the drill-down function will not be available.

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 or a screenrecording to illustrate the problem that you are facing.
• We can identify if the original dashboard is modify from the browse page:
  
  

Sincerely,

Deepak Chaganti

Yellowfin Technical Support Engineer

The drill toggle screenshot shows I have those options checked

The drill interactions screenshot shows I have the interaction linked to the extra report

The interact allow screenshot shows interactions are turned on for the extra report

I have also attached the info.jsp file

The screen capture of the issue is too large, I will try to describe the issue again and if that doesn't work maybe we can schedule a time to meet and review this

Starting using screenshot 1 below, I have this dashboard which has drill down for the pie chart and interactivity that is supposed to apply to the bar chart. This is the same report that I provided the other screeshots for showing the drill set up.

Screenshot 2 shows after click the MASS option in the pie chart. This drills the pie chart, but it does not apply to the bar. This was previously working as expected to filter the bar chart.

All the attempts to fix this I detailed in my original post were done to this dashboard

However, if I create a page on a different dashboard with these same reports and do the same set up, the drill interactivity works fine (files screenshot3 and screenshot4).

One thing to note, this is being done using the exact same reports and views as well.

Please let me know if there is anything else you need me to provide

Hi Justin,

Thank you for the detailed explanation of the setup and the steps you have already taken.

I think there are no additional options to control report interactions on the dashboard. To investigate further, I have created a new YF 9.9 instance on my local machine and attempted to replicate the dashboard configuration to see if I can reproduce the issue. Please refer to the attached screen recording for more details.

Next steps:

Could you please check the browser console logs for any errors that may occur when clicking on the drill-down report? This information will help us identify the root cause of the problem.:

Additionally, could you please enable DEBUG logging as outlined in the following article: https://community.yellowfinbi.com/knowledge-base/article/how-do-i-turn-on-debug-logging-within-yellowfin-log-file Once DEBUG logging is enabled, please recreate the issue (i.e., click on the drill-down report) to capture any relevant log entries. Kindly share the logs after recreating the issue along with the timestamp at which you have recreated.

I saw the same issue with the RRGGBB format as your screenshot. I am assuming that is not related.

I saw an issue in the console that I will attach as two screenshots (first being issue, then source)

I turned on debug, went through a quick process I will detail below so you can follow, then turned it off

As far as I can tell only the things I did were logged, but it does fill up quick

Here is the process I took:

• Navigated to a dashboard named Konsyl Dash (Copy)
• I got the canvas-uuid value from the code section of the dashboard editor (2ff17765-0355-4676-83c7-6412f17461ad)
• Clicked on the Mass option from our earlier screenshots to drill. Drill only applied to the pie chart, not the bar chart. I think I might have right clicked the chart to drill up and tried to drill again.
• I navigated to another dashboard called Justin Test Dash and then the page YTD tst
• Canvas uuid 595dec60-ae44-444f-9eac-fea621fb15be
• Again, clicked on Mass to drill, which applied to both charts as expected
• I then navigated back to the Konsyl Dash (Copy) dashboard and repeated the drill process, which failed again

I was trying to get you two logs of failure and one for success

Please let me know if you need anything else!

Hi Justin,

Thanks for sharing the information.

The error message in the console log appears to be related to a Chrome-specific change in behavior, as outlined here: https://developer.chrome.com/docs/web-platform/deprecating-unload#why_deprecate_the_unload_event. At this stage, I do not believe this error is affecting the actual behavior of link interactions.

Could you please confirm whether you are seeing the same error on the new dashboard as well? Additionally, testing the scenario in a different browser would help determine if this error is actually impacting the functionality.

In the debug logs, I have not found any errors related to the interactions. To proceed, it would be helpful to identify the specific dashboard or dashboard settings (such as tab or filter settings etc) that consistently reproduce the issue. This will allow me to recreate a similar dashboard locally and discuss further with the product team for further troubleshooting.

Alternatively:
Please share the dashboard.yfx export file and the data source (with sensitive data removed and replaced by dummy data), so I can attempt to reproduce the issue by restoring the data source along with the dashboard export file.

Workaround:

As a potential workaround, you may consider restoring the same dashboard from the test environment to see if that helps.

Please let me know if you would like to discuss this over a screenshare session.

Thanks,

Deepak

The same error is present on the working dashboard. The same issue exists when using Firefox as well, so it is not browser specific.

The problem with finding the circumstances that caused this is I genuinely have no idea when this could have broken. I just one day went to this and saw it wasn't working

One thing I just tried (with no success) was re-creating the report used to control drilling and the report that has the interactivity linked

I did the set-up process again on my copy of the bad dashboard and my personal test dashboard

Same issue exists. The interactivity works on mine, but doesn’t work on the bad one

I unfortunately don’t have an easy way to scrub sensitive data. I’d prefer to try a call with you first before I spend time creating dummy data and copies of everything affected. If that’s okay?

Hopefully during the call we can identify the root cause

In the meantime, can you tell me where on the server Yellowfin is installed on I can find where the information pertaining to the reports and dashboards is stored? I’d like to look at these dashboards there and see what differences there are. When they are run these two dashboard pages are virtually identical, but there is obviously something off behind the scenes

Hi Justin,

Since the error is also present on the working dashboard, I don't think the error message can be related to the link interaction behavior.

I understand that identifying the exact settings or changes causing this behavior may be challenging. I suggest we conduct A/B testing by comparing the settings, report filter links, sub-tabs, and other relevant configurations between the problematic dashboard and the one that is working correctly.

Additionally, if available, we could try importing the dashboard from a different environment, such as a test environment. As a final option, we could take a backup of the data source, remove any sensitive information, and replace it with dummy data. Along with this, we can provide the dashboard's .yfx export file so that I can replicate the issue on my local instance.

Unfortunately, I do not believe we can retrieve link details directly from the configuration database. At a high level, the dashboard details are stored in the ReportGroup table:

The name of my dashboard is 'Sales Performance'.

But we can verify of the second report filters are being applied from reportinstance, reportinstancefilter tables.

Kindly let me know your availability and time zone so that we can coordinate a suitable meeting time.

Thanks,

Deepak

I am in US Eastern time, available generally from 9 AM to 5 PM.

I know you are in a very different time zone, so I can stretch my availability past 5 pm if needed

Hi Justin,

Thank you for sharing your availability and for your willingness to extend your schedule.

I am currently consulting with a colleague who covers your time zone and will provide you with the details shortly.

Thanks,
Deepak

Hello Justin,

Greetings of the day!

I am joining the call on behalf of Deepak. Thank you for the confirmation. I have scheduled the meeting for Today at 08:30 PM IST, which is equal to 11:00 AM US Eastern time. Please use the link below to join the meeting.

https://teams.microsoft.com/l/meetup-join/19%3ameeting_MDNjM2JjYWEtZTA3OS00Y2I2LThiMjMtNWM0MzUwYTFlMzBh%40thread.v2/0?context={"Tid"%3a"27c9504a-c467-4376-b261-89b15e8ebb17"%2c"Oid"%3a"83ba7745-b3f6-4cc1-ac46-de59603fc766"}

Sincerely,

Siddartha Pathi

Yellowfin Technical Support Engineer

Hello Justin,

I have rescheduled the meeting for today at 10:00 PM IST, which is 12:30 PM US Eastern Time, due to conflicts with another meeting. Please use the same link below to join the meeting.

Sincerely,

Siddartha Pathi

Yellowfin Technical Support Engineer

I got the update, I will be there!

Hi Justin,

Thank you for your time yesterday, along with my colleague, to help replicate the issue.

Despite testing multiple scenarios, we were unable to reproduce the behavior on the new dashboard. I believe the simplest approach would be to build the rest of the tabs on the new dashboard in which the linking is working.

Alternatively, if you could provide the dashboard.yfx file along with the dummy data, I can conduct further testing on my local machine as this cannot be reproduced using the same configurations on any other dashboard.

Regards,

Deepak

Here is the yfx file for the dashboard and the view

I explained this to your colleague but getting dummy data for the view is something I can't really do

What I can do for you is get a single month of actual data into an excel file for you to use as a data source

This way you can import the dashboard and point it to the excel file. This should allow it to run

I won't attach it here, but let me know if that is something you want, and we can set up another teams meeting and I can send it through there

Regardless of any of that, this doesn't seem like a data issue, since I can get the interactivity to work in a brand-new dashboard using the same reports

I am hoping the yfx file can show what is happening for this dashboard. I assume it contains every setting available on the dashboard

Let me know if you would like the excel sheet!

The YFX file was the key after all!

I compared the xml file’s <events> sections between the bad dashboard and the one I created for testing that had interactivity working

The good dashboard had one Event listed which was a drill-down. To be expected

However, the dashboard with the broken interactivity had something like a dozen events.

This shouldn’t have been the case since I deleted all the items (pages, reports, filters, graphics, etc.) and added the reports needed for the single interactivity on a new page

As a test, I deleted the entire <events> section from the bad dashboard xml file and imported

After I set up the drill interactivity again it worked as expected!

My best guess is deleting the pages from the dashboard did not delete their events. Not sure why the events I created didn’t work, but at least I found a fix that doesn’t involve re-creating the entire dashboard from scratch

Is there somewhere I can see the events that a dashboard has outside of the export .xml file?

If not, I can export and do the fix I mentioned above. I’d just like to avoid having to do that in the future if this happens again

Also, you should be able to see this for yourself in the .yfx file.

Hopefully you can determine why deleting a page didn’t delete it’s events (if that’s what happened) or why my event wasn’t working in the first place

Below is an example of what could be causing the issue

There are two separate events in the screenshot. Both are drill downs

In the first one you see a UUID value defined for parentEntity and childEntity. This links to two different reports within the xml file

In the second event there is no parentEntity and childEntity value telling the drill event where to look.

I'm obviously not versed in the code behind Yellowfin, but those missing values could be causing the events to not work

Please let me know if there is a way to browse the events that are in a dashboard. It would be nice to just delete the bad ones instead of everything within the XML code

Hi Justin,

Thank you for further testing and sharing the .yfx file.

I am glad that we have identified a workaround that is currently effective for the problematic dashboard.

However, I believe that the difference in the first event having both parent and child entities, while the second event does not, may not be the root cause. My understanding is that the drill-down functionality applies only to the first report, whereas the second report, which is linked to the first, simply filters data based on the value selected in the first report.

For example, in my local environment, when I click on North America:

The first report performs a drill-down (for example, from Region (North America) to Countries (USA, Canada)). However, the second report does not drill down; instead, it filters the entire dataset based on the selected region. In other words, the second report already displays country-level data and simply filters it to show only the relevant countries, such as the USA and Canada.

Furthermore, in the config db, we can see that there is only one eventUUID associated with the dashboard named 'report link interaction - reion to country':

I believe the best next step is to implement the workaround and monitor whether the issue recurs over the next few days. Should the issue reoccur, I will gather the necessary data and replicate the problem on my local machine so that product team can investigate it at code level.

Please feel free to reach out if you have any further questions.

Thanks,

Deepak

Hi Justin,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Is there anything you are needing from me to help get this resolved?

Kind regards,

Deepak Chaganti

I have been putting off applying this fix because of the volume of events that this dashboard has

Having to recreate all the drill and filter links is going to take time. I was hoping you knew of a simpler way for me to manage the links that exist within the dashboard?

Something that can be done from the GUI or a report file on the server yellowfin is installed on

I went ahead and did the full export/import process. I only deleted the events without the parent and child keys defined before I imported

After importing and matching linked content the drill downs are working. It seems those events were causing the issues

Hi Justin,

I hope you're having a good week.

I was on leave until today, so I couldn’t respond to your email earlier.

Thank you for letting me know that performing a full export and import after removing the events without defined parent and child keys resolved the issue.

Please let me know if the issue recurs over the next few days, or if there is anything else I can assist you with.

Thanks,

Deepak

Hi Justin,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Is there anything you are needing from me to help get this resolved?

Kind regards,

Deepak Chaganti

Hi Justin,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Is there anything you are needing from me to help get this resolved?

Kind regards,

Deepak Chaganti

Hi Justin,

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