How can I import SQL to create a report.

Byron Burton shared this question 26 days ago
Awaiting Reply

Comments (8)

photo
1

Hello Byron,

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.

/a0f9b7c6901b898c0643e5404c60a498

I hope that helps.

Please let me know if you have any further questions.

Regards,

David

photo
1

David,

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?

Byron Burton

UPS Innovation Center | Corporate Security


10 Upper Pond Road | Parsippany, NJ 07054


Phone: 201-828-6127 | Atlas: 5-283-6127


From: Yellowfin Support <support@yellowfin.bi>

Sent: Thursday, July 21, 2022 02:24 PM

To: Byron Burton <bburton@ups.com>

Subject: [EXTERNAL] New Comment in "How can I import SQL to create a report."

CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.

photo
1

Hi Byron,

Thank you for the update and context. Have you discussed this with i-Sight?

David

photo
1

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?

photo
1

Exporting to SQL is there.  There is no way to import a file back into Yellowfin.

Byron Burton

UPS Innovation Center | Corporate Security


10 Upper Pond Road | Parsippany, NJ 07054


Phone: 201-828-6127 | Atlas: 5-283-6127


From: Yellowfin Support <support@yellowfin.bi>

Sent: Thursday, July 21, 2022 03:09 PM

To: Byron Burton <bburton@ups.com>

Subject: [EXTERNAL] New Comment in "How can I import SQL to create a report."

CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.

photo
1

I exported the SQL from both Reports and Dashboards.  However, in UAT, there is no way to import it.

Byron Burton

UPS Innovation Center | Corporate Security


10 Upper Pond Road | Parsippany, NJ 07054


Phone: 201-828-6127 | Atlas: 5-283-6127


From: Yellowfin Support <support@yellowfin.bi>

Sent: Thursday, July 21, 2022 03:09 PM

To: Byron Burton <bburton@ups.com>

Subject: [EXTERNAL] New Comment in "How can I import SQL to create a report."

CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.

photo
1

The advanced authoring Toggle is not there.

Byron Burton

UPS Innovation Center | Corporate Security


10 Upper Pond Road | Parsippany, NJ 07054


Phone: 201-828-6127 | Atlas: 5-283-6127


From: Yellowfin Support <support@yellowfin.bi>

Sent: Thursday, July 21, 2022 02:24 PM

To: Byron Burton <bburton@ups.com>

Subject: [EXTERNAL] New Comment in "How can I import SQL to create a report."

CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.

photo
1

Hi Byron,

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.