SQL Code

Kalaiselvan shared this question 2 years ago
Answered

Hi Team,

Where can i find the list of SQL codes that can be used in Yellowfin BI for creating calculated field by using "Freehand SQL" option?

Regards,

Kalaiselvan

Comments (3)

photo
1

Hi Kaliselvan,

As this is inherently "free-hand" there isn't a list of what can and cannot be used though generally:

If you want to use custom DB functions, or preform operations that do any sort of aggregations, I would recommend creating a yellowfin custom function (pre-defined function) http://wiki.yellowfin.com.au/display/USER74/Custom+Functions

Freehand SQL has less control over the aggregation, though it is possible to use DB specific functions, especially those that parse date components out of the primary values.

Sorry this isnt very specific but hopefully it is helpful.

Regards,

Nathan

photo
1

Hi Nathan,

Thanks for your response. I will try & test Oracle SQL code into Yellowfin based on my requirements.

Regards,

Kalaiselvan

photo
1

Sounds good let me know if you run into any specific problems.

Regards,

Nathan