A Two-Step SQL Query with the @Execute Function
SAP BusinessObjects BI Suite 4.0 Support Package 4 comes with a new function: @Execute. In this article we will see how that new function can address concrete business needs like time filters, user-based predicates and trend alert. We will also show how to improve performance by breaking down a query into steps. The document includes different examples built against Microsoft SQL Server, SAP HANA CO-PA and Teradata.