Some tips for OBIEE12C and HFM11.2.0.4 and resources

Step to connect OBIEE 12C to Oracle (Hyperion) HFM 11.2.0.4 isn't easy. Step quite complex, detail step-by-step you can follow this official link https://support.oracle.com/rs?type=doc&id=2158975.1

** require oracle account password

Main step is below
1. Installing and Configuring Hyperion Financial Management ADM Thin Driver
2. Configuring Communication Between OBIEE 12c and HFM
3. Configuring the BI Administration Tool to be able to Import an HFM Application
4. Importing an HFM Application Into the RPD
5. Creating a Subject Area in the RPD
6. Accessing the New Data Source Using Analytics

Steps in oracle link is straight forward but we still face issue, so I write this blog to keep information about setup/configure OBIEE 12C to Oracle (Hyperion) HFM 11.2.0.4 for reference.

First issue , you might be face
- Duplicate / garbage data for Null value
- When you done for configure for connection and it worked, when you create new Analysis report and found some error/garbage data at some row that have null value , this's I mean

Entity Name 03, 04, 05 show same value

Solutions

You can use expression IFNULL to fix this issue, this issue because OBIEE12C have a issue of Null value so once we found this we can put IFNULL(Measures,0) to change Null value to zero and garbage data will gone.

** For resolved picture, it have something change is we put *(-1) for expense account so you can see opposite sign. But main point is abut Entity 03,04,05 show the correct value that is zero (Null from system)

Focus for orange circled that show 0 instead of garbage values