Reducing Maintenance with Base Objects and @Select
The @Select function is an internal function that allows you, as the designer, to reuse business layer objects without forcing you to repeat the entire SQL syntax. For example, consider an initial Sales object that provides information about revenue in U.S. dollars. You can add a number of enhancements to this object: Sales in Local Currency, Sales in Euros, Sales Adjusted for Inflation, Sales with 10% Projected Increase, and so on. These additional objects are not columns in the database; they are measures you create by using SQL commands. However, they all reference the same initial column in the RDBMS, such as SALES_FACT.AMOUNT, and then include further calculations for local currencies or ...
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.
