Create Charts and Tables from OTBI Analyses

Using the Visualization Configuration tool in Application Composer, you can create interactive charts and tables for your sales dashboard from Oracle Transactional Business Intelligence (OTBI) analyses. Salespeople remain in the Redwood User Experience when they drill down on charts or tables. They can drill down to individual records and take advantage of smart actions, such as making a call by clicking a phone number.

The steps to create a chart or a table use the same UI, but are slightly different, so they're covered in separate topics:

What to Check in OTBI Before You Start

  • Make sure that the person creating the visualization can view data in the analysis itself. You can temporarily remove filters from your analysis to ensure that you see data as you create the visualization.

  • Make sure that your analysis includes only those columns that you display in the visualization.
  • If you plan to enable drill-down from a table on the sales dashboard, then you must also add the ID and PUID columns that can uniquely identify each individual record to your analysis.

    For example, to enable drill down on opportunity name, you include the Opportunity Number (the PUID) and the Opportunity ID columns. For accounts, it's Account Number and Account ID. You get the idea.

  • You must ensure that none of the columns you selected as criteria in your OTBI analysis are hidden in the Results tab. All of the columns, including the ID and PUID must be visible in the results.
  • Your analysis must be stored in the Custom folder.