enterprise library anylogic reference guide

You create SQL functions in Expression Builder.

In the Administration Tool, Logical SQL appears mostly in the form of expressions related to objects in the Business Model and Mapping layer. You can also enter SQL in the New Filter dialog. If an analysis does not contain hierarchical columns, member selections, or groups, then you can use the Advanced SQL Clauses fields in the Advanced tab of the Analysis editor. If you have the appropriate privileges, then you can use the Issue SQL page in the Administration tab to enter any SQL code to send to the Oracle BI Server. In Answers, there are also several places where you can issue Logical SQL.

Click View Log from the Manage Sessions page to see further details. If you have the appropriate privileges, then you can also view SQL by displaying the Manage Sessions page in the Administration tab. In Administration Tool, you can view the Logical SQL queries issued by Oracle BI Server for particular analyses by viewing the SQL Issued section of the Advanced tab of the Analysis editor. The complexity of the multiple source languages needed to communicate with each data source type is hidden from users and clients. The abstraction provided by the Presentation layer and Business Model and Mapping layer enables clients to query data with Logical SQL only, so that the interaction with actual physical sources is handled by the Oracle BI Server. This guide explains the syntax and semantics for the SELECT statement and for the expressions you can use in the Administration Tool to create derived columns. Additionally, the Oracle BI Administration Tool enables you to define logical columns with complex expressions. The Oracle BI Server accepts SQL SELECT statements from client tools. Provides an overview for defining SQL Select statements to create expressions for derived columns.

Enterprise library anylogic reference guide