Category
Report Builder
Product Version
7.4
Modify report SQL without resetting the layout and charts
Awaiting Reply
Whenever we make changes to a report SQL, it seems the graph/chart and layout reset as well. Can the SQL statement be changed from the back-end? What tables are involved?
The same question
Hello Tom Manning,
My name is Ankit Asati 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: #31643
Case Title: Modify report SQL without resetting the layout and charts.
Issue Overview:
Modify report SQL without resetting the layout and charts
Request for Additional Information:
To better understand and expedite the resolution of your case, please provide me following details:
Next Steps and Workarounds:
Before proceeding, I'd like to ensure you're aware that Yellowfin 7.4 is at end of life and is no longer supported under our Support Policy. I recommend laying out an upgrade path to one of our supported versions, using our best practices for performing an upgrade. On this same note, we can also offer upgrade assistance through a mix of support & professional services, please let me know if you're interested in this program and I can pass along some more information.
Sincerely,
Ankit Asati
Yellowfin Technical Support Engineer
Hello Tom Manning,
My name is Ankit Asati 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: #31643
Case Title: Modify report SQL without resetting the layout and charts.
Issue Overview:
Modify report SQL without resetting the layout and charts
Request for Additional Information:
To better understand and expedite the resolution of your case, please provide me following details:
Next Steps and Workarounds:
Before proceeding, I'd like to ensure you're aware that Yellowfin 7.4 is at end of life and is no longer supported under our Support Policy. I recommend laying out an upgrade path to one of our supported versions, using our best practices for performing an upgrade. On this same note, we can also offer upgrade assistance through a mix of support & professional services, please let me know if you're interested in this program and I can pass along some more information.
Sincerely,
Ankit Asati
Yellowfin Technical Support Engineer
Hi Ankit,
Yes, we are aware that 7.4 is at EOL. Our upgrade of Yellowfin is set for June 2025. For now, however, we still have to deal with this.
The objective is to modify the SQL of an existing report. I know this can be done by editing the report and editing the SQL. However, when I do that, any existing report layout and graph/chart gets reset or disappears. So I was thinking of modifying it on the database side.
I tried on the REPORTINSTANCE table but this did not change the report SQL.
Please advise what we can do for now?
Hi Ankit,
Yes, we are aware that 7.4 is at EOL. Our upgrade of Yellowfin is set for June 2025. For now, however, we still have to deal with this.
The objective is to modify the SQL of an existing report. I know this can be done by editing the report and editing the SQL. However, when I do that, any existing report layout and graph/chart gets reset or disappears. So I was thinking of modifying it on the database side.
I tried on the REPORTINSTANCE table but this did not change the report SQL.
Please advise what we can do for now?
Hello Tom Manning
Thank you for patience,
The sql of the freehand sql report can only be modified from the yellowfin UI, it is not recommended to make changes to the report from database. The graph/charts are dependent of the the data fetched from sql query. Thus, any changes to the sql shall have impact to the chart/graphs created from freehand sql report.
Hope it helps!
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
Thank you for patience,
The sql of the freehand sql report can only be modified from the yellowfin UI, it is not recommended to make changes to the report from database. The graph/charts are dependent of the the data fetched from sql query. Thus, any changes to the sql shall have impact to the chart/graphs created from freehand sql report.
Hope it helps!
Thank you,
Ankit Asati
Yellowfin Technical Support
Hi Ankit,
What about reports that were NOT created from FreeHand? Will changing the SQL on those impact graphs/charts?
Just thinking as a way forward,
Please advise.
Thank you,
Tom
Hi Ankit,
What about reports that were NOT created from FreeHand? Will changing the SQL on those impact graphs/charts?
Just thinking as a way forward,
Please advise.
Thank you,
Tom
Hello Tom Manning
Thank you for your patience,
If the report is not created from FreeHand sql, it will not allow you to modify the sql for the report as it is yellowfin generated. The modification to the report sql query from backend i.e. database is not recommended as it could have multiple dependencies and implications.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
Thank you for your patience,
If the report is not created from FreeHand sql, it will not allow you to modify the sql for the report as it is yellowfin generated. The modification to the report sql query from backend i.e. database is not recommended as it could have multiple dependencies and implications.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
I wanted to follow up with you regarding the solution I provided in my last email. Did the solution we sent you resolve the issue?
Please let us know if you need additional support on this issue.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
I wanted to follow up with you regarding the solution I provided in my last email. Did the solution we sent you resolve the issue?
Please let us know if you need additional support on this issue.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
I wanted to follow up with you regarding the solution I provided in a previous email. Did the solution we sent you resolve the 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 case by the end of business tomorrow if I do not receive a reply.
Please let us know if you need additional support on this issue.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
I wanted to follow up with you regarding the solution I provided in a previous email. Did the solution we sent you resolve the 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 case by the end of business tomorrow if I do not receive a reply.
Please let us know if you need additional support on this issue.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hi Ankit,
Did you actually send me a solution? I only see that you recommended changing it on the UI.
Of course we can do that but, again, it will reset graph/chart and report design.
Is there a newer version of Yellowfin where the graphs/charts DO NOT get reset upon editing of the SQL?
Please advise.
Tom
Hi Ankit,
Did you actually send me a solution? I only see that you recommended changing it on the UI.
Of course we can do that but, again, it will reset graph/chart and report design.
Is there a newer version of Yellowfin where the graphs/charts DO NOT get reset upon editing of the SQL?
Please advise.
Tom
Hello Tom Manning
Thank you for your cooperation so far.
Actually, if there are any changes to data when you make change to the sql, it will have impact on the charts which based on the data generated as the result of the sql query. Still we would like to have a meeting with you in order to further investigate on the issue, to see what impact it have on the chart, as you mentioned it gets reset completely. Please share you availability, I am available Monday to Friday from 06:00 am to 12:00 pm IST.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
Thank you for your cooperation so far.
Actually, if there are any changes to data when you make change to the sql, it will have impact on the charts which based on the data generated as the result of the sql query. Still we would like to have a meeting with you in order to further investigate on the issue, to see what impact it have on the chart, as you mentioned it gets reset completely. Please share you availability, I am available Monday to Friday from 06:00 am to 12:00 pm IST.
Thank you,
Ankit Asati
Yellowfin Technical Support
City of Richmond Security Warning: This email was sent from an external source outside the City. Please do not click or open attachments unless you recognize the source of this email and the content is safe.
I’m in Vancouver. That’s 13.5 hours behind you. Which means I’m not available during the time you mentioned.
City of Richmond Security Warning: This email was sent from an external source outside the City. Please do not click or open attachments unless you recognize the source of this email and the content is safe.
I’m in Vancouver. That’s 13.5 hours behind you. Which means I’m not available during the time you mentioned.
Hello Tom Manning,
Thank you for your cooperation so far,
We wanted to see what would happen to the chart or graph when the freehand SQL query was altered in order to better comprehend this issue. The chart shouldn't reset, but it will modify according to the data. I would appreciate it if you could send a short screen capture video of the issue replication. We also see whether we can reassign the case to help in your time zone in the interim.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning,
Thank you for your cooperation so far,
We wanted to see what would happen to the chart or graph when the freehand SQL query was altered in order to better comprehend this issue. The chart shouldn't reset, but it will modify according to the data. I would appreciate it if you could send a short screen capture video of the issue replication. We also see whether we can reassign the case to help in your time zone in the interim.
Thank you,
Ankit Asati
Yellowfin Technical Support
City of Richmond Security Warning: This email was sent from an external source outside the City. Please do not click or open attachments unless you recognize the source of this email and the content is safe.
HI Ankt,
Ok. Can you set up a call for 6 a.m. IST on Dec 18? If not, then 6 a.m. IST on Dec 19.
That would be 4:30 p.m. for me
Thanks,
Tom
City of Richmond Security Warning: This email was sent from an external source outside the City. Please do not click or open attachments unless you recognize the source of this email and the content is safe.
New Comment
Modify report SQL without resetting the layout and charts
Ankit Asati
Hello Tom Manning,
Thank you for your cooperation so far,
We wanted to see what would happen to the chart or graph when the freehand SQL query was altered in order to better comprehend this issue. The chart shouldn't reset, but it will modify according to the data. I would appreciate it if you could send a short screen capture video of the issue replication. We also see whether we can reassign the case to help in your time zone in the interim.
Thank you,
Ankit Asati
Yellowfin Technical Support
OPEN COMMENT IN BROWSER
Stop receiving notifications about this question
City of Richmond Security Warning: This email was sent from an external source outside the City. Please do not click or open attachments unless you recognize the source of this email and the content is safe.
HI Ankt,
Ok. Can you set up a call for 6 a.m. IST on Dec 18? If not, then 6 a.m. IST on Dec 19.
That would be 4:30 p.m. for me
Thanks,
Tom
City of Richmond Security Warning: This email was sent from an external source outside the City. Please do not click or open attachments unless you recognize the source of this email and the content is safe.
New Comment
Modify report SQL without resetting the layout and charts
Ankit Asati
Hello Tom Manning,
Thank you for your cooperation so far,
We wanted to see what would happen to the chart or graph when the freehand SQL query was altered in order to better comprehend this issue. The chart shouldn't reset, but it will modify according to the data. I would appreciate it if you could send a short screen capture video of the issue replication. We also see whether we can reassign the case to help in your time zone in the interim.
Thank you,
Ankit Asati
Yellowfin Technical Support
OPEN COMMENT IN BROWSER
Stop receiving notifications about this question
Hello Tom Manning
Thank you for the confirmation, we have scheduled the meeting and shared the invite accordingly for 06:00 AM IST on 19th December. However, if you still face issue joining in you can use the meeting link below.
https://www.google.com/url?q=https://teams.microsoft.com/l/meetup-join/19%3ameeting_NmE2OWZhNWYtNDBkMS00ZjU2LTkxNTAtMTZhNWVhNDI5ZWJk%40thread.v2/0?context%3D%7b%22Tid%22%3a%2227c9504a-c467-4376-b261-89b15e8ebb17%22%2c%22Oid%22%3a%2293649eab-dae0-4962-9a56-836a4171f28e%22%7d%26launchAgent%3DGSuiteAddOn%26correlationId%3Df5d892a3-c3f8-4f49-94d0-95f23ce178c3&sa=D&source=calendar&ust=1734936983837304&usg=AOvVaw22LM63ZN2eiEAnbAIz_e0n
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
Thank you for the confirmation, we have scheduled the meeting and shared the invite accordingly for 06:00 AM IST on 19th December. However, if you still face issue joining in you can use the meeting link below.
https://www.google.com/url?q=https://teams.microsoft.com/l/meetup-join/19%3ameeting_NmE2OWZhNWYtNDBkMS00ZjU2LTkxNTAtMTZhNWVhNDI5ZWJk%40thread.v2/0?context%3D%7b%22Tid%22%3a%2227c9504a-c467-4376-b261-89b15e8ebb17%22%2c%22Oid%22%3a%2293649eab-dae0-4962-9a56-836a4171f28e%22%7d%26launchAgent%3DGSuiteAddOn%26correlationId%3Df5d892a3-c3f8-4f49-94d0-95f23ce178c3&sa=D&source=calendar&ust=1734936983837304&usg=AOvVaw22LM63ZN2eiEAnbAIz_e0n
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning,
Please join the meeting.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning,
Please join the meeting.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
Please let me know your availability and we will reschedule the meeting accordingly. We ended the meeting now.
Thank you,
Ankit Asati
Yellowfin Technical Support
Hello Tom Manning
Please let me know your availability and we will reschedule the meeting accordingly. We ended the meeting now.
Thank you,
Ankit Asati
Yellowfin Technical Support
Replies have been locked on this page!