ODI Series – Issues with 11.1.1.5 and the Hyperion knowledge modules

Recently on the ODI forum an issue was brought to my attention when using 11.1.1.5, Hyperion planning and the staging area set to the memory engine. Now I have used ODI 11.1.1.3 with the Hyperion knowledge modules and not really experienced any major issues but I have not had the opportunity to test them out on 11.1.1.5

In the support matrix for 11.1.1.5 it says the modules are certified for 11.1.1.3+

Considering most of the technologies say 11.1.1.3+ I assuming that means 11.1.1.5 should be supported for the Hyperion set.

The issue with loading planning metadata using the memory engine as the staging area can easily be replicated.

A simple interface is created loading one record from a flat file source a dimension in planning, it doesn’t really matter which dimension it is as issue occurs across them all.
The equivalent interface definitely works on 11.1.1.3

The staging area is set to use the Memory Engine.

The error generated is

com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: The source result set contains column [C1_ACCOUNT] which has no corresponding column on the planning side.

For some reason "C1_ACCOUNT" is being passed to planning instead of "Account"

The code generated is same as on previous versions and querying the memory engine seems to return the correct results.

I think the issue does lie with the memory engine as changing the staging area to another rdbms technology such as Oracle allows for the successful execution of the interface.

So there is a workaround to the issue but if you are considering moving to 11.1.1.5 and currently use the memory engine in planning interfaces it is one to watch out for until a fix arrives.

While I had the chance I thought I would just test out a metadata load to essbase to see if there were any issues.

Once again a simple interface was created to load one record of metadata to an essbase database; the interface was tested on 11.1.1.3 and then recreated using 11.1.1.5

The only difference with 11.1.1.5 is it looks to includes patches that I wrote about here for 10g which provide an extra column for sortid.

Executing the interface on 11.1.1.5 generates and a Java related error and causes the interface to fail.

I thought maybe it was down the ODI installation so I tested out on a different 11.1.1.5 install and the same problem exists, so either I am really unlucky which could easily be the case or there is definitely a problem (if anybody else has tried this and doesn’t see the issue then let me know)

It is also worth pointing out this issue is only with loading metadata, loading data and extracting metadata still works without any issues.

As the error points towards to an issue with java files that the modules use I thought I would look into replacing them with ones from another version.

I decided to go with ones from 10.1.3.6.8 as these contain the fixes that include the sort id and are newer than ones in the 11.1.1.3 version.

The files replaced were odihapp_common.jar and odihapp_essbase.jar though it should be possible just to replace odihapp_essbase.jar.

If you look at the file size the 10.1.3.6.8 ones are bigger so I assuming contains additional code.

After replacing the jar files the same interface executes without any issues so it does look like a problem with the java files released with 11.1.1.5

I know this is not the official way of going about things but at least the essbase interfaces successfully complete and is a workaround if you are also experiencing the same issue until an official fix from Oracle comes along.

Schema Creation in Oracle.

create Tablespace:
create tablespace HSS datafile 'C:\oracle\product\10.2.0\oradata\orcl\HSS.dbf'size 200M autoextend ON maxsize 1800M;


To Create User:
create user hypuser identified by password default tablespace HSS temporary tablespace TEMP;


Grant Permissions:
grant CONNECT,RESOURCE, ALTER SESSION,CREATE CLUSTER,CREATE DATABASE LINK,CREATE SEQUENCE,CREATE VIEW,CREATE SYNONYM to hypuser;

Which Table holds Cell Text and Supporting Details.

They are held within the database tables of your planning application.

For cell text the tables are >
HSP_CELL_NOTE & HSP_CELL_NOTE_ITEM

For supporting detail the tables are >
HSP_COLUMN_DETAIL, HSP_OBJECT & HSP_COLUMN_DETAIL_ITEM

Table name: HSP_COLUMN_DETAIL
Description: One row per line item detail will exist in this table. This table stores unique numbers which relate to the dimension names and also the detail_id which is a value to find the specific cell detail.

Table name: HSP_OBJECT
Description: This table is used to translate DIM1 – DIM22 ID’s into member names. Object_name is the member name. If the member has an alias the HSP_ALIAS table must be queried.

Table name: HSP_COLUMN_DETAIL_ITEM
Description: One row per line item detail will exist in this table. This table stores unique numbers which relate to the dimension names and also the detail_id which is a value to find the specific cell detail.

Cannot access the EPMA menus (for example, "Dimension Library", "Application Library" etc) from the workspace

I have installed EPMA 11.1.1.3 and I've configured the product as well. Everything went fine. The services start well.
However, when I cannot access the EPMA menus (for example, "Dimension Library", "Application Library" etc) from the workspace. The options are not displayed under "Navigate" -> "Administer".


Solution:
If you configured workspace before EPMA then you may need to go to the configurator again, choose Foundation > Workspace and do the reconfiguration again then it will 

Validation Log disappears immediately in EPMA.

I have created a Hyperion Planning Appplication using EPMA sucessfully and when i click on validate button. It throws some that there are some errors in my application. When i click on validation log. The popup window appears and disappears immediately.

To Resolve the above issue. Follow the below steps.

Ensure that pop-up blocker is turned off
In IE: Tools | Internet Options | Security (tab):
Click on Trusted Sites
Click on “Custom Level…” button
Change the setting Automatic Prompting of File Downloads to “Enable

How to check web service of each particular application is active or not

An non-Error indicates that all your web service of each particular application is working fine.

http://hostname:19000/workspace/status
http://hostname:19000/workspace/BPMContext
http://hostname:8600/mappingtool/faces/info.jspx
http://hostname:10080/easconsole/console.html
http://hostname:16000/WebAnalysis
http://hostname:6373/oracle-epm-fm-webservices/ApplicationService
http://hostname:8300/HyperionPlanning/
http://hostname:13080/aps/APS
http://hostname:8200/hr/status.jsp

Error Logging in to EPMA: 'Module not found:awb.appcontainer

Symptoms
When attempting to log in to Enterprise Performance management Architect (EPMA) the following error occurs:

Module not found:awb.appcontainer.

This is following by a second error after clicking on 'OK':

(404)Not Found (org.apache.axis.AxisFault)

Clicking on the 'Details' link displays the following:

Trace: com.hyperion.awb.web.common.BaseService.openSession(BaseService.java:112)


Solution
1. Open the IIS Manager.
2. Right-click on “Default Web Site”.
3. Select New > Virtual Directory.
4. Define the following Alias: hyperion-bpma-server.
5. Browse to the following directory: %HYPERION_HOME%\BPMA\AppServer\DimensionServer\WebService .
6. Check the following access permissions:
a. Read
b. Run scripts (such as ASP).
c. Execute (such as ISAPI applications or CGI).
7. Click on “Finish”
8. Right-click on the “hyperion-bpma-server” Virtual Directory .
9. Select “Properties” .
10. On the Virtual Directory tab clear the Application Name and click on “Apply”.
11. On the Documents tab remove all the default content pages and add “-1”.
12. On the Directory Security tab > Authentication and Access Control, click on “Edit” and check “Integrated Windows authentication”.
13. Repair the .NET framework 2.0 software installation (it is required since we uninstalled IIS; consequently it is not properly registered with .NET 2.0).
14. Open the ASP.NET tab of the “hyperion-bpma-server” Virtual Directory and select “2.0.50727” the as ASP.NET version.
15. Restart the EPMA services.
16. Confirm that it is now possible to login to EPMA without error.


It can also be the configuration Issue.
Cause
Configuration issue with Internet Information Services (IIS).

Solution
Check the following points:

Go to IIS:
Start > All Programs > Administrative Tools > Internet Information Services (IIS) Manager

a) In Web Sites > Default Web Site, check the site is running, if not start it (click on the > button).

b) In Web Sites > Default Web Site, right click and select 'Permissions' Check the group IIS_WPG is in the list. If not, add it.

c) In Web Service Extension, check ASP.NET v2.0.50727 is set to Allowed. If not, Allow it.

Essbase Database Size Increases Dramatically After Calculation or Restructure.

Cause
Recreated the Essbase security file (essbase.sec). This causes the compression level to be reset to "No Compression".


Solution
The database will need to be restored from back-up and the compression level reset to BitMap Compression. This can be done in Essbase Administration Services. Right-click on the database name, Edit->Properties->Storage. After restoring the files from backup, force a dense restructure.

If the backup is an export of the database, do the following:

1. Clear all data from the database.
2. Reset the Compression Level to BitMap Compression.
3. Stop and start the application to ensure the new setting takes affect.
4. Load the exported file.

Identifying LISTEN Ports for Hyperion Services

Windows OS:
On the machine where the service is running:
1. Right-click on the Windows Task bar and select “Task Manager.”
2. In Task manager, select the “Processes” tab
3. Select view -> Select Columns
4. select "PID(Process Identifier)" to display the process identifier associated with the running server.
5. selct ok
6. In the "Process" tab, locate the process associated with the service for which you wish to idenfity the port.
7. Note the "PID" associated with the process.
8. slect start -> Run and type cmd
9. netstat -na|findstr PID

UNIX OS

ps –ef | grep processName (where processName is a text string associated with the process )

Once you have identified the Process ID, on most version of Linux/UNIX, you can use
lsof | grep ProcessID
to identify the port associated with that process.

IN Which Tables the Hyperion Financial reporting objects are stored in the relational database

You can get the list of all FR-related objects created by running the below SQL statements against the BI database:

Financial Reporting Report:
select * from v8_container where meta_type_uuid = 'ID200'


Financial Reporting Snapshot Report:
select * from v8_container where meta_type_uuid = 'ID201'


Financial Reporting Batch:
select * from v8_container where meta_type_uuid = 'ID204'


Financial Reporting Book:
select * from v8_container where meta_type_uuid = 'ID202'

Installation of Hyperion Enterprise Management System 11.1.2 on Windows Server 2008 (32 Bit)

Hi,

You can download the Hyperion Enterprise Management System 11.1.2 Installation on Windows Server 2008 (32 Bit) from here.

Link:
http://www.box.net/shared/2x4qnfrr0ldykmi96556

INTERVIEW QUESTIONS ON HYPERION.

Hyperion Interview Questions Asked in FCS.
1) Can you brefiely Tell me about yourself?
2) What is the archeitucture of your Project?
3) How many Databases can i create under a Planning Application?
4) What are the required dimensions in Hyperion Planning?
5) How many dimensions that i can create using hyperion planning Application?
6) How many dimensions are there in your project and what are they?
7) Can you tell me the procedure how do you take the Backup of the Hyperion Planning Application?
8) How do you export data in Essbase?
9) What are your roles and responsibilities in your current project?
10) Tell me the process of creating a admin user?



Hyperion Interview Questions Asked in Credit Suisse, Singapore
1) What are different types of partition?
2) what is the difference between transparent & Linked partition?
3) what is the use of Replicated Parttion?
4) What are different types of hierarchies in ASO?
5) When do you choose Multiple hierarchiey enabled?
6) how can i kill an essbase process
7) When i try to kill a procss and its in hung stage? What do you do?