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.

The Essbase Technical Reference Guide has the supported “best practice” steps to ensure the metadata and data implied share setting are in sync.  See the Essbase Technical Reference Guide:
http://docs.oracle.com/cd/E40248_01/epm.1112/essbase_tech_ref/frameset.htm?impliedshare.html

Supported Steps (per the Essbase Technical Reference Guide) :
The following steps must be performed any time the IMPLIED_SHARE setting is changed in essbase.cfg:
1. Add IMPLIED_SHARE FALSE to essbase.cfg
2. Restart Essbase Server
3. Create a new application and database, with the IMPLIED_SHARE setting in place
4. Rebuild the outline, with the IMPLIED_SHARE setting in place
5. Reload the data
6. Run aggregation or calculation scripts
7. Restart the application.


Unsupported Steps:
If rebuilding the outline is not possible (step #4 in the Essbase Technical Reference Guide) you can disable implied share for the outline using the ESSCMDQ Utility.

1. Download and install ESSCMDQ from the following URL.  Follow installation instructions on the website for correct version and OS of the ESSCMDQ utility:
http://www.oracle.com/technetwork/middleware/bi-foundation/esscmdq-sampleapps-093105.html
2. Follow steps 1 – 3 in the Essbase Technical Reference Guide
3. In EAS, open the existing outline and save the outline to the newly created Application and Database
4. In EAS, unlock outline after closing
5. Start ESSCMDQ Utility to modify outline to accept the Essbase CFG setting

Login <HostNode> <UserId> <Password> enter
Select <AppName> <DbName> enter

Note: You can enter the following commands in one line or hit enter for each prompt command

Openotl 2 1 <AppName> <DbName> <OTLname> y n 0 enter
Writeotl 0 2 1 <AppName> <DbName> <OTLname> enter
enter
Restructotl 1 enter
Exit enter


6. Can use the ESSCMDQ Utility to check that the outline accepted the Essbase CFG setting

Login <HostNode> <UserId> <Password> enter
Select <AppName> <DbName> enter
Openotl 2 1 <AppName> <DbName> <OTLname> n n 0 enter
GetImpliedShareSetting enter

Note:  If IMPLIED_SHARE FALSE setting took effect, should see the following

GetImpliedShareSetting:

Application Name          : Demo2
Database    Name          : Basic

Database Implied Share Setting : 2 (Default - currently OFF)
Cfg-file Implied Share Setting : 2 (Default - currently OFF)


Exit enter

7. Continue following steps 5 – 7 in the Essbase Technical Reference Guide

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
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