Popular SQL Functions
SQL functions are powerful and limited only by your creativity, but potentially, they are more overwhelming (especially if you inadvertently put commas and parentheses in all the wrong places). In the universe design process, this is when the power users, universe designers, and DBAs must partner together to build a technically correct but business-robust universe.
There are entire books dedicated to SQL commands alone, so it is impossible to cover all of the functions here. What follows are just a few examples of some popular objects that use SQL functions to deliver business functionality.
Concatenated Objects
Concatenated objects combine information from multiple fields. A common usage is to combine a customer or employee’s ...
Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
