The Bean Blog

Making Sense of the Multidimensional Nature of Data

Entries for month: January 2014
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.

[Read more →]

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.

 

[Read more →]

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.  

[Read more →]

Tags: Financial Data Quality Management (FDM) · Hyperion Planning