Several of the updates to the Hyperion 18.104.22.168 suite are behind the scenes, not noticeable for users, except for users of Planning – with new predictive and chart functionality and Smart View users – who don’t have to upgrade the back end (server services) to take advantage of some:
- Support for 64-bit Microsoft Office 2010
- Planning Enhancements for: cell history – so you can review changes to a cell or range of cells and reverse changes, master composite forms (a new type of form), attachment of multiple comments to data cells, customized confirmation messages and support for approvals security
- Smart View supports Financial Management configurable dimensions
- New VBA features for: HypGetMemberInformationEx, HypGetActiveMember, HypSetActiveMember, HypGetDimensions, HypSetDimensions, HypGetMembers, HypSetMembers, HypGetBackgroundPOV
- New Logging Levels: Extended and Profile
- Excel Formatting enhancements to maintain formats when zooming in and pivoting
- New Extensions for Predictive Planning and Strategic Finance
- Smart Query – which is a new reporting tool which allows users to construct report sets from members and filters. these sets can be combined to create complex queries with joins and intersections of data from the defined data sets
- Changes to the Smart View ribbon to include Panel and Connection buttons for easier, more intuitive access (According to Oracle) to Smart View connections
I’ll spend some more time reviewing the new Smart Query feature next time, so stay tuned.
For more info, check out the Smart View documentation on the Oracle Doc Library:
Bootnote: As with any software upgrade, this one is not necessarily a slam dunk – in that it should always be installed. Please review the Readme paying particular attention to the known issues list – while Oracle have fixed 46 issues in this release, there are 104 known issues across all smart view components.
There has also been the following identified as an unknown issue:
BUG 14055582: When selecting a range of cells, then attempting to use the right click range menu, the right click deselects the range and only the last cell is highlighted. A work around is to select whole rows or columns to perform right click selections.
So review the docs and test, test and test again making sure the enhancements don’t take away any functionality key for your users.
After attending the recent Oracle update on their business analytics strategy, including the latest Hyperion release and Exa-everything supercharged hardware and software stacks I had expected the usual follow up emails asking me to buy and sell to clients.
However, along with the links to the recorded presentations and content (in pdf), there was also link to download in ibook format.
That just goes to show how ubiquitous the iphone/ipad has become in the corporate world.
Interesting to see that it’s not just a pdf converted, there are links as well as video embedded (see image below).
Now I only need an exalytics box to play around with …. 😉
Almost a year since 22.214.171.124 was released, Oracle have had a big event in Tokyo to announce the release of 126.96.36.199 (among other things).
Great to see our president and founder Robin Ranzal quoted in the release:
“Organizations that lack visibility into cost and profitability will find the expanded features of Hyperion Profitability and Cost Management attractive,” said Robin Ranzal, president of Edgewater Ranzal. “These features allow revenues and costs to be allocated at a very granular level. Executives gain improved insight into how customer-driven interactions across any channel impact profitability and allow for improved decision-making about company offerings.”
It will probably take a few days for the downloads to be released and the new readmes and known issues fully read and understood. Then there should be a flood of information on the internet tubes 😉
The one interesting note is that Oracle Hyperion Calculation Manager has replaced Oracle Hyperion Business Rules as the mechanism for designing and managing business rules, therefore, Business Rules is no longer released with EPM System Release 188.8.131.52. If you are applying 184.108.40.206 as a maintenance release, or upgrading to Release 220.127.116.11, and have been using Business Rules in an earlier release, you must migrate to Calculation Manager rules in Release 18.104.22.168.
My abstract has been selected for the Kscope EPM Business Content – Subtopic: Product Demos topic, so I’ll be in San Antonio, Texas in late June presenting:
How data visualization can give you an extra edge in bringing and maintaining happy users.
While previous presentations have covered mostly stand-alone data visualization, this one also looks at how it can help in creating a reporting ecosystem to understand how to bring components (including visual ones) together to enable users to get to the answers faster and easier. So users spend time on decisions, not on compiling reports.
I’ll post some information leading up to the event, but in the meantime, you can head over to the Ranzal blog, where I’m also posting a series on using data visualization and usability to enhance end user reporting.
I’m looking forward to Kscope to catch up with colleagues, industry thought leaders and immerse myself in a great learning experience. Hope to see some of you there!
Following on from last post on educational conferences, is news of a webinar on Hyperion Strategic Finance focusing on the Utilities Industry and titled: Utilities Industry – Driving Shareholder Value through Long-Term Planning and Scenario Modeling
This one is presented by Edgewater Ranzal, with Ricardo Rasche showing how corporate finance teams can leverage Hyperion Strategic Finance to run simulations and pressure-test key drivers across integrated P&L, Balance Sheet and Cash Flow statements. Ricardo demonstrates key functionality specific to companies in the Utilities industry, including What-if Analysis on Key Value Drivers, Rate Case Strategy, Funding and Liquidity, and Commodity Prices.
In order to meet the global audience, two sessions have been set up on Wednesday, June 29th 2011:
Edgewater Ranzal is an Oracle Certified Platinum Partner providing consulting services for the entire suite of solutions available on the Enterprise Performance Management platform. With a national presence, we are considered one of the largest Oracle/Hyperion EPM services partners.
Thanks to Nate, for the heads up!
Bootnote: The following day is another presentation, this time aimed at Reporting and Analysis for Healthcare Providers, again there are 2 presentation times. Also click the link above for previous webinars available via replay.
The UK folks have the OUG EPM & Hyperion conference this week, with a full packed agenda covering a range of Hyperion topics as well as OBIEE for those wondering where the future lies. This will be my first year since 2006, when I’ll miss the conference, now that I’m based in the US.
So me highlights for me include AMOSCA’s session on “Unravelling the EPM spaghetti” and Edward Roske – always a great speaker with lot of tips and tricks to share crammed into his sessions.
But there’s plenty of action stateside happening too, thanks to the OAUG:
OAUG Connection Point – R12.1, July 12-13, Chicago.
OAUG Connection Point – EPM/BI, July 20-21, Seattle.
OAUG Connection Point – EPM/BI Nov 15-16, Atlanta.
For me the Seattle conference, presented by OAUG, Northwest Oracle User Group, OAUG Hyperion SIG and OAUG BI SIG, has added significance since it’ll be my first presentation in the US:
- “Why Data Visualization is Important in Delivering Actionable Insight”
Helping business users gain insight and enabling them to do their jobs better has always been a key component in my work ethic, I look forward to sharing and learning from the other participant and speakers.
So take advantage of these great opportunities and I hope to see some of you soon.
When presenting reporting designs to clients it’s important to focus on the clarify and impact of the reports or charts. There are many examples of excessive decoration or chrome and others also seek simplicity.
While some clients have requests for fancy dashboards – flashing colors, traffic lights or other ‘sexy’ paraphernalia, I can most often turn them down by focusing on the reader and how their understanding is helped by clarity with a focus on letting the numbers or data points tell the story.
I’ve had some spare time lately, so put it to use with some Oracle presentations – the last one was on Weblogic. Given that Weblogic is now an integral part of the Hyperion stack in 11.1.2, it made sense to review the new member of the family.
The Virtual Developer Day, was a mocked up conference room and auditorium with carpet and chairs, which navigating to the topics was easy enough it was all a wrapper for youtube content. Which, while it looked impressive (kind of), it didn’t help with delivering the messages* – there were many comments on the chats about what items to click on and where the actual content was.
Here’s a couple of screenshots of the main auditorium and conference rooms – for me this was overkill, developers don’t care as much about presentation they care about the details and information.
Before you go ahead and add decoration to reports, please think again and ask yourself if it adds any value or is just distracting. Hopefully together we can make the world a cleaner and more beautiful planet 😉
* Don’t get me started on the presentations – they were fairly dull and the quality was poor – monotone presenters who didn’t seem to have read or rehearsed the material before it was recorded. And I’m not really any wiser about Weblogic.
Several years ago Sun began a project to update and consolidate the business intelligence tools used at Sun and we decided on Hyperion as we had a variety of Hyperion tools already: Brio, Essbase. This was a few years before the Oracle acquisition of Hyperion and we wanted to run on Solaris.
This meant we were one of the first customers to run the Hyperion suite on Solaris and I frequently had conversations with other Hyperion experts similar to the title of this post and was also told that Essbase was designed on windows and would therefore run best on windows.
While the original implementation had it’s difficulties being one of the first on Sun hardware, software and operating system it undoubtedly laid the groundwork for the recent Hyperion Essbase ASO World Record on Sun SPARC Enterprise M5000.
The Oracle Essbase Aggregate Storage application employed for the benchmark was based on a real customer application in financial industry with 13 Million members in the customer dimension.
The benchmark system was a M5000 server with 4 UltraSPARC64 Vii 2.53 Ghz (quad core) and 64Gb ram running Solaris 10 update 8 and Oracle Essbase 22.214.171.124 (64 bit) combined with a Sun Storage F5100 Flash Array consisting of 40 x 22 GB flash modules in a single zpool.
The benchmark compared 500 and 20,000 users and showed that usage based aggregation improved response times, while adding the extra users showed similar performance with no signs of degradation in query timings.
What is interesting in the benchmark is that this seems to be one of the first to combine a variety of Oracle technology and provide a benchmark for John Fowler to beat: Solaris ZFS, SPARC M9000 server, Storage F5100 Flash Array and Essbase.
For more information check out the whitepaper here(pdf), Note: the BestPerf blog has an incorrect link since the recent update to the Oracle Technology Network. More details on Hyperion applications here.
It’s not often that users have the chance to provide direct feedback and suggestions to product managers and designers.
The UK Oracle User Group are providing a format for that in their annual Hyperion survey. They then feed the results directly to Oracle, so that they can act on the feedback they receive.
What would you say to a senior member of Oracle staff if you were given the chance? Take the opportunity to submit your views today: www.oug.org/epmsurvey
Please note that the survey close date is July 28th, so get cracking!