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)
The Bean Blog
Making Sense of the Multidimensional Nature of Data
Create Date-Time Dimension Wizard (ASO only)
March 11, 2014 ·
Tags:
Reporting Tips and Tricks
February 22, 2014 ·
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.
Tags: Hyperion Financial Reporting (HFR)
Receive Load Rules Warning, But Error File Is Blank
February 01, 2014 ·
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.
Tags:
Indent Setting in Smart View
January 22, 2014 ·
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.
Tags:
Where is my Hierarchy?
January 14, 2014 ·
~~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.
Tags:
Leverage Your FDM Investment: Data Loading Fast & Flexible
January 09, 2014 ·
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.
Tags: Financial Data Quality Management (FDM) · Hyperion Planning
Hyperion Financial Reporting: Build a Rolling Reports – Relative Member
November 14, 2013 ·
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.
Tags: Hyperion Financial Reporting (HFR)
Hyperion Financial Reporting: Build a Rolling Reports – Range
November 14, 2013 ·
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.
Tags: Hyperion Financial Reporting (HFR)
A Calculation Manager that Works for You Empower End-Users of Your Hyperion Planning Application
November 08, 2013 ·
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.
Tags: Hyperion Planning
Tips for Frequently Asked Questions About Smart View
November 08, 2013 ·
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.
Tags: Smartview