Tips
Delete Multiple Reports
How to delete a reports folder with multiple reports in it without having to delete each report individually. You can go into navigator→forms it shares the same folder structure as reports. In my installation these folders have no webforms and appear empty in the “Form and Ad Hoc Grid Management” You can delete the folders…
Read MoreReinstate the Workforce/Financial Module Artefacts
I was having an issue with an Oracle pre defined calculation in Workforce Planning that had been updated by introducing a modified variable run time prompt, but the artefact no longer worked as it was at least 3 years out of date. I needed to get back to a state where EPM recognised that it…
Read MoreWeb Form Calculation Formula
Sometimes it can be advantageous to embed a formula into a Web Form rather than include it in the database. Such circumstances may be when the use case for the formula is so specific it doesn’t warrant putting into the database, or it is a variance of two columns that are different scenarios set by…
Read MorePeriod End Average Selling Price
To calculate an average price in the Year_Total/Total_Period member is quite straight forwards if you’ve got your period hierarchy as dynamic calc. It just needs a forumula. It doesn’t need to be a Two Pass calculation member. The ASP (Average Selling Price) member in my model has the following properties: The time balance and account…
Read MoreAccess to Multiple Environments in Excel Smart View
A super quick post about a tip I got a few years ago on an easy way to manage access to multiple environments in Excel Smart View. The reason for going to post is that it surprises me how often that I come across people that have not seen this, so here it is. How…
Read More