Category
Report Builder
Product Version
7.3
SQL Code
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
The same question
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
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
Hi Nathan,
Thanks for your response. I will try & test Oracle SQL code into Yellowfin based on my requirements.
Regards,
Kalaiselvan
Hi Nathan,
Thanks for your response. I will try & test Oracle SQL code into Yellowfin based on my requirements.
Regards,
Kalaiselvan
Sounds good let me know if you run into any specific problems.
Regards,
Nathan
Sounds good let me know if you run into any specific problems.
Regards,
Nathan
Replies have been locked on this page!