Thursday, February 20, 2025

Oracle EPM and Big Pipeline Changes !

Oracle has made some exciting changes in the Feb 2025 update for the pipeline functionality.  

- For those of us with large pipelines that become very small and difficult to manage in the graphical interface, we finally have a table view below:


Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Profitability and Cost Management, Tax Reporting

- Another change is the removal of the auto-save functionality.  This is a massive update for those of us who really hate autosave.  

- It should be noted that you now have to click Save when you actually want your changes to be saved.  

- Another nice new feature with the addition of the runPipeline command for EPM Automate.  Anyone running a hybrid setup with pipelines baked into on-premise orchestration will love this, as the only method available to do this previously required the REST API.


Monday, February 17, 2025

Oracle EPM and ability to Drill into an Ad Hoc Grid from a Dashboard 2.0 Chart

Ability to Drill into an Ad Hoc Grid from a Dashboard 2.0 Chart​


- You can now create an ad hoc grid directly from a chart within Dashboard 2.0.​

- You can create an ad hoc grid by right-clicking a chart element; for example, right-clicking on a bar within a Bar chart, and then clicking Analyze to open ad hoc in a dynamic tab. The Analyze option opens ad hoc for the intersection represented by the chart element.​

- To drill into an ad hoc grid from a chart in a Dashboard 2.0 dashboard:​

1. Open a dashboard in Dashboard 2.0.​

2. Right-click a chart element, and then select Analyze to view the chart intersection in ad hoc.​

Note the following:​

- Analyze only works for chart elements built on a form.​

- Analyze is supported for all Dashboard 2.0 chart types except for Geomaps.​

- For charts built on a form with a formula row or column, clicking Analyze will not perform any action after right-clicking the chart element that corresponds to the formula row/column (like a bar in a Bar chart).​

- Analyze is not supported for Quick Analysis charts.


 Standardized Dashboards Page

Thursday, February 6, 2025

Oracle Hyperion and EPM - SmartView for Windows 24.200 - Features !!

 Some of the new features for Oracle SmartView Excel Adin:

- Refresh Data as is in Ad Hoc Grids in Saved Worksheets

- Retain Numeric Comments on Refresh in Ad Hoc Grids

- Register Unregistered DLLs Using Health Check

- View Network Traffic details in real time with SmartView's New Trace Traffic Tool

- Submit Data without refresh when Flex Forms Contain Invalid Members

- Admin Extension 24.10 Update for Trace Traffic Tool

- EPM Books Extension 24.11 Support for end user prompts

- Highlight all variables


The New Trace Traffic Tool features are as follows:

- Fiddler is no longer needed, SmartView will provide network trace info.

- New diagnostics option controls Network traffic or API calls - this avoids amount of data getting collected.


SmartView for Office 365 features:

- Two new actions: "Apply to All Sheets button" added to the Options panel and "Disconnect