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 .

Email Function in essbase calculation

I came across a provision in essbase calc script , where we can send email from within a calc script on execution of the calc script .

The steps are simple and we just need to register few lib files (read the readme,txt in the attachment) and you can use the below command from within the calc script and voila it will send the email . Insert the below command in the calc script . 

RUNJAVA com.hyperion.essbase.calculator.EssbaseAlert "SMTPserver" “to@somedomain.com” "cc@mydomain.com" "" "" "Mail Subject" "Mail Body" "";

http://www.oracle.com/technetwork/indexes/samplecode/essbase-sample-522117.html

This will help in cases where the calc script are long running ones and we cant tell if it finished (unless of course we read the log file ) and users have to bug us to know the status of their calcs, this will notify them directly .

Hyperion Workspace Taskflow Automation

We have Hyperion Workspace Taskflow which are used for variety of execution of tasks .  But without manually logging into Workspace , we cannot call a taskflow outside Hyperion Workspace .

In this blog , we will see an indirect method to call a taskflow outside Hyperion Workspace . 

I will be using LCM to initiate a taskflow outside Hyperion Workspace .  LCM method will enable the taskflow to run after certain amount of minutes 

To Begin 

1. Export Taskflow definition via LCM (by logging into Hyperion Shared service )

2. Log into the server which host the Foundation service , traverse to the path Oracle\Middleware\user_projects\epmsystem_server_name\import_export .  Then to the folder where you opted to export the artifacts . 

You will see a file name $Taskflowname_sched ($Taskflowname).xml which will contain the schedule of the taskflow 

You will notice a section .  We will tweaking this file to initiate the taskflow to start at the specific time 

3.  The above time is a JAVA date time format , so we will a JAVA program to systematically generate this time .  Write the output into file 

import java.io.BufferedWriter;

import java.io.File;

import java.io.*;

import java.util.*;

import java.lang.Object.*;

import java.text.DateFormat;

import java.text.SimpleDateFormat;

import java.util.Date;

public class lcmdate {

  public static void main(String[] args) throws Exception {

    long ONE_MINUTE_IN_MILLIS=60000;//millisecs

    long NO_of_Mins = 10 ;  // number of minutes after which the taskflow should be initiated 

    System.out.print( new Date(new Date().getTime() + (NO_of_Mins * ONE_MINUTE_IN_MILLIS)).getTime());

  }

}

4. Then using DOS script we create a Schedule XML file and then import using the LCM batch utility 

NOTE :  I have not given much details on the scripts used .  If you require more information please request so .