on 09-24-2014 4:57 PM
HI Experts,
Can you please let me know what are the frequently used SQL Functions in Webi reports.
Thanks,
Srichand.P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It can depend on what kind of data you are reporting on. Primarily Date and Time is present across the board. Or even conditional logic depending upon range of values.
yes, my up coming project is on Oracle data base
and domain is product based and i would like to know the frequently used SQL functions
You can refer to all the list of function in Webi reports. Depends on what kind of reports you are creating, you need to use relevant functions.
However mostly used SQL functions are below.
1)FormatNumber
2)ToNumber
3)Substring
4)Trim
5)If condition
6)Sum
7)Todate
8)FormatDate
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.