Aggregation issue with Hyperion Planning

Aggregation issue with Hyperion Planning

One of my friends recently called and me that the parent in her Hyperion Planning was not aggregating even if the aggregation script was ran multiple times. She double checked the aggregation script and there was no logical or syntax errors. The Parent has multiple children and half of them or dynamic calc and other are store members. What was the issue.

In this type of cases before going aggregation script we must first check the consolidation properties. There was an offshore team in India and they changed the consolidation property to "Ignore" and she was not informed.

Again this issue may look very simple but the order in which we trouble shoot may save time. Instead of banging head looking at aggregation script, we should first check the consolidation property.

What are patches in Hyperion product suite

For many people who work in Hyperion product suite for a long time this is a silly question.
One of my friends who just started asked me this question. He got confused between

Multi server Hyperion Environment
Patching
Load balancing

I will try to explain in simple terms what the above mean. First lets go to Patching.
Same as humans No software is built perfect, as it was built by humans :-)
When a new version of software is released some of the components of it may not work properly. The issues are generally called bugs. If a particular software has lot of bugs the software development team will combine solutions for all the known bugs into an small additional release called Patch.
For example Hyperion smart view version 11.1.2.2 has some issues to it. Oracle Hyperion combined all the solutions to those issues and released a .300 patch. When you install the patch our 11.1.2.2. version will be now 11.1.2.2.300 version.
similarly for Hyperion planning we have 11.1.2.2.300

How do we know what's included in the patch?
we get all the information about the patch like what bugs it is fixing in the read me document of the patch. The patch can be downloaded from
https://support.oracle.com/epmos/faces/PatchHome?_adf.ctrl-state=1mr4xxdz8_9&_afrLoop=323389713099946

To install the patch is it as simple as double click the .exe?
You need to be careful in applying the patches. You have to read "readme" document first and see if there are any prerequisites. For example Planning may have some prerequisites in foundation etc.,
In a nutshell strictly follow readme document even if you don't like it.

Unable to login to Hyperion Workspace or Planning.

Unable to login to Hyperion Workspace or Planning.

One of my friends got this error which says EPMCSS-0031: Failed to authenticate user. Invalid credentials. Enter valid credentials.

All the services (Hyperion Planning, foundational, APS, EAS) were up and running. The passwords were not changed. She tried to restart the services but no luck.

Finally she checked whether the relational databases which support foundation and planning were up. The prod support told that there was an issue on relational database side and they were down.

The gist of this post is if we have this error, we first need to check whether relational database is running or not, next did anyone change the password and then are the services running are not.

Hyperion Upgrade Issues

Recently we upgraded our Hyperion product suite from 9 3 1 to 11.1.1.2.2.300.
I will list all the issues we faced on the road to latest and greatest hyperion product suite. 

Issue #1
Its common practice of the users to reuse the smartview templates. When some of my users open smartview templates which were created in older version they get an error "COMMON PROVIDER SESSION TYPE MISMATCH". The error can be  resolved by closing the sheet and open it again. However this is very annoying as some of the business users use Smart view for most part of their day. Oracle suggested the following resolution
"
1) Open workbook (Don't refresh),
2) In SmartView panel navigate to the required connection and connect.
3) Right click on connection and click on "Adhoc analysis".
4) Choose the following option on prompt "Reuse sheet content and pov".
5) A message box will display with following info "Old SmartView grid format detected, This operation will convert the grid into the new format, do you want to continue?" click Yes.
6) After that save the workbook and user can continue normally.
"