Alternate Period Hierarchy

Ran into interesting error when adding an alternate hierarchy in the period dimension.

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 →

Retrieving Variables with Groovy

Here's an easy way to use Groovy to retrieve variables when running business rules.

EPM Reports – Import Books to Smart View

EPM Books in Smart View, cool new feature to check out!

Drill-through Has Duplicate Data

Drill-through results doubled? This might be the reason.

Migration with Clone Environment

If you've been annoyed with all the steps to migrate EPM applications, Clone Environment might be the solution.

Curse You Perry the Platypus, errr, I mean Suppress Missing Blocks!!!

Suppress missing blocks in Smart View is a setting I never enable.

Period Offset

The PeriodOffset function in Cloud EPM Reports is a cool feature to create dynamic reports with trailing (or forward looking) periods across years.

Continuing Adventures in Drill-Through

Apparently, drill through is case sensitive.

Data Push for Non-Administrator Users

Here's a way for non-administrators to execute data maps, it's pretty Groovy.