User manual BUSINESS OBJECTS SBOP EVENT INSIGHT XI 4.0 QUERY BUILDER 2010-10-01

[. . . ] SBOP Event Insight XI 4. 0 Query Builder User's Guide SBOP Event Insight XI 4. 0 Copyright © 2010 SAP AG. All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective Copyright logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S. A. in the United States and in other countries. [. . . ] A node that is shaded red indicates a detected error, such as a missing connection or invalid node parameters. Deleting a node 1. In the Query graph editor, select the node to delete. Right-click the selected node and select Delete. The node is deleted. Alternatively, Delete keyboard button can be used after selecting a node with a left-click. Editing node parameters 1. In the graph editor, select the node that you want to edit. In the Properties view, edit the property value manually or use the value list, if available. The node parameters are updated automatically. Adding a connection A connection binds output and input ports of different nodes in the graph. To add a connection, at least one node with an in port and one node with an out port are required. In the graph editor the in port is displayed as a green triangle on the left side of the node, and the out port is displayed as a red triangle on the right side of the node. 1. In graph editor, connect the in and out ports for the appropriate nodes. A connection must start at the out port and finish in the in port. Invalid connections are shaded orange. 3. To move the connection ports, drag and drop the connection out and in ports as necessary. 14 SBOP Event Insight XI 4. 0 Query Builder User's Guide Using Query Builder Editing a query graph |2 Deleting a connection 1. In Query Builder, open the existing query graph. Right-click the connection and select Delete. The connection is deleted. Alternatively, Delete keyboard button can be used after selecting a connection with a left-click. Displaying problems Every time you modify a graph (for example, add a node, add a port, or change a parameter), the graph is validated. Any problems that are found are displayed in the Validation Messages view. For each problem, the error message displays the description, creation time, and the element in which the problem occurs. Doubleclick on validation message opens graph where error is found. Validation messages can be shown for all graphs or only for selected graph. In Validation Messages view menu click Preferences and select appropriate scope for messages. Starting a query graph 1. In the Graph Tree, right-click the graph and select Start Graph. The started graph icon displays next to the graph. The Graph Results view opens and displays the results. Stopping a query graph 1. [. . . ] After you select a CEP query, the editor opens. The CEP text editor highlights reserved CEP keywords (for example, select and insert). Here are some guidelines for using the CQL node: The query may contain only one SELECT statement or one CREATE ACTIVE TABLE statement. A SELECT statement defines a continuous query and requires an output port. [. . . ]