Cool use of the View dimension for calculations.
Tag: EPM
Initial Setup of User Variables
Using Groovy to setup User Variables in EPM.
Using Auto Predict with Inconsistent History
EPM Planning has a great tool called Auto Predict. But what happens if your historical data is less than ideal? Perhaps there was a major event (like a pandemic) that warped a chunk of your historical data. Here's one way to approach it with Auto Predict.
Copy Data from Dynamic Member to Store Member with Groovy
Easy Groovy script to copy data from dynamic to store member.
Using Out-of-Box Trending on No Currency
Quick fix to use OOB trending on No Currency.
Conditional Suppression Using a Smart List Value
Conditional Suppression in EPM reports is very useful, you can even use it to suppress Smart List values.
Bursting with Targeted Distribution File
Not all CSV files are the same, selecting the wrong format just will not work.
Alternate Period Hierarchy
Ran into interesting error when adding an alternate hierarchy in the period dimension.
Using Groovy to Copy Data Between Cubes
Using Groovy in EPM to copy data...
Add Row to Form
Designing forms in EPM can be easy or challenging depending on the requirements. In general, forms should be easy to maintain by including substitution or user variables to allow usage across multiple scenarios, years, versions, and other dimensions. They also need to perform efficiently by limiting the number of rows and columns by using suppression … Continue reading Add Row to Form