Hyperion Planning Smart View Error

We recently found a very strange error when we are connecting to Hyperion Workspace version 11.1.2.4.

Before I proceed , note we are using SSL at F5 load balancing url ie we are using link like https://F5_server_name/workspace/index.jsp

The error was occurred when the users go to Hyperion Planning in Workspace and try to open the forms using the File-> Open in Smart View button 

Below is the error which the users get when performing this action

Digging on this we observed that when we use a non SSL link like http://HSS_Server_name:19000/workspace/index.jsp , the issue does not exists .

Working with Oracle Support , we implemented the below settings and it did the trick and user are able to perform the above described action in Hyperion Planning .

-----------------------------option 1---------------------------

1) Start Weblogic Admin server, login to console

http://localhost:7001/console.
2) Click on the domain name, go to the left-hand navigation and click on the "Web Applications" tab, then scroll down
3) At the bottom and check the "WebLogic Plugin Enabled", then scroll down to the bottom of the page and hit "Save".
4) Restart Weblogic servers.



-----------------------------option 2---------------------------

On all http servers, edit the mod_wl_ohs.conf file and add the following line to the bottom:
WLProxySSL ON
Save the file and restart all servers including OHS

ASO - Some Facts on the Bits Used Statistics

ASO -  Some Facts on the Bits Used Statistics

If look at the properties tab on a ASO database , in the statistics tab you will find something called bit used for each dimension

So what does this signifies ?

ASO uses a bitmap mask to represent each stored member in the dimension as shown below .

BitMask	Member
000	Original Price
001	Price Paid
010	Returns
011	Units
100	Transactions

Thinking this through ASO will have to increase the number of bits  when we add new members to a hierarchy .

As shown below we added three new members Amount , Sales , price under the parent “Measures” , ASO stills shows number of bits as 3 - it did not increase the number of bits.

Hmmm… Its because ASO can still represent the new members with the existing number of bits.

BitMask	Member
000	Original Price
001	Price Paid
010	Returns
011	Units
100	Transactions
101	Amount
110	Sales
111	Price

Lets add one more member Market_Sales .  Now Essbase will have to add one more bit to represent the additional member .  Hence in the statistics tab it shows 4 bit used for the dimension measure

BitMask	Member
000	Original Price
001	Price Paid
010	Returns
011	Units
100	Transactions
101	Amount
110	Sales
111	Price
1000	Market_sales

HFM 11.1.2.4 database connection issue

Currently working with a client who have EPM 11.1.2.4 installed on Windows 2012 server with Oracle as the back end.

The HFM 11.1.2.4 environment came down couple of times during course of the month usually close to the end of the week.

A symptom noticed was that the database connections on Oracle Server were high and it was hogging the resources on the Oracle Server.

Working Oracle support , we found that there is an odd behavior with the HFM 11.1.2.4 (patch 201) where it does not close database connection once they are opened .

They filed a bug with Development and a merge patch

23527466

MERGE PATCH FOR BUG 23218586 (Patch)

 was provided  which once when installed , fixed the issue and we did not notice anymore HFM server crash .