For ASO cube, EAS provides an automatic process to set up the date-time dimension. It has a comprehensive set of options that accommodate different needs in reality. This function dramatically relieves human labor from creating and manipulating the “Date” dimension. (NOTE: This wizard is available only for ASO cube)

[Read more →]

Hyperion Financial Reporting (HFR) is a powerful tool that offers the ability to reduce closing cycles, improve transparency, expedite reporting, streamline compliance, and increase efficiency. Additionally, HFR provides a platform to build hundreds of dynamic reports in a relatively short amount of time.

[Read more →]

Load rules are often used to load large amounts of data into Essbase easily and quickly. When creating these load rules, there are many small things that can go wrong, and because of this, there is a log file that is created to show any kind of warnings or errors that occur when trying to run a load rule. When a load rule is executed, but something goes wrong, the log file will provide a reason for why the load rule did not run successfully. However, there is one instance when load rule status shows as “warning”, but the log file is completely blank. 

[Read more →]

Indent Setting in Smart View

In order to make it easier to view relationships between members in the spreadsheet, Smart View provides users with indentation functionality.

[Read more →]

~~Have you ever found yourself in a position where your dimension hierarchy in an application suddenly disappeared, or you somehow moved a member from the Shared dimension library to the application level? The good news is that it’s not your fault; there is a bug in EPMA that allows a member to be moved from the shared dimension library to the application level without any prompt, verification or dialog box. A member can be moved to the application level and replace the entire dimension hierarchy without asking for permission or giving any type of notification. 
Luckily, there is a verification process and a fix that can be applied before deploying the application. This process is done through the compare feature in the application library. Before making any changes to a deployed application you should compare the current application to the deployed application, make note of any changes then proceed with your updates. After making your updates, you need to rerun the process to verify that nothing other than your intended updates has changed. If you notice that a number of members have been unintentionally excluded, DO NOT DEPLOY. In this case, you need to go to the dimension library and exclude the member that replaced the dimension hierarchy at the application level. After excluding the member, the hierarchy should reappear.

[Read more →]

Looking to improve a Hyperion Planning application or streamline the data mapping process? concerned about the integrity of your organization's financial data as it is collected advice to streamline data integration using Hyperion Financial Data Quality Management (FDM), eliminate the more common frustrations, and maximize the return on your organization's investment.  

[Read more →]

Many of us have been tasked with building a dynamic 13-month balance sheet, 20-month forecast or some other rolling report that spans multiple years. Good news! There are a couple fairly simple ways to build rolling reports in Hyperion Financial Reporting Studio. One can be accomplished through leveraging the “Range” function; the other is through the “RelativeMember.” This post will focus on how to leverage the "RelativeMember"function.

[Read more →]

Many of us have been tasked with building a dynamic 13-month balance sheet, 20-month forecast or some other rolling report that spans multiple years. Good news! There are a couple fairly simple ways to build rolling reports in Hyperion Financial Reporting Studio. One can be accomplished through leveraging the “RelativeMember” function; the other is through the use of the “Range” function. This post will focus on how to leverage the "Range"function.

[Read more →]

Customized business rules, variables, and menus can empower end-users while still maintaining governance over the budget. Calculation Manager, offers the components to create, deploy, and administer business rules and maximize the capabilities inherent in Hyperion Planning to solve business problems.

[Read more →]

Tips and Tricks to help you make the most of Smart View

Using Smart View is one of the most important and powerful ways to take full advantage of Essbase. It offers hundreds of options to help pull, analyze, and report data. Several common questions come up when dealing with Smart View so the following is a list of tricks and tips to help you make the most of your Smart View experience.

[Read more →]