Freehand SQL Field in Yellowfin BI Report

Freehand SQL Field in Yellowfin BI Report

Freehand SQL allows you to build a calculation/manipulation by writing the SQL.

·         In Yellowfin 7.0 version, you cannot to use a Freehand SQL field as a Filter in Report.(It may enhanced in future release)

·         If you want to use Freehand SQL field as a Filter you may need to explore ‘Custom Function’ or ‘Virtual Table’ in Yellowfin View.

·         Calculated fields are not allowed in Freehand SQL view.

·         SELECT, FROM, or WHERE clause not allowed here, directly use SELECT fragment of SQL.

·         Aggregate functions (AVG, MAX, MIN, SUM and COUNT) should not be used.

Step 1: Suppose we want to display initial letter of ‘Agency Type’ values,Online – O & Agency – A. Go to Ski Team View & Edit it.

Step 2: Drag Dimension from Calculated Fields -> Freehand SQL

Step 3: Write required logic in Formula, here “SUBSTRING(TRAVELAGENCY.AGENCYTYPE,1,1)” then Save & Activate.

You may use CASE..WHEN or any logic as per requirement.

Note: No SELECT, FROM or WHERE clause & No Aggregated Functions

Step 4: Drag the Freehand SQL field in Report & Run.

Thank You!