OBIEE 11.1.1.7.1 Bugs fixed / to be fixed now or 11.1.1.9 or 12c

I am going to go through a few important SR’s I have raised in the past few months and majority will have enhancements made by Oracle.

The reason why I’m writing this is because I’m hoping other could avoid these bugs if they come across it.

UNABLE TO SHOW TEXT MEASURES IN OBIEE FROM ESSBASE DATASOURCE

I would like to first give an update from my previous blog on Creating Text Entry in Essbase when I said there’s a bug when trying to read text entries from OBIEE. Recently, Dev team replied to have this fixed in 11.1.1.9 which is coming soon. However, there will be a three restrictions as follows (notice it says 11.1.1.8, this should be 11.1.1.9) (Bug 17515163):

Bug17515163

RELEASE NOTES:
  
This trans contains essbase text measure support feature. There are following three restrictions.
1)Essbase text measure member can only be defined on Measure dimension.
2)User need to manually mark the varchar data type in rpd physical layer for text measure.
3)The text measure can be supported only for flat cube model.

I would understand that the text member will need to be defined on a Measure dimension but point 2 and 3 doesn’t really make sense. This means a manual edit will be needed to mark as varchar data type. Moreover, flattening a cube isn’t a best practice. I guess we’ll have to make another suggestion to Oracle.

Continue reading “OBIEE 11.1.1.7.1 Bugs fixed / to be fixed now or 11.1.1.9 or 12c”

OBIEE Patch 11.1.1.7.141014 Bugs Fixed

OBIEE BUNDLE PATCH 11.1.1.7.141014

The Patch is platform specific and is available for:

HP-UX Itanium
IBM AIX on POWER Systems (64-bit)
Linux x86
Linux x86-64
MS Windows (32-bit)
MS Windows (64-bit)
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)

This patch set is available for Oracle Business Intelligence Enterprise Edition 11.1.1.7.0, 11.1.1.7.1, 11.1.1.7.131017, 11.1.1.7.140114, 11.1.1.7.140415,
11.1.1.7.140527 and 11.1.1.7.140715.

This is provided as Single Bundle Patch 19261194 and is comprised of the following:

  • Patch 16913445 – Patch 11.1.1.7.141014 (1 of 8) Oracle Business Intelligence Installer (BIINST)
  • Patch 19190053 – Patch 11.1.1.7.141014 (2 of 8) Oracle Business Intelligence Publisher (BIP)
  • Patch 18657616 – Patch 11.1.1.7.141014 (3 of 8) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
  • Patch 19190025 – Patch 11.1.1.7.141014 (4 of 8) Oracle Business Intelligence Server (BIS)
  • Patch 19190010 – Patch 11.1.1.7.141014 (5 of 8) Oracle Business Intelligence Presentation Services (BIPS)
  • Patch 17300045 – Patch 11.1.1.7.141014 (6 of 8) Oracle Real-Time Decisions (RTD)
  • Patch 16997936 – Patch 11.1.1.7.141014 (7 of 8) Oracle Business Intelligence ADF Components (BIADFCOMPS)
  • Patch 19190111 – Patch 11.1.1.7.141014 (8 of 8) Oracle Business Intelligence Platform Client Installers and MapViewer

NOTE: Also required to be downloaded:

Patch 16569379 – Dynamic Monitoring Service patch

Patch 18277370 – MS IE11 Environment Patch

Bugs fixes

Continue reading “OBIEE Patch 11.1.1.7.141014 Bugs Fixed”

An Essbase OBIEE integration walk through with tips and tricks – Finale

Continuing from the last post – viewed here

Summarizing the tips

  1. Essbase EAS – Give the hierarchies generation name
  2. Essbase  EAS or SubVar Manager – Use Essbase for Substitution Variable
  3. OBIEE RPD – Renaming Measure to Fact and Never Flatten Anything
  4. OBIEE RPD – Double Check Your Dimension & Hierarchy Types
  5. OBIEE RPD – Have a Time dimension. This is usually tagged once imported.
  6. OBIEE RPD – Have your Account or Measure dimension tagged as Measure Dimension and Value as Hierarchy Type.
  7. OBIEE RPD – Uncheck Nullable
  8. OBIEE RPD – Importing Essbase Substitution Variables
  9. OBIEE RPD – Making use of Alias Tables & Uncheck Cacheable

Since the Essbase and RPD is now done. Let’s take a look at Answers and see why these points are considered as best practices.

Continue reading “An Essbase OBIEE integration walk through with tips and tricks – Finale”

An Essbase OBIEE integration walk through with tips and tricks

Best Practices or Tips & Tricks?

It’s probably best practices for myself but tips and tricks for you.

During the past few months, I have been going through theories and logics of KPIs, Dashboards and Strategy management. There are still a lot to go through but I’ve decided to go technical again for those who are missing out on Essbase & OBIEE. I’ve been doing Essbase and OBIEE integration since 2009, accumulated more than 30 Essbase OBIEE projects and there are lots of improvements on the tools since then. Unfortunately, Hyperion experts usually don’t like OBIEE and vice versa. I know that feeling since I came from the Hyperion side and always was an Essbase fan, that was back in 2004. The integration is actually not as difficult as it seems nowadays. You just need some tips and tricks for Essbase OBIEE integration.

Continue reading “An Essbase OBIEE integration walk through with tips and tricks”

OBIEE 11.1.1.7.x Firefox Settings for Admins

Quick Settings for Firefox

Without setting, It doesn’t really affect front end when viewing the dashboards. However, you’ll have some messed up screen when trying to layout the dashboard with columns and sections.

FirefoxMess

 

What we are going to do is to default Firefox to be at a viewable zoom level. Go to a new tab and type “about:config” like below.

AboutConfig

If the warning “This might void your warranty” appears, click “I’ll be careful, I promise”.

Continue reading “OBIEE 11.1.1.7.x Firefox Settings for Admins”

OBIEE Patch 11.1.1.7.140715 Bugs Fixed

OBIEE BUNDLE PATCH 11.1.1.7.140715

The Patch is platform specific and is available for:

HP-UX Itanium
IBM AIX on POWER Systems (64-bit)
Linux x86
Linux x86-64
MS Windows (32-bit)
MS Windows (64-bit)
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)

This patch set is available for Oracle Business Intelligence Enterprise Edition 11.1.1.7.0, 11.1.1.7.1, 11.1.1.7.131017, 11.1.1.7.140114 and 11.1.1.7.140225.

This is provided as single Bundle Patch Patch 18818588 and is comprised of the following:

Patch 16913445 – 1 of 8 Oracle BI Installer (BIINST)
Patch 18841070 – 2 of 8 Oracle BI Publisher (BIP)
Patch 18657616 – 3 of 8 EPM Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
Patch 18841084 – 4 of 8 Oracle BI Server (BIS)
Patch 18841078 – 5 of 6 Oracle BI Presentation Services (BIPS)
Patch 17300045 – 6 of 8 Oracle Real-Time Decisions (RTD)
Patch 16997936 – 7 of 8 Oracle BI ADF Components (BIADFCOMPS)
Patch 18841089 – 8 of 8 Oracle BI Platform Client Installers and MapViewer

NOTE: Also required to be downloaded:

Patch 16569379 – Dynamic Monitoring Service patch

Patch 18277370 – MS IE11 Environment Patch

Bugs fixes

Continue reading “OBIEE Patch 11.1.1.7.140715 Bugs Fixed”

OBIEE Patch 11.1.1.7.140527 Bugs Fixed

OBIEE BUNDLE PATCH 11.1.1.7.140527

Bugs Fixed by This Patch

Oracle BI EE Suite Bundle Patch 11.1.1.7.140527 includes all the bug fixes released in Oracle BI EE Suite Bundle Patch 11.1.1.7.140415.

This is provided as single Bundle Patch  Patch  18507268 and is comprised of the following:

Patch 16913445 – 1 of 8 Oracle BI Installer (BIINST)
Patch 18507640 – 2 of 8 Oracle BI Publisher (BIP)
Patch 18657616 – 3 of 8 EPM Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
Patch 18507802 – 4 of 8 Oracle BI Server (BIS)
Patch 18507778 – 5 of 6 Oracle BI Presentation Services (BIPS)
Patch 17300045 – 6 of 8 Oracle Real-Time Decisions (RTD)
Patch 16997936 – 7 of 8 Oracle BI ADF Components (BIADFCOMPS)
Patch 18507823 – 8 of 8 Oracle BI Platform Client Installers and MapViewer

Also required to be downloaded:
Patch 16569379 – Dynamic Monitoring Service patch

Continue reading “OBIEE Patch 11.1.1.7.140527 Bugs Fixed”