Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for May, 2011

Presentation Variable

Posted by Santosh Kumar Gidadmani on May 31, 2011

Presentation variable is the only variable created and used in the presentation services like in dashboard and Answers.

Presentation variables are simple to create unlike dynamic and session variables. You can call presentation variable in different areas for different purpose in Answers title, filter, dashboard prompt etc.

How to create Presentation Variable

Go to dashboard prompt and on the set variable click on presentation variable and provide any name to it.

Note: Set variable option will pop up only when you select either drop-down list or Edit box in the Control option. This will not work if you select multi-select option.

Save the prompt, the presentation variable will be created.

Where to use Presentation Variables

Report Title

Create a report or use the existing report and go to title edit view as shown below.

On the sub title, use your presentation variable as Sales report for @{Country} Country.

@{Country} – This is the simple format to call the presentation variable in different areas. Country is the presentation variable name.

@{variables.<variableName>}{<default>}[format] – This is the complete syntax for using presentation variable.

Example: @{Country}{‘America’}, @{Date}{DATE ‘2011-05-31’}

Save the report and check on the dashboard.

Select the country to filter in the dashboard prompt and click go.

You can see that the presentation variable is changed in the report title to the country we selected on the prompt.

– Santosh

Posted in OBIEE 10g, OBIEE 10g Answers, OBIEE 10g Dashboard, Presentation Variable | 1 Comment »

Gartner’s BI Magic Quadrant

Posted by Santosh Kumar Gidadmani on May 25, 2011

Who is Gartner?

Gartner is an information technology research and advisory company providing technology related insight. Research provided by Gartner is targeted at CIOs and senior IT leaders in industries that include government agencies, high-tech and telecom enterprises, professional services firms, and technology investors.

What is Gartner’s BI Magic Quadrant?

The Magic Quadrant aims to provide a qualitative analysis into a BI market and its direction, maturity and participants, thus possibly enabling a company to be a stronger competitor for that market.

Gartner rates BI vendors upon two criteria: completeness of vision and ability to execute. Using different qualifiers per criteria for the varying industries, the magic quadrant then rates the participants along each of these parameters. These component scores lead to a vendor position in one of four quadrants:

Definition by Gartner:

Leaders: Leaders are vendors that are reasonably strong in the breadth and depth of their BI platform capabilities and can deliver on enterprise wide implementations that support a broad BI strategy. In the magic quadrant, they score higher on both criteria; the ability to execute and completeness of vision.

Challengers: Challengers offer a good breadth of BI platform functionality and are well positioned to succeed in the market. In the magic quadrant, they score higher on the ability to execute and lower on the completeness of vision.

Visionaries: Visionaries are vendors that have a strong vision for delivering a BI platform. In the magic quadrant, they score lower on the ability to execute and higher on the completeness of vision.

Niche players: Niche players are those that do well in a specific segment of the BI platform market such as reporting or that has limited capability to innovate or outperform other vendors in the market. In the magic quadrant, they score lower on both criteria: the ability to execute and completeness of vision.

What are the Evaluation Criteria’s?

Gartner has provided the evaluation criteria in two parts, Ability to Execute and Completeness of Vision.

Ability to Execute

1. Product/Service: How competitive and successful are the goods and services offered by the vendor in this market?

2. Overall Viability: What is the likelihood of the vendor continuing to invest in products and services for its customers?

3. Sales Execution/Pricing: Does the vendor provide cost-effective licensing and maintenance options?

4. Market Responsiveness and Track Record: Can the vendor respond to changes in market direction as customer requirements evolve?

5. Market Execution: Are customers aware of the vendor’s offerings in the market?

6. Customer Experience: How well does the vendor support its customers?

7. Operations: What is the ability of the organization to meet its goals and commitments?

Completeness of Vision

1. Market Understanding: Does the vendor have the ability to understand buyers’ needs, and to translate those needs into products and services?

2. Marketing Strategy: Does the vendor have a clear set of messages that communicate its value and differentiation in the market?

3. Sales Strategy: Does the vendor have the right combination of direct and indirect resources to extend its market reach?

4. Offering (Product) Strategy: Does the vendor’s approach to product development and delivery emphasize differentiation and functionality that map to current and future requirements?

5. Business Model: How sound and logical is the vendor’s underlying business proposition?

6. Vertical/Industry Strategy: How well can the vendor meet the needs of various industries, such as financial services or the retail industry?

7. Innovation: How well does the vendor direct related, complementary and synergistic layouts of resources, expertise or capital for investment, consolidation, defensive or pre-emptive purposes?

8. Geographic Strategy: How well can the vendor meet the needs of locations outside its native country, either directly or through partners?

Gartner’s Magic Quadrant 2010 Analysis Chart

Gartner’s Magic Quadrant 2011 Analysis Chart

Gartner’s view is that the market for BI platforms will remain one of the fastest growing software markets despite sluggish economic growth in most regions.


– Santosh

Posted in Gartner BI Survey, OBIEE 10g | Leave a Comment »

Customize OBIEE Logon Image

Posted by Santosh Kumar Gidadmani on May 7, 2011

Sometimes it is important to provide a personalized logon image and customized text details for the customer. Let us see the configuration details to customize the login image. I will be using my blog logo for this demonstration.

1. Upload the logo image and change the logon image path under Oraclebi directory subfolders.
2. Change settings in Instanceconfig.xml file
3. Restart the services.

Upload the logo image and change the logon image path under Oraclebi directory subfolders.

1. All the skin images are stored in the Oraclebi\web\app\res\sk_oracle10 folder. This folder comes with all default settings.
2. Duplicate sk_oracle10 folder and rename anything, I have renamed it as sk_obiworldlogo.
3. The folder name should contain sk_ as the prefix name.

4. Open the sk_obiworldlogo folder. Place the logo image under b_mozilla_4 folder and change the image name path in the logon.css file which is available in this folder.

Provide the name of the image in the background-image path. Save the file.

5. Follow 1 to 4 steps as above and do the similar changes in the directory:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\sk_obiworldlogo.

So the logo image and logon.css file changes have to be made in two directories.

Change settings in Instanceconfig.xml file

1. Add the default style code as below and mention the folder name in the instanceconfig.xml file. Default style code is for the login screen image and default skin code is for skin within the Answers tool. Ensure the name is case sensitive and do not include sk_ as prefix.

Restart the services.
1. Re-start the BI server and presentation server services. You will see your customized login image as below.

2. You can customize the logon screen as per the company requirements. The content text of this login screen can be changed as well and we will see some examples in the later posts in this blog.

– Santosh

Posted in Customize OBIEE Logon Image, OBIEE 10g, OBIEE 10g Answers | 3 Comments »

%d bloggers like this: