1Z0-146 Dumps: Oracle Database 11g: Advanced PL/SQL

Dear All,

In this post, we are posting the set of questions, asked in the 1z0-146 exam.

Step by Step: How to Start OBIEE 11G services?

Dear All,

In this post, we are stating step by step procedure to start OBIEE 11G Services.

Please follow the order as instructed:

Oracle BI 11G Design Best Practices: Oracle BI Principles

The purpose of the article is to document best practices to be used in Oracle BI. The article covers:
• Oracle BI Principles
• Repository design best practices
• Dashboards and reports design best practices
• 10g Upgrade considerations

In this very post, we are explaining main principles of Oracle BI. In the subsequent post, we will cover the other respective articles.

OBIEE 11g: How to Display the Export link Above a Analysis/Report

By default, the report links (such as Refresh, Print, Export etc.) are displayed below the results at the bottom of the page when an analysis is embedded in a dashboard.

How can you add an Export link be displayed above the analysis at the top of the page?

You can add the Export link above the analysis in the dashboard by embedding HTML code in a text object in the dashboard.

OBIEE 11g: How To Display the Appropriate Dashboard Page for each User, Dependent on their Application Role(s)?

When a user logs in to OBIEE, how can you set it up, so that the Dashboard the user sees is dependent on their application role(s)?

This can be setup using system session variable ROLES and PORATLPATH.

How to refresh GUIDs for OBIEE 11g ?

APPLIES TO:
Oracle Business Intelligence Enterprise Edition

PURPOSE
The purpose of this document is to provide clear steps for refreshing GUIDs in OBIEE 11g. The document also shows what to expect in the logs to confirm GUID refresh has completed successfully.

Location of Configuration files in OBIEE 11G

Configuration Files
Source: Oracle® Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition > Where are Configuration Files Located?

New Features in the Oracle Business Intelligence Suite Bundle Patch 11.1.1.7.1

New Features in the Oracle Business Intelligence Suite Bundle Patch 11.1.1.7.1

• Enforce Limits Per Logical SQL Query
• Support for TimesTen Parallel Insert

OBIEE 11g: How To Display The Difference Between Two TimeStamp Dates As HH:MM:SS?

You have cases where end users need to display the difference between two time stamp date columns in the format HH:MM:SS.
End-users may find it complex to use the TimeStampDiff function to get the desired output.

TimeStampDiff is the out of the box function that returns the total number of specified intervals between two timestamps.

To display the difference between two time stamp date columns in the format HH:MM:SS, use the following syntax:

How to display OBIEE content in iFrame?

On : 11.1.1.5 [1900] version, Analytics

When attempting to embed an Analytics Dashboard into a Siebel View the following error occurs:-

"OBIEE content can not be displayed in the iframe"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform a Siebel CRM 8.1.1.3 Integration with OBIEE 11.1.1.5
2. Add an OBIEE Dashboard to the Siebel View
3. Navigate to the Siebel View/Screen and error is displayed
The issue was resolved by performing the following steps:-

How To Clear / Purge The OBIEE 11g Repository Cache Via An Automated Scripted Command-line?

This document describes a method to clear the OBIEE 11g repository cache via an automated command-line script.

This examples shows how to purge all the cache entries on Linux/Unix , for other options see the documentation. For Windows, modify the paths and use .bat files.

How to enable or disable the cache in OBIEE 11g?

FOR TURNING OFF SERVER CACHE IN OBIEE 11G
The following configuration setting of NQSConfig.INI file, is managed by Oracle Business Intelligence Enterprise Manager.

[Cache]
ENABLE = YES

If you change this entry directly in NQSConfig.INI file then it will revert to the original value whenever you restart the BI server.
The possible solution is given below:

How to Remove Recent and Most Popular dashboard links on the OBIEE home page?

In one of our application, we faced an issue raised by the users.

The OBIEE home page, shows the most recent and the most popular dashboards/reports. The users wanted to remove that part. After many hit and trial, we got the workaround from the Oracle.

[nQSError: 43113] EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE

EVALUATE_SUPPORT_LEVEL is missing in NQSConfig.INI

In one of our application in real time project, we faced the below error in our reports:
"OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE"

We had upgraded our OBIEE version from 11.1.1.5 to 11.1.1.7. But in all the reports, where we had used evaluate function, we were facing the error.

OLAP Operations

OLAP Operations

Slice
Dice
Roll Up
Drill Down
Pivot

OLTP Vs. OLAP Databases

Most businesses use Online Transaction Processing (OLTP) databases to gather and store the records generated by their daily operations. Typically, OLTP databases execute transactions, meaning that they add, update, or delete groups of records at the same time.

 For example, the database for a grocery store inserts and updates information about prices, purchases, and costs of goods and freight, usually at lightning speed.

Database Type Setting in OBIEE 11G RPD

Dear All,


When we design the RPD, we always focus on implementing the business concepts but we forget to work on  the basic repository features.

One of the cases, is the  Database Setting.

The database type has not been correctly defined in the database object in the physical layer.

OBIEE 11G: Perfomance Tuning

Dear All,

Most of us, who is/are familiar with the Business Intelligence Reporting Tools , may be familiar with Oracle Business Intelligence Enterprise Edition (OBIEE) 11g version. OBIEE 11G is widely used in industry as the reporting tool. OBIEE 11g provides many new features compared to its previous versions.

But the important factor, when we develop the logic and build the analysis is to keep tracking of its performance. Building the report is not the big task, but to build good performing dashboards is the ultimate need of this dynamic industry. A well timed reports could help the users to take the decisions in time.

Please find below some of the steps which can comparatively reduce the execution timing, hence improving the dashboard performance.

• Turn off query logging in OBIEE
• PERF_PREFER_MINIMAL_WITH_USAGE Database Feature
• Setting number of elements for hierarchies in RPD
• Timeout and Max Connection Settings for Connection Pooling
• Foreign key joins by varchar fields to be replaced by surrogate keys
• Using aggregate tables for performance improvement
• Redundant views to be removed from reports
• Pivot Table vs. Table View

All Oracle Certification Dumps

Hi All,

We all know the importance of the certification in our professional career and to get it certified is an honor in itself and very helpful for the growth perspective.

Please find below the list of dumps: