LinkedIn

Game on!  A record number of abstracts were submitted for Kscpoe12, and here are 3 presentations you will want to check out. 

Session 1: Financial Reporting

Josh Forrest is the best FR person I have ever worked with.  He is presenting “Simplify report development utilizing best-practice methodologies with Hyperion Financial Reporting.”  He is going to cover the benefits and drawbacks of using shared objects, among other things. 

Title:  Simplify report development utilizing best-practice methodologies with Hyperion Financial Reporting
Date:  June 27th
Time:  3:00 PM-4:00 PM

Session 2: Infrastructure

Rob Donahue is one of the most talented architecture resources you will ever find.  The Kscope team thinks so highly of him that they have asked him to be involved, have given him a time slot, and are going to determine the topic at a future date.  Whatever the topic, if you want to learn something about the infrastructure side, make sure you attend.

Date: June 25th
Time:  8:30 AM-9:30 AM

Session 3: Hyperion Planning

I will be presenting a Hyperion Planning solution that provides a great way to give users the ability to spread data at a finite level on any spread method defined.  If you are looking to create, or enhance, your budgeting process, you won’t want to miss how we solved this problem. 

Title:  Create Unlimited Custom Spreads for Driver Based Planning
Date:  June 25th
Time:  11:30 AM-12:30 PM

 

We will always be asked to do more with less. Finance is asked to produce more and better analytics with less people. Sales people are asked to produce more in a weakening economy with less marketing dollars, and yes, groups that manage Essbase environments are asked to produce and manage more data/applications with shrinking resources.

Back in the Day

In a prior life, I used to manage a group responsible for managing the Essbase environment used to produce all the reporting for the group. It generated about 70% of the revenue for Bank One (now Chase). We delivered all the reporting, budgeting, and forecasting applications. It included nearly 2 TB of data (pre ASO) on four servers that included more than 50 databases. All the typical technologies were employed. A large number of filters existed to maintain security. Many of the applications were linked together with several types of partitions. Data was loaded daily, weekly, and monthly. SQL Server was used for all the ETL processes, and we completed the development and performed all the maintenance with four people. 

The only way the group could be effective in developing and enhancing applications, was to eliminate our effort spent on typical production activities. With the number of applications and the frequency they were updated (daily, weekly, or monthly), communicating this information to the more than 250 users was also a large time commitment.

The Solution

More...

The newest release of Smart View (Release 11.1.2.1.102) includes many helpful, long-awaited features sure to both enhance the end-user experience and increase productivity. Many of the new features are examined below while a complete list and their descriptions can be found here.

Ad Hoc Operations in Multiple Cells

Previous versions of Smart View limited users to cell level ad-hoc operations. For example; say you wanted to ‘Zoom In’ on a member, Smart View limited this action to a single cell (single member). The newest version allows users to select a range of cells before performing an action allowing for quicker answers. Multi-cell actions such as Zoom In, Zoom Out, Keep Only and Remove Only are now permitted.   More...