Essbase MaxL Command To Add Databases To Groups


Use MaxL command “Grant” to add databases to a group.

Below is the information from the Technical Reference online documentation.

http://download.oracle.com/docs/cd/E10530_01/doc/epm.931/html_esb_techref/techref.htm

Grant a permission, a filter or a stored calculation to a user or a group.

Granting permissions:

At each level (system, application or database) existing roles are replaced. However, the built-in privileges create_user and create_application are not replaced.

After granting a permission to a user or group, it can be revoked by subsequently granting no_access. However, to prevent users from being able to load the application, you should also grant no_access at the application level.

Granting filters:

There may be only one filter per user per database. Therefore, granting a filter replaces any filters the user may already have on that database.

After granting permissions using a filter, the filter permission can be revoked by subsequently granting no_access to the database. However, to prevent users from being able to load the application, you should also grant no_access at the application level.

Granting calculations:

A user or group may have any number of calculations per database. Therefore, granting a calculation adds it to the user or group’s list of calculations. Grant execute any gives the user or group permission to execute all calculations, including the default calculation.

After granting execute permission, the permission can be revoked by subsequently granting no_access to the database. However, to prevent users from being able to load the application, you should also grant no_access at the application level.

grant no_access to NewGroup;
grant administrator to TestUser;
grant manager on application Sample to TestUser;
grant read on database Sample.basic to TestUser;
grant filter Sample.basic.filter8 to TestUser;
Advertisements

How To Substitute Essbase Alias “Product – Default” in OBIEE Repository


In order to use Essbase Aliases on BIEE Answer, make sure that 2 setting is configured appropriately in the repository.

1.The length of “Physical Cube – Product – Default” should be appropriate (ex. VARCHAR 128).

1-1. Launch BI Administration Tool, and navigate Tools > Query Repository

1-2. Search the “Type: Physical Cube Column” for “Product – Default.”

Obiee-essbase1

1-3. Change the Length from 0 to appropriate value such as 128.

Obiee-essbase2

1-4. Press OK.

2.Product dimension should have Aliases created on the physical layer.

2-1. Right Click on Product Dimension, Create Columns for Alias Table.

Obiee-essbase3

2-2. Select an alias for “Default”

Obiee-essbase4

The above procedure will work for substituting “Product – Long Names”, “Product – Member_Name” , or other Essbase members.

Thanks,

~KKT~

How To Use the Essbase Cluster Name as a Location for Business Rules


How can we run a Business Rule against an Essbase location using the Essbase cluster name (“EssbaseCluster-1” by default) rather than the name of a particular Essbase server? This does not work in the EAS console or from the command line.

When using the CmdLnLauncher.bat utility to launch a rule from the command line we receive an error:

Launch Vars: {ExecDB=Essbase/EssbaseCluster-1/COREFY13/HypImmo}
com.hyperion.hbr.excp.ExceptionAdapter: Error generating calc script: 01_BR_KM_CalcFXRate_Budget_4
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.hyperion.hbr.common.Util.getExcpAdapter(Unknown Source)
at com.hyperion.hbr.core.LanguageManagerServerRemote.generateExecutable(Unknown Source)
at com.hyperion.hbr.api.LanguageManagerClient.generateExecutable(Unknown Source)
at com.hyperion.hbr.cmdlnlauncher.LaunchManager.launchRule(Unknown Source)
at com.hyperion.hbr.cmdlnlauncher.CmdLineLauncher.main(Unknown Source)
Detail:Error connecting to Essbase server EssbaseCluster-1.

Detail:Exception occurred. Please check your log file for details.

Error generating calc script: 01_BR_KM_CalcFXRate_Budget_4
2012-02-16 17:56:33,506 WARN main com.hyperion.hbr.cmdlnlauncher.CmdLineLauncher – Error generating calc script: 01_BR_KM_CalcFXRate_Budget_4

The “EssbaseCluster-1” cluster name is not being resolved correctly. How can this be addressed?

To use the cluster name (rather than an individual Essbase server name) as a location when launching Business Rules from the EAS console or the CmdLnLauncher, you first need to create an essbase.properties file (or edit it if it already exists) so that the “EssbaseCluster-1” name can be resolved successfully.

  1. Create a new text file called “essbase.properties” on the EAS server in the following location:
    \Oracle\Middleware\EPMSystem11R1\products\Essbase\eas\server\bin

    (If the file already exists, edit it)

  2. Add the following line in this file:
    aps.resolver.urls=http://vm0dacarter61:13080/aps

    (Replace “vm0dacarter61” with the name of the server where Hyperion Provider Services is running. If you are using a non-standard port amend as appropriate)

  3. Restart the EAS service
  4. Ensure that the Hyperion Provider Services service is running. Since the essbase.properties file directs EAS to contact Provider Services to resolve the cluster name, Provider Services must be running for this to work.

This solution is also documented in the 11.1.2.1 Business Rules readme: http://docs.oracle.com/cd/E17236_01/epm.1112/hbr_1112100_readme.pdf

Thanks,

~KKT~

FDM claissic time to say ‘GoodBye’


Dears,

I was personally very strong fan of FDM and doing stuff with VB was real magic with all sorts of mapping etc.

Bu now FDMEE is the future and we have to move ahead with Jython .

FDM classic will be supported till 11.1.2.3.500 and after also patch .700.  After that version there will no longer be further bug fixes.

So Starting from 11.1.2.4 you can have only FDMEE where a migration from FDM to FDMEE would be required.

Thanks,

~KKT~

FDMEE Open Interface Adapter – Updating ODi Project


Looking for a run down of how to update the Open Inteface project in order to add custom interfaces to load the AIF_OPEN_INTERFACE table.

All documentation says to:
– copy the ODI project and rename
– update the link in FDMEE for project code

All of the variables in the copied project fail since they still reference the original project. Is there instructions on how to successfully update the copied project?

Before following these steps, perform a backup of your existing work repository. Also backup your custom project
and model.
1) Create a new work repository with a new ID, say 900. This will be your development repository where you will perform
all customizations. If you already maintain a separate repository for customization, skip to step 4.
2) Export (Open Interface) Model and Project from FDMEE repository.
3) Import above Model into your dev repository (ID=900) in INSERT mode, followed by import of your Project.
4) Renumber your dev repository from 900 (or existing ID) to say 901 (topology -> repository -> right click to see
option). This is needed to have all objects tagged by ID 901. This will be your final dev repository ID where you
will perform customization work.
5) Export Model and Project from dev repository 901 as and when needed e.g. certain customization work is complete.
6) Import Model and then Project in INSERT mode to your target repository e.g. FDMEE repository where you want
customization to run.

Please perform any further customization on your dev repository (ID=901) and export to target/FDMEE repository as mentioned above.

Thanks,

~KKT~

SampleAppLite RPD And Catalog File For OBIEE 12c


When configuring OBIEE using /config.sh (cmd for Windows), there is an option on the “Initial Application” screen to select the following option:

Oracle sample application (SampleAppLite)

This will install the SampleAppLite files – SampleAppLite.bar and SampleAppLite-datafiles.zip
After the install is complete, SampleAppLite.bar and  SampleAppLite-datafiles.zip can be found in:

ORACLE_HOME/bi/bifoundation/samples/sampleapplite

For more information on SampleAppLite.bar, please refer to:
Oracle® Fusion Middleware System Administrator’s Guide for Oracle Business Intelligence Enterprise Edition

https://docs.oracle.com/middleware/1221/biee/BIESG/configrepos.htm#BIESG9296

Chapter 9 Managing Metadata and Working with Service Instances

Thanks,

~KKT~

What Is The Difference Between Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA ) And OBEE Standard Edition One (OBIEE-SE1)


Where Can I Find Out More Information About Oracle’s Business Intelligence Foundation Products?

Please see the Oracle Business Intelligence Foundation page on the Oracle Technology Network at:

http://www.oracle.com/technetwork/middleware/bi-foundation/overview/index.html

What is Oracle Business Intelligence Enterprise Edition ?

Oracle Business Intelligence Suite Enterprise Edition (OBIEE) is a comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities. Featuring a unified, highly scalable, modern architecture, Oracle BI EE Plus provides intelligence and analytics from data spanning enterprise sources and applications empowering the largest communities with complete and relevant insight.

Oracle BI EE Plus also bundles key Oracle Hyperion reporting products for integrated reporting with Oracle Hyperion financial applications. (see OBIEE plus.)

Oracle Business Intelligence System includes:

  • Comprehensive BI functionality built on a unified infrastructure includes interactive dashboards, full ad hoc queries and analysis, proactive intelligence delivery and alerts, enterprise and financial reporting, online analytical processing (OLAP) analysis and presentation, high-volume production reporting, real-time predictive intelligence, disconnected analytics, as well as integration with Microsoft Office.
  • Pervasive insight to everyone, everywhere provides relevant insight to everyone, not just analysts. All levels of the organization can see information optimized for their role.
  • Unified business model built on an enterprise information model that unifies metadata across the Oracle BI tools and analytical applications for the lowest TCO.
  • Hot-Pluggable BI infrastructure integrates with any data source, extraction, transformation and load (ETL) tool, major business application, application server, security infrastructure, portal technology, other front-end and analytical tools, and databases including IBM DB/2, Teradata, Microsoft SQL Server; SAP Business Information Warehouse (BW), Microsoft Analysis Services; flat files; XML data; and unstructured data.

The components of OBIEE include:

  • Oracle BI Answers: Ad-hoc query and reporting
  • Oracle BI Interactive Dashboards: Highly interactive dashboards for accessing business intelligence and applications content
  • Oracle BI Delivers: Proactive business activity monitoring and alerting
  • Oracle BI Disconnected Analytics: Full analytical functionality for the mobile professionals
  • Oracle BI Briefing Books: Snapshots of dashboard pages to view and share in offline mode
  • Oracle BI Administrator

 

What is Oracle Business Intelligence Enterprise Edition Plus?

The Oracle Business Intelligence Suite Enterprise Edition Plus (EE) is a comprehensive suite of enterprise BI products, delivering the full range of BI capabilities including interactive dashboards, full ad hoc, proactive intelligence and alerts, enterprise and financial reporting, real-time predictive intelligence, disconnected analytics, and more. In addition to providing the full gamut of BI functionality, the Oracle Business Intelligence Suite EE Plus platform is based on a proven, modern Web Services-Oriented Architecture that delivers true next-generation BI capabilities.

Oracle Business Intelligence Enterprise Edition Plus has the following components:

  • Oracle BI Answers: Ad-hoc query and reporting
  • Oracle BI Interactive Dashboards: Highly interactive dashboards for accessing business intelligence and applications content
  • Oracle BI Delivers: Proactive business activity monitoring and alerting
  • Oracle BI Disconnected Analytics: Full analytical functionality for the mobile professionals
  • Oracle BI Publisher (formely known as XML Publisher): Enterprise reporting and distribution of “pixel-perfect” reports
  • Oracle BI Briefing Books: Snapshots of dashboard pages to view and share in offline mode
  • Hyperion Interactive Reporting: Intuitive and highly interactive ad-hoc reporting
  • Hyperion SQR Production Reporting: High volume, presentation-quality formatted report generation
  • Hyperion Financial Reporting: Formatted, book-quality financial and management reporting
  • Hyperion Web Analysis: Web-based online analytical processing (OLAP) analysis, presentation, and reporting

What are Oracle Business Intelligence Applications?

Oracle Business Intelligence  Applications (OBIA) are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence for everyone in an organization from front line employees to senior management that enable better decisions, actions, and business processes. Designed for heterogeneous environments, these solutions enable organizations to gain insight from a range of data sources and applications including Siebel, Oracle E-Business Suite, PeopleSoft, and third party systems such as SAP.

Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive, innovative, and leading BI platform. This enables organizations to realize the value of a packaged BI Application, such as rapid deployment, lower TCO, and built-in best practices, while also being able to very easily extend those solutions to meet their specific needs, or build completely custom BI applications, all on one common BI architecture.

Oracle BI Applications (OBI Apps) consist of the following (at the time of this publication):

  • Oracle Financial Analytics
  • Oracle HR Analytics
  • Oracle Marketing Analytics
  • Oracle Order Management Fulfillment Analytics
  • Oracle Vertical (Industry Specific) Analytics
  • Oracle Sales Analytics
  • Oracle Service Analytics
  • Oracle Contact Center Analytics
  • Oracle Supply Chain Analytics

The following is what is delivered on eDelivery/OTN for OBIA:

 

  • Web Catalog
  • RPD
  • Informatica (3rd party software),
    • Informatica repository,
    • data Warehouse Application Console (DAC) repository,
    • warehouse database schema.
      (Note that Informatica is only available through eDelivery).

 

 

What is Oracle Business Intelligence Standard Edition One?
http://www.oracle.com/technetwork/middleware/standard-edition-one-095406.html

Oracle Business Intelligence Standard Edition One is a complete, integrated and attractively priced BI solution in a box for the small to medium sized business. It was based on the exact same technology platform as Oracle Business Intelligence Enterprise Edition, making it simple to scale as your business needs grow. Oracle Business Intelligence Suite Standard Edition One features the basic components to manage and build your departmental BI solution. Oracle BI Standard Edition One provided comprehensive business intelligence functionality, interactive dashboards; highly formatted reports, self-service ad hoc analysis, data integration, and server administration all delivered on one common, modern Web architecture. Oracle BI Standard Edition One was compatible with Oracle Business Intelligence Suite Enterprise Edition, protecting your investment as your usage requirements grow.

Oracle Business Intelligence Standard Edition One included:

  • Oracle BI Server
  • Oracle BI Server Administrator
  • Oracle BI Answers
  • Oracle BI Interactive Dashboards
  • Oracle BI Publisher
  • Oracle Database Standard Edition One
  • Oracle Warehouse Builder (core ETL)

Question: Can Oracle Business Intelligence Standard Edition One (OBISE1) components be upgraded?

Yes, for 10g-to-10g, please see, Note 743916.1 ‘Upgrading Oracle Business Intelligence Standard Edition One (OBISE One) to higher versions of the underlying components’

Where can I download products based on Oracle Business Intelligence Enterprise Edition?

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html

Hyperion Planning Error “Unable To Obtain A Connection To Hyperion Essbase”


The following error during logon to Hyperion Planning application:

Unable to obtain a connection to Hyperion Essbase from planning.

Try one of the following solutions to resolve this issue:

  1. Login to EAS administration console as admin
  2. Drill down the Essbase node to the application in question
  3. Right click on the application -> Stop
  4. Right click on the application -> Start

If login still fails with the same error then:

  1. Stop the Essbase server
  2. Start the Windows task manager and stop any (ghost) ESSVR processes.
  3. Start the Essbase service
  4. Login to EAS administration console and start the application
  5. Login to the Hyperion Planning application

You may edit the Essbase.cfg file and increase or add the following parameters if issue persists:

  • NETDELAY
  • NETRETRYCOUNT

Hyperion Planning System Audit information


As an EPM System Administrator, what are the monitoring options in the Planning System?

From the Weblogic Server Administrators point of view, there is a built in Oracle Entreprise Manager 11g Fusion Middleware Control deployed with your install if Weblogic is used.
From the windows start machine (on the deployment server) -> All Programs -> Oracle Weblogic -> User Projects -> EPMSystem and run the ‘Start Admin Server for Weblogic Server’
One it is loaded, login to the following url http://Servername:7001/em
You can use this tool to check the load on each deployment and setup your alerts. See the OEM documentation for further details (you can use the Enterprise Manager help for details).

 

From the Database Administrators point of view they can monitor using the database tools.

Use the tracing tools available at database level as all activities are stored in the database.

From the Planning Adminstrators point of view the auditing can be enabled for Planning users.

1. Login to the Planning application that you would like to enable auditing for, as an Administrator
2. Select Administration -> Reporting
3. Select Auditing Tab
4. Select the component(s) you want auditing

The following options are available for auditing

Dimension Administration
Alias Table Administration
Data
Launch Business Rules
Data Form Definition
Data Form Folder Administration
Workflow
Copy Version
Security
Users Administration
Groups Administration
Offline
Task List
Copy Data
Clear Cell Details

5. Select Save Selections
6. Restart Planning Web Service to activate changes
7. In the Planning Application RDBMs the HSP_AUDIT_RECORDS is where the audit records will be written to.

NOTE: From 11.1.2.3 onwards, the Auditing option in Planning is moved to this location:
Tools -> Reports -> Auditing Tab