Keeping up with EPM Cloud

When working with Hyperion systems, Smart View is a key tool used for reporting, as well as inputting data. It provides a valuable link between Hyperion and Excel, which allows users to retrieve data from the database straight into Excel with ease. Smart View functions are available through the Smart View toolbar and can be used with Essbase, HFM, Planning or Cloud connections. Occasionally, it is necessary to perform Smart View functions behind the scenes using VBA code, rather than manually using the Smart View toolbar. For example, a spreadsheet which will refresh all the Essbase retrieval sheets on opening, so that users can view the most up to date data, without having to remember to refresh each of the retrieval sheets themselves. This blog will be cover how to retrieve data using a Smart View refresh function in VBA. For more information about Smart View Excel VBA functions, go to the Oracle Hyperion Smart View Developers Guide .  System Requirements T

As part of the October PBCS update, Oracle have re-introduced the ability to keep an audit of changes to your PBCS artefacts. This update is due to be applied to PBCS Test environments on Friday 6th October and to Production environments on Friday 20th October. The Audit tab was briefly removed to avoid confusion over access to the database tables, but after some re-work the functionality is back! To access the auditing section, open the ‘Application’ bundle and select the yellow ‘Audit’ icon: Note: If you are not using the default navigation flow, you may need to manually add the new Audit card to your custom navigation flow before it will be visible. Currently, the only artefact available for auditing is Data, which allows you to view any data changes submitted by users. The audit information includes the full data cell reference, the previous value, the new value, who made the change and when.  The Auditing functionality must be enabled before any dat