To use Smart Search:

1. Enter the URL for the Smart Search front end into your browser.

   If you will be using Smart Search frequently, bookmark the page.

2. Enter the trigger keyword (for example, “essbase”), followed by search words, and click Search.

   Note:

   If no keyword is entered in the text box, no data grids are included in Google search results.

3. Do one of the following:

   • If using Smart Search with Google OneBox, enter an Oracle Essbase or Shared Services user name and password, and click OK. This will only be necessary for your first query each session.

   • If using Smart Search with Oracle SES, select the Login link to launch a Login page for Oracle Secure Enterprise Search. Enter a Oracle's Hyperion® Shared Services user name and password, and click Login.

4. Review your search results and click any link for more information.

   • Search results with data grids display a link and up to 12 rows of data in the grid. Clicking the link displays the results in a spreadsheet. If Oracle Hyperion Smart View for Office, Fusion Edition is installed, the spreadsheet is opened with Smart View, and you can perform further ad-hoc analysis on the data. Otherwise, the results display in an Excel spreadsheet, and ad-hoc analysis using Oracle Hyperion Smart View for Office, Fusion Edition is not available.

   • If keywords are present in an outline, the results display the portion of the outline containing the search keywords, and clicking the link launches a data grid in Excel.

   • If keywords are present in a report script or calculation script, a summary of the script content is displayed. Clicking the link launches a browser displaying the report script with keywords highlighted. Clicking the Execute Script link in this window executes the report or calculation script and displays results in a new browser window.

   • If keywords are present in a linked reporting object (LRO), summary results are displayed. Clicking the link launches a browser window displaying all of the LROs in the application. URL links in an LRO can be clicked and launched.

   • Clicking a Show graph link launches a browser window containing a graph of the outline results.

  To create a query containing a conditional expression:

1. Enter the expression into the search box; for example, essbase Sales > 222.

2. Click Help me construct Query.

3. In the page that opens, use the fields and buttons provided to construct your query:

   • Construct conditions using the Filter Expressions text and drop-down boxes.

   • Click Add Expression to add the current Filter Expression to the query.

   • Click And or Or to connect the expressions in the query logically.

4. When the query is complete, click Preview or Search to execute the search.