You can still refresh the Job Console window as often as required using the Go button. You can configure the Job Console window to autorefresh at the interval you specify in the new Windows Registry setting, JobConsoleAutoRefreshInterval. For more information, see Creating a Drill Down to a Source System Without a Landing Page in Data Integration Administering Data Integration for Oracle Enterprise Performance Management Cloud.įor information on using this drill-through feature in Smart View, see the topics in Drill-Through Reports in the Oracle Smart View for Office User's Guide.
To use this feature, a Service Administrator must first execute a SQL query in the source database and display the results in a pop-window inside Data Integration. This new drill-through option lets you drill all the way through to the source data and view the drill-through reports directly in Smart View. In earlier releases, drill to source was only available in a Web Form. On the staging or source worksheet, you can use the Sheet Info command in the Smart View ribbon to open the Sheet Information dialog and view the sheet type: staging or source. This navigation works even if you rename the staging sheet. From the source sheet, you can navigate back to the staging sheet, and then back to the main sheet. Drill-through to source is available on any data cell for any dimension/member combination in the staging sheet.
From this sheet, you can drill further into a data cell to the source data for the selected cell. The staging sheet contains data from the provider source. When this new drill-through option is enabled, your first drill-through operation takes you from your main worksheet to a staging sheet. In this case, the source data is queried and the data is displayed in a new Excel sheet in Smart View.
In this case, when you initiate a source drill, the system launches the source landing page in your default browser.ĭrill through to the source data using an EPM Integration Agent query. When working with Oracle Enterprise Performance Management Cloud data providers, and performing a drill through to display drill data from Oracle Smart View for Office, the system now supports two ways to display the source data:ĭrill through to the source landing web page using a hyperlink.
0 kommentar(er)
