You can use custom SQL by creating a Freehand SQL report. When creating a new report click the 'Advanced Authoring' toggle, and you see the option for Freehand SQL.
I hope that helps.
Please let me know if you have any further questions.
I work for UPS and we are in UAT with a company called I-Sight that uses your product to create reports. I do not see that option. Can you slow walk me through some instructions. We are creating reports in UAT but will lose them when we go live so I offloaded reports to SQL but I do not see how to load SQL back into the system. Does this make sense?
UPS Innovation Center | Corporate Security
10 Upper Pond Road | Parsippany, NJ 07054
Phone: 201-828-6127 | Atlas: 5-283-6127
From: Yellowfin Support <firstname.lastname@example.org>
Sent: Thursday, July 21, 2022 02:24 PM
To: Byron Burton <email@example.com>
Subject: [EXTERNAL] New Comment in "How can I import SQL to create a report."
Thank you for the update and context. Have you discussed this with i-Sight?
You should be able to export the entire report to a file and then import it into the live system later. Is that not an option right now?
Exporting to SQL is there. There is no way to import a file back into Yellowfin.
Sent: Thursday, July 21, 2022 03:09 PM
I exported the SQL from both Reports and Dashboards. However, in UAT, there is no way to import it.
The advanced authoring Toggle is not there.
If the Advanced Authoring toggle is not there then your account is not a member of a role that allows you to use it. I would discuss this with your Yellowfin admin.
I hope things are going well over there.
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.
Replies have been locked on this page!