Updating dimension member properties is a common practice in an EPM Planning/Financial Close system. This includes updating alias, member formulas, aggregation operator, etc. The traditional way is to load an updated dimension file to the system. However, bulk uploading dimension member names is always a tricky task. Especially in the on-premises Hyperion Planning…
In an ASO reporting cube, it is important to properly clear data before pushing or copying data. ASO does not work as a BSO cube which has the block concept. In a BSO cube, copying a #missing value is common. But in an ASO cube, it will do nothing when it comes to copying the…
Groovy business rules give us the flexibility to customize the job log messages. Not only just seeing whether the job ran successfully or failed, but it can also tell a lot more. For a quick example, I am running a dummy business rule and the job log displays the duration of the rule and…
The attribute dimension is a special dimension that is associated with a business dimension. It is useful and powerful for filtering dimension members, processing specific calculations, and doing reporting. Attributes group data through alternative means as opposed to utilizing the existing dimensional rollups. For a more detailed attribute introduction, check the following previous…
The recent EPM monthly updates brought a few great REST API enhancements. With new classes added to the Groovy library, it is now possible to interact with external web recourses. This surely creates tons of potentials for EPM planning solutions. Recent Patches Firstly, let’s take a step back and see what exactly got…
Strategic Modeling, as the cloud version of Hyperion Strategic Finance, is a forecasting product that creates a comprehensive financial statement with out of the box treasure capability, scenario analysis, debt modeling and robust consolidation capability. It allows you to quickly understand the major impact of the strategic decisions on your future financials which is valuable…
The Enterprise Planning Cloud (EPBCS) comes with four prebuilt business processes: Financials Workforce Capital Projects Each of the business processes comes with several prebuilt business rules. Some of these rules are written by Essbase calc scripts, and others are written by Groovy. Now let’s take a look at the majority of the prebuilt rules…
Groovy is becoming a hot topic these days, since EPBCS integrated Groovy into Calculation Manager in June 2017. Groovy business rules allow us to design sophisticated rules solve use cases that normal business rules cannot solve. I think it is good to start a new series to discuss about Groovy. Hope you will enjoy…
When I was working on on-premises Hyperion projects, and when it came to the automation and integration processes, I typically use batch files, PsExec and Task Schedule to achieve that. The batch files and other related files will be stored in clients’ server. For example, InputFiles folder contains Business rule list, substitution…