Using IPM Insights in Smart View

You can now insert and use Intelligent Performance Management (IPM) Insights in Microsoft Office applications of Excel, Word, and PowerPoint using Oracle Smart View for Office.

Data source types: Planning, Enterprise Profitability and Cost Management, FreeForm, Tax Reporting

IPM Insights analyzes past data and predicted data, helping you find patterns and insights into data that you might not have found on your own. With IPM Insights, you can reduce time spent in data analysis, improve forecast accuracy, detect trends early, and minimize biases, thus encouraging informed decision making.

Service Administrators configure and schedule IPM Insights to define what you view on the Insights dashboard in the web application. You can view the same insights in Smart View and insert them in Microsoft Office applications of Excel, Word, and PowerPoint. For more information on configuring insights and accessing them through the web application, see Configuring IPM in Administering Planning and Using IPM Insights to Inform Your Decision-Making in Working with Planning.

IPM Insights provides the following types of insights:

  • Forecast variance and bias: This insight reveals hidden bias in forecasts submitted by planners by analyzing historical data. For example, Actual Electronic Sales are 24.15% higher than forecast.
  • Prediction: This insight uncovers significant deviations in forecasts compared to predicted values. For example, Predicted Utility Expenses are 20.06% lower than forecast.
  • Anomaly: This insight detects outliers and unusual patterns in data that deviate from expected results. For example, Actual Manufacturing Expenses are 44% higher in Jun FY23.

You can use IPM Insights in Smart View in the following ways:

  • View available insights: You can view the list of available insights in the IPM Insights dialog, along with their details. See Viewing Insights in Smart View.
  • Insert insights: You can insert an insight in an Excel sheet, a Word document, and a PowerPoint slide. See Inserting Insights.
  • Insert function: This action is available only in Excel. You can insert function to extract and display only the details related to the insight, without the chart or the data table. See Inserting Functions.
  • Analyze insight: This action is available only in Excel. You can insert only the data table associated with the insight and analyze it using various ad hoc analysis operations. See Analyzing Insights in Ad Hoc Grids.
  • View metadata associated with insights: This action is available only in Excel. After you insert an insight or function in a sheet, you can view additional details and metadata associated with the insight in the Sheet Information dialog. See Viewing Insight Metadata in Sheet Information.
  • Save and refresh inserted insights: You can save the Excel sheet, Word document, or PowerPoint slide in which you have inserted insights, and refresh the insights to get the latest data. See Saving and Refreshing Insights.

For more information on configuring insights and accessing them through the web application, see the following topics: