Tuesday Jul 30, 2013

Disabling Implied Share for an Essbase Application

Implied share is the default behavior in Essbase where a data relationship is shared explicitly between parent and child members in the outline. Implied share occurs when a parent has a single child or a parent has only one child of many children that consolidates to the parent in an Essbase outline.

If you need to disable all implied shares in a given outline, there is an Essbase configuration setting that can be set in the Essbase.cfg file. As part of the supported steps, it is recommended to rebuild the outline after the IMPLIED_SHARE <ApplicationName> FALSE setting is in place. This post it to help the field where in certain situations rebuilding the outline may be challenging. There is a way to set an existing outline to have implied share disabled, however, there are risks associated with these steps and no guarantee the metadata and data implied share setting are in sync. If there are any issues after following the “unsupported” steps, Oracle Support will require that the supported steps be followed first.

[Read More]

Saturday Jul 20, 2013

Performance issues after upgrading Essbase outlines from 11.1.1.x to 11.1.2.x

After upgrading Essbase from the 11.1.1.x to 11.1.2.x releases, run through your sanity tests, such as outline dimension build updates, data loads, calculations, queries, etc.  If you encounter any performance issues on the newer release of Essbase (for either ASO or BSO models) as compared to the previous release, rebuild the problematic outline on the current 11.1.2.x release.  It is possibly that the outline did not migrate properly during the upgrade process.  

Once you have rebuilt the outline, run through your tests again and if you still encounter performance issues, open an SR with Support.


 

Friday Jul 19, 2013

HFM 11.1.2.3 / OBIEE 11.1.1.7 Integration using the new ADM thin driver

For details on configuration steps on-how to perform HFM 11.1.2.3 / OBIEE 11.1.1.7 Integration using the new ADM thin driver, download this pdf document.

 


 

Exalytics V1 - Exalytics Deployment Guide

The Exalytics Deployment Guide is a whitepaper that explains the different types of deployment scenarios that are supported for the Exalytics platform.  It covers the OBIEE, TimesTen and EPM products.  The whitepaper contains the following topics:

  • Performance, Scalability, Sizing
  • Deployment Scenarios
  • Support Installation Types for OBIEE on Exalytics
  • Patching of Software
  • Disk Storage Considerations, including Storage recommendations for OBIEE, TimesTen and Essbase/EPM
  • Backup and Recovery
  • Troubleshooting
  • Installation Steps for OVM, Multi-instances on Bare Metal, OBIEE HA and TimesTen Clustering

The Exalytics Deployment Guide can be downloaded from My Oracle Support – KM article 1568360.1 following this link. then by dowloading the PDF file inside the article. 

Thursday Jul 18, 2013

OBIEE cluster web SSO - ADFS IdP SAMLv2

We posted how to configure OBIEE for SSO using SAML and ADFS , on a single node previously --> there: https://blogs.oracle.com/pa/entry/obiee_web_sso_with_adfs

This post describes  how to perform the same, but with a clustered OBIEE deployment. The main change is regarding the necessary use of aWeblogic RDBMS security store to cache SAML assertions across nodes, as well as the configuration of the load balancer.[Read More]

Tuesday Jun 18, 2013

Importing server and private key in Oracle wallet

You want to create a wallet containing your server cert and private key provided by your PKI administrator as a yourcert.p12 file.

Use keytool and orapki. But make sure your wallet and the private key passwords match.

[Read More]

Tuesday Jun 11, 2013

Highlights of HPCM 11.1.2.3 New Features

The latest release of HPCM provides several new features as well as performance improvements.

V11.1.2.3 provides the following:

  • Standard Profitability – Smart View Integration
  • Detailed Profitability – new calculation rules
  • Detailed Profitability – Essbase Integration
  • Detailed Profitability – Stage Balancing Report
[Read More]

Monday Jun 03, 2013

Highlights of Planning 11.1.2.3 New Features

The latest release of Planning includes several performance improvements as well as some new features not present in earlier releases. Some highlights of the new features include:

  • “Member on the Fly” functionality – For Workforce Planning, Capital Asset Planning, Project Financial Planning and Public Sector Budgeting customers, Planning offers “member on the fly” functionality where end users can dynamically add sparse dimension members and use the added members on a form without performing a Planning refresh. The administrator determines how many new members can be added prior to the next regularly scheduled refresh. Below is an example on how to the “member on the fly’ functionality can be implemented:
[Read More]

Friday May 17, 2013

EPM 11.1.2.2: How-to Setup Essbase Clustering on Unix

The steps on how to setup Essbase clustering on the 11.1.2.2 release has changed as compared to the previous releases.  This document goes through how to setup Essbase clustering on Unix on the EPM 11.1.2.2 release.  The information provided in this document has been taken from the EPM 11.1.2.2 Installation and Configuration Guide, which can be found here @ http://docs.oracle.com/cd/E17236_01/epm.1112/epm_install_1112200.pdf

> Download the Essbase clustering on the 11.1.2.2 release step by step document

 


 

Wednesday Apr 24, 2013

Essbase Aggregate Storage (ASO) - Incremental Outline Updates Triggers a Full or Light Outline Restructure

When performing incremental updates to an Essbase Aggregate Storage (ASO) outline, depending on the nature of the incremental updates, could trigger either a full or light outline restructure.


[Read More]

Thursday Mar 21, 2013

HPCM 11.1.2.2.x - Changing Task Flow Refresh Intervals

In HPCM, users access the “Job Status” task area to view the status of submitted jobs/task flows. In 11.1.2.2.x, the task flow information viewed on these screens within HPCM is cached in order to provide better performance. A refresh occurs after each configured interval and new entries are shown after this interval.

[Read More]

Thursday Mar 14, 2013

Nohup obiee weblogic

To be able to start Weblogic admin server as a process running after the launching shell exits, the boot.properties in weblogic needs to be created. The following commands are the simplest way to achieve this with OBIEE:[Read More]

Friday Mar 08, 2013

Using Essbase Query Governors with Forms Containing User Variables

Many Planning customers today are designing forms containing user variables. User variables allow the user to customize the information presented on a form based on the user’s security. In addition, the number of forms maintained in the application is reduced since multiple versions of the same form having different dimension members do not need to be created.

[Read More]

Friday Jan 25, 2013

Merge Data Slices Before Copying an Aggregate Storage (ASO) Application

Merge Data Slices Before Copying an Aggregate Storage (ASO) Application

When performing an Aggregate Storage (ASO) application copy, it is necessary to merge all data slices first so that all data in the ASO application will be copied properly. The current Essbase documentation does not clearly state a merge of the data is required before running an ASO application copy. An update to the Essbase documentation will be done. However, you can find the documentation update in the current Essbase 11.1.2.2.100 readme documentation. See the current Essbase 11.1.2.2.100 readme documentation under Documentation Updates: http://docs.oracle.com/cd/E17236_01/epm.1112/esb_11122100_readme.pdf

About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today