Monthly Archives: November 2013

OBIEE 11g End of Movember Blogs and News

indexOBIEE News is out!

OBIEE News is out.  Edition of 25th November

rssBlogs of the week

1. Direct Links to various OBIEE User and Administration Presentation functions

This post by Praveen Reddy lists some direct links to various OBIEE User and Administration functions.  These can be useful to know for efficiency and at times can also be useful for debugging security.

2. How to conditionally set Interaction (Action Links) on a column in OBIEE 11g

This post by Norm Bowen shows an example of how to conditionally set Interaction (Action Links) on a column.

3. OBI 11g Installation Questions

This post by Everything Oracle covers questions such as;

– Will OBIEE 11g work on Windows XP?

– Can I run OBI 11g with IE 6?

–  I’ve installed a loopback adaptor and modified the hosts file according to the installation instructions but I can’t login to Answers?

– I am trying to install OBI 11g and I can’t get beyond the Admin screen?

Read the whole set of Installation questions here.

4. Big Data Appliance X4-2 Release Announcement

This post by Jean-Pierre Dijcks covers Software Focus, Hardware Update and Software Details about the 3rd generation Big Data Appliance.

The focus for this release is:

  • Comprehensive and Open – Big Data Appliance now includes all Cloudera Software, including Back-up and Disaster Recovery (BDR), Search, Impala, Navigator as well as the previously included components (like CDH, HBase and Cloudera Manager) and Oracle NoSQL Database (CE or EE).
  • Lower TCO then DIY Hadoop Systems
  • Simplified Operations while providing an open platform for the organization
  • Comprehensive security including the new Audit Vault and Database Firewall software, Apache Sentry and Kerberos configured out-of-the-box

5. Setting Up and Running Summary Advisor on an Exalytics Machine (Oracle-by-Example)

This post says “If you are running Oracle BI on an Exalytics machine, you can use Summary Advisor to identify the aggregates that will increase query performance.” The post links to the Oracle Learning Library where a tutorial will explain further.

6. OBIEE 11g: A Hands-On Tutorial

This blog by Wilson Intelligent Solutions reviews Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial. They say, “569 pages of real world, practical examples across the OBI product suite. They include loads of real world scenarios, tips and tricks to encourage best practices in the enterprise.”

7. Performance Testing/Tuning OBIEE

In this post, Paul McGarrick shares some of the interesting reads he has come across.  This includes a post from Jeff McQuigg, a presentation from Peak Indicators and an Oracle White Paper.on My Oracle Support

8. Oracle Endeca Information Discovery Studio – The Metrics Bar Component

In this article, Andrew Fagence explains how to create and configure a Metrics bar within the Oracle Endeca Studio application, the software he is using in this walkthrough consists of:

  • Oracle Endeca Information Discovery 2.4.0 (Installed on his local machine running Windows 7 64-bit, typical install with standard configuration and ‘Quick Start’ package installed).
  • Mozilla Firefox (The official supported browsers are Internet Explorer 7/8 and Firefox 3.5+. Google Chrome and Opera Safari are not supported but you will probably find they work fine).

View the post here.

linkedin logoThis week on LinkedIn

Ujjal Das shared a Free White Paper: Private Clouds for Oracle Databases

Kashinathan K posted a link to Zookeeper (Apache Hadoop project) from the Datawarehouse concepts blog

Monica Hasebi shared a link to Webinar Recording on Streaming Analytics

Stephen Bowden posted Data Visualization Webinar Recording

Join in the Oracle Business Intelligence discussions here.

twitter logoThis week on Twitter

Fusion Applications tweeted a link to Achieving Procurement Excellence through Oracle Fusion

 

 

 

Oracle Blogs posted New ADF Mobile Application User Interface Design Guidelines

Chris C Muir shared ADF Debugging Aid: The ADF Request Analyzer

Follow me on Twitter for daily OBIEE news and updates

OBIEE 11g, Hadoop and facebook in the News

indexOBIEE News is out!

OBIEE News is out! Edition of 18th November

rssBlogs and interesting articles of the Week

1. Presto: Interacting with petabytes of data at Facebook

In this post, Martin Traverso discusses Background, Architecture, RoadMap, OpenSource and Current Status in Presto: Interacting with petabytes of data at Facebook (A note by Facebook Engineering).

2. In-memory Computing Architecture with Hadoop

In this 2 part post, they first list down 15 IMC companies and their Hadoop connection tactics.

In the second part of the post, they look at another set of 15 IMC offering companies.

3. Creating a Multi-Node Hadoop/Impala Cluster as a Datasource for OBIEE 11.1.1.7

In this blog post by Mark Rittman, he states to set up our own Hadoop cluster, there are a few options:

1. Get hold of a bunch of physical servers (maybe, old PCs or blade servers), install Linux and Hadoop on them, and then do the configuration and setup manually.
2. Buy a preconfigured solution – Oracle’s Big Data Appliance, for example, which has all the software pre-installed along with connectivity to ODI, Oracle Database etc
3. Spin-up a bunch of servers in the Cloud, or
4. Spin-up a bunch of Linux VMs, for example using VirtualBox or VMWare Fusion/Workstation

He explores this further in the post which can be read here.

4. Why ODI, DW and OBIEE Developers Should Be Interested in Hadoop

In another post by Mark Rittman, he claims the reason we should be interested in Hadoop is because “Hadoop is the classic disruptive technology – cheap, and starting-off with far less functionality than regular, relational databases – but it’s improving fast, and as BI&DW developers it offers the potential of both massive benefits – significantly lower TCO for basic DW work, and support for lots of modern, internet-scale use-cases – and threats – in that if we don’t understand it and see how it can benefit our customers and end-users, we risk being left-behind as technology moves on.”

Read the thought-provoking article here.

5. Apache Hive & Hive Query Language

This post from DataWarehouse Concepts explores Apache Hive and Hive QL

6. Install and Configure Oracle HTTP Server (OHS) with OBIEE 11g

In this blog, Tarik Bouaziz discusses circumstances that require installing OHS with OBIEE such as:

1- OBIEE Performance Tuning

2- When deploying OBIEE 11g content outside an organization (firewall): this requires placing Oracle HTTP Server (OHS) into the DMZ side firewall (opening port 7777 for non SSL, port 4443 for SSL) and then redirecting calls to OBIEE installed inside the firewall/LAN using a secured port such as 9704

3- OBIEE URL Rewriting (configuring OBIEE 11g to use port 80): A detailed document will be posted in the near future on this topic.

This blog highlights the steps to install and configure OHS with OBIEE11g.

7. How to secure an Enterprise OBIEE 11g environment: the Oracle HTTP Server

This blog post discusses security issues surrounding the new player – Mobile BI – and how to address this, the conclusion being, “Mobile BI will significantly expand the population of BI users and the decision makers from your company will want to use mobile devices to access corporate BI data from any place. Now you need to ensure that the current BI environment supports these demands without forgetting terms such as performance and security, an Oracle HTTP Server Web Tier installed within the DMZ firewall will help you to achieve the best results.”

8. A Deep Dive Into OBIEE 11g Security

This pdf document by Ramke Ramakrishnan covers:

1. Introduction

2. OBIEE Security Controls

3. Authentication

4. Authorization

5. Content Security

6. User GUIDs

7. Multiple Authentication Providers

8. Row Level Security

9. Security Store Migration

10. Single Sign-On

9. OBIEE 11g Upgrade – Lessons Learned – Expect the Unexpected

This pdf document by Robert Rolek details lessons learnt in:

  • Project Management
  • Security
  • Code Conversion
  • Bugs
  • Mobile Support
  • Non OBIEE Technical Issues

10. How to find Oracle Integrated Lights Out Manager (ILOM) ip Address on Exalytics

Sunil S Ranka says, “Recently while upgrading the Exalytics box from PS1 to PS3 for OBIEE 11.1.1.7 patch-set, one of the requirements was to upgrade firmware and to complete the firmware we needed ILOM address. During the upgrade, the team found out the default ILOM IP was not working and there was a change in the ILOM ip address. To confirm the ip address, we used below command, thanks to Oracle Support to prompt reply . Thought would be a good piece of information as most of the existing Exalytics customers are going through the upgrade.”

11. Customizing Heap Size in a Weblogic domain

This blog explores two scenarios when we require to modify the heap size according to our applications’s needs eg java.lang.OutOfMemoryError

Read this helpful post here.

linkedin logoThis week on LinkedIn

Rajneesh Kumar posted a link to “An Introduction to Goldengate”

Ujjal Das shared IT Strategy Guide: Journey to the Cloud

Sandeep Venu posted a link to Get User Session Details in OBIEE 11G

Aravind Sai Ram posted,  “Hello Friends, I am looking for a solution to perform Load Test on OBIEE Dashboards / Reports (Version 10) using any script or free load test tools / applications .
Scenario is :
> Login to OBIEE
> Apply load by ramping up the users on a specific dashboard / report
> Record the performance counters such as ‘Time taken for a report to retrieve the results’
and counters like Memory utilization, Load capability of BI Server
Can someone please help me in achieving this ?

Help him out here

Kashinathan K shared Types of Dimensions

Join in the Oracle Business Intelligence discussions here.

twitter logoThis week on Twitter

Oracle Analytics shared Becoming a Better Listener…For Your Consumer

Oracle Blogs posted Extracting PSFT Chartfield Hierarchy Data in OBIA 11.1.1.7.1

Andrejus Baranovskis tweeted a link to his blog post Creating ADF BC View Object Instances On The Fly

Follow Addidici on Twitter for daily updates and OBIEE News

This week’s favourite blog posts.

indexOBIEE News is out!

OBIEE News is out! Edition of 11th November

rssBlogs of the Week

1. Formatting a Field Globally in OBIEE 11g

In this blog post by M & S Consulting, there are detailed instructions and screenshots of how to format a field globally in 11g. They say, “Having to format the field each time that a user wants to use it becomes quite burdensome and gives a developer more room for error if they are formatting the field each time it is used. The saying “work smarter, not harder” comes to mind with this solution.”

2. OBIEE 11g – Enable Log-Level from Advanced Tab

Kishore Uppalapti tells us exactly how to Enable Log Level from the Advance Tab. A very short and to the point instructional blog.

3. Monitoring OBIEE Performance for the End User with JMeter from EM12c

Robin Moffat in his third article in his two-article set of posts on extending the monitoring of OBIEE within EM12c. It comes after a brief interlude discussing Metric Extensions as an alternative using Service Tests to look at Usage Tracking data.

He talks us through

  • The JMeter test script
  • Running JMeter from the command line
  • Making the script available to run on EM12c server
  • Building the JMeter EM12c Service Test
  • Measuring response times from additional locations

Read the whole blog post here

4. OBIEE Architect Developer vacancy at Staff I.T., Inc in Detroit

This blog displays a vacancy for a qualified OBIEE Architect / Developer. In this role you will be responsible for building out the OBIEE infrastructure. You will be required to design and implement new reporting meta data repositories and will also be instrumental in developing reports against those meta data repositories. See the blog post for full details.

5. How to check version of OBIEE 10g and 11g

This is a short blog showing just how to check the version of 10g and 11g that you are using.

6. Integrating OBIEE 11g into Weblogic’s SAML SSO

In this blog by Srinivasan Software Solutions Pvt Ltd, SAML is described as a way of conveying identity information across systems. The writer describes a scenario where a situation required OBIEE 11g integration into SAML 2.0 SSO.

The post examines what can be done (and how) if this occurs.

7. Custom style and skin in OBIEE 11.1.1.7

This blog advises that when upgrading existing customized installations of OBIEE to 11.1.1.7, one thing that you may run into is a subtle change in the usage of the vanilla style and skin of the application.

The blog post explores this further.

8. Development Costs and Technical Confidence…

Dr OBI says, “For the manager, it’s important to understand the RELATIVE impact of software development challenges, when you’re delivering solutions driven by software. Why the problem is easy or why it is hard, has a profound impact on programme planning and budgets. This can greatly increase cost for enterprise programmes, increasing the cash burn rate…”

Read the full blog for some useful advice.

9. Populating OBIEE Event Polling Table via Trigger

Paul McGarrick states “When using Oracle BI Applications there is often the need to invalidate OBIEE’s query cache once new data has been loaded into the Data Warehouse to prevent users from seeing stale data in the reports. Perhaps the simplest and most elegant method to do this is to make use of the standard Event Polling Table mechanism.”

He then goes on to say there are three ways to do this:

1. Editing each Informatica Workflow to include post-ETL SQL insert statements
2. Configuration of new tasks within the DAC to handle inserts
3. Triggers in the database (Oracle only) to automate the inserts

He focuses on Method 3 in this blog. Read the blog here.

10. Display a list of dashboards based on permissions?

In this OBIEE Developer Blog, The question “Is there a way to display a list of dashboards based on permissions?” is answered. The writer gives credit to MTache who posted the Java Script on the OTN Forums.

linkedin logoThis week on LinkedIn

Anshu Monga posted Build Your Career with Oracle WebLogic: #1 in the Application Server Market Segment for 2012

Kris Poria shared Oracle Democratizes Data Discovery with Oracle Endeca Information Discovery 3.1

Ritesh Bhagwat said “I’m in process of a developing LOV tables for improving Prompt Performance. If you have anything related please share.” Help him out here!

Richard Rankin posted Oracle R Enterprise: Programming and Integration

Join the LinkedIn group here.

twitter logoThis week on Twitter

OAUG shared OAUG eLearning

Oracle Tech Network tweeted information regarding a Virtual Development Day

SOA Community asked Why is the Oracle Specialization Program important for Your Fusion Middleware Implementation? and shared a link to the blog by Jurgen Kress

Kevin McGinley shared the YouTube video “Real Time BI with Kevin & Stewart: Ep 016”

Follow me on twitter for daily OBIEE updates and news.

cropped-dreamstime_s_30492048.jpgOracle Team USA News

Feinstein, Whitehouse, Boxer Congratulate America’s Cup Team

Forging ahead on the 35th America’s Cup

Get your ORACLE TEAM USA 17″ desk model here

youtube logoYouTube uploads

Matt Bradley discusses different deployment options for Oracle EPM. Cloud services (SaaS), managed services, on-premise, off-premise all have their merits, and organizations need flexibility to easily move between them as their companies evolve.

Last week’s OBIEE News

indexOBIEE News is out!

OBIEE News is out! Edition of 28th October

rssBlogs of the Week

1. What are the Long-Term Prospects for Oracle Application Express?

In David Peake’s blog, he asks “What are the Long-term prospects for Oracle Application Express?”

He says that the simple answer is that Oracle is committed to the ongoing development and support of Application Express. Oracle itself utilizes Application Express extensively to meet business requirements and improve business processes.

In his conclusion, he says “I can’t guarantee that Oracle Application Express will always continue to have the incredible popularity, inside and outside Oracle, which it enjoys today. However, the above should give you confidence that Application Express has a very solid and promising future, and that Oracle will continue to invest in the tool’s ongoing development.”

Read his full and detailed blog post here.

2.  Tooltip On Column Headers : OBIEE 11g

In this blog by Just Analytics, they describe how in one of their projects, they had a requirement of putting tooltip on column header without losing the data format of the column values.

They describe the process, step by step:

  • Open an analysis in OBIEE 11g
  • Go to column format of the column where tooltip is required
  • Put HTML tag in column Heading and check Contains HTML Markup tag
  • Go to Results tab and check

See their blog post for further details and instructions.

3. Bad BI Form

In this blog post, Jeff McQuigg demonstrates visually how circles can not be compared easily but in a vertical bar, comparison is visually better. He says to keep this in mind when dealing with comparisons using area based visuals.

bi-charts-bad

Read the full blog post here.

linkedin logoThis week on LinkedIn

Kashinathan K shared USAGE OF PARAMETERIZED CURSOR (Oracle SQL/PLSQL)

Karen Smith posted 4 days of Oracle BI content at UKOUG Tech13, hear from users, Oracle and industry experts, check out the agenda today! 1st – 4th December, Manchester

Sachin J shared Oracle Database Version Suffix

Ruben Visso asked, “Does anyone know where I can find a metric reference guide for Oracle BI Apps? I just found one but is from June 2009.” Answer his question here

Join the LinkedIn Oracle Business Intelligence group here.

twitter logoThis week on Twitter

Oracle Blogs tweeted Translating Your Customizations and Critical Patch Update for Oracle Fusion Middleware – CPU October 2013

Oracle Magazine posted Start to finish, ADF Essentials deployment on Amazon EC2  by Wes Fang

Oracle Analytics shared In the Know – “Expanding the range of enterprise analysis puts new insight into workers’ hands” by Alison Weiss

Follow me on Twitter for daily OBIEE updates and news.

youtube logoYouTube Uploads

Oracle Financial Analytics Mobile Application Demo was posted by biecuador_chanel

“Rich Wilkie of Oracle talks about Oracle Financial Management Analytics” was posted by Oracle Business Analytics