Monthly Archives: January 2014

APEX 5.0 will revolutionize the developer productivity

paperliOBIEE News is out. Edition of 27th January.

Stories from mkashu.blogspot.com, artofbi.com and siebel-essentials.com.

Also videos such as David Peake: “The Page Designer of APEX 5.0 will revolutionize the developer productivity”

blogBlogs of the week.

View the blogger database

We have been adding our favourite bloggers and blog posts to a database.  Please contact us if you would like to be added.

1. nQLogViewer in OBIEE

Kashinathan says, “We can use the log viewer utility nQLogViewer to view the query log. Each entry in the query log is tagged with the user ID, session ID and request ID.The User ID will have the details of the user who issued the query, the session ID will have the details of the session in which the query was initiated, and the request ID will have the individual query.” Read the full blog post for instructions.

2. OBIEE 11g – Advanced Row level security

This blog from ClearPeaks discusses the Organization details and then breaks down the Technical Solution to:

  1. Database table
  2. Session Initialization blocks
  3. Data filtering

They conclude by saying:

– Make sure that you don’t have other data security filters defined for the same objects in lower application roles since they can get disabled, i.e. in BI Consumer.

– The session manager is the best place where you can check the session variable values and detect possible bugs in your initialization blocks.

3. OBIEE 11.1.1.7.1 – Improve Performance of Hadoop Queries

Pravin Khadakkar explores the tools to Improve Performance of Hive Queries. He says, “I believe for Hive Queries Exalytics might be a better option.” He shows us the following example from the Oracle published document:

hadoop

4. Case study: Emailing OBIEE dashboards with ad-hoc agent that dynamically passes dashboard prompt values based on user request – Part 3

In Part 3 of a series of blog posts, after going through the case study, Bojie He says, “There are two main pieces of the puzzles according to me:

1. Users will probably document their request in the form of spreadsheet and upload it somewhere.

2. Manually creating of all these user_1s in OBIEE will be a nightmare.

Having said all that, I think I have come to as far as I can come with this solution. It’s not a perfect solution, in fact, it may be a terrible solution in someone’s eyes, but it does work to some extent. Maybe Oracle has plans for this type of requirements in their future products.”

Read the full blog post here.

5. Virtual Column in Oracle 11g

Kashinathan discusses how ‘Virtual Column’ is one of the new features introduced in Oracle 11g. He explores two examples of how to create a virtual column in a table. Kashinathan gives us some important Points on Virtual Columns:

  • All columns in the virtual column, should belong to the same table on which we are creating the virtual column
  • We cannot do any update or DML’s on Virtual column.
  • Virtual column expression can’t reference any other virtual column.
  • Indexes and constraints can be created on virtual columns; also they can be used as partition key
  • Virtual columns reduce the use of views and derived columns

Read his full blog post here

.

6. Open Source Big Data Technologies

This blog by Sunil S Ranka focuses on the mashup picture below:

bigdata

linkedin logoThis week on LinkedIn

Paul Anderson shared OBIEE “Best Practices Guide for Infrastructure Tuning” whitepaper.

Kashinathan K posted Virtual Column in Oracle 11g

Daisy Ding asked What do you think of Columnar Storage?

Kent Graziano asked us to join him at one of his talks  – Better Data Modeling: The Oracle Data Warrior Speaks!

Join the Oracle Business Intelligence Group on LinkedIn.  We now have nearly 8,000 members.

twitterThis week on Twitter

David Allan tweeted Oracle BigDataLite Virtual Machine

KPI Partners posted What’s New In Financial Analytics – Employee Expenses? [Examining OBIA 11g: The Series] from their archives

OracleBlogs shared OBIEE Tuning Guide Whitepaper – update available and OBIEE 11.1.1.140114 bundle patch for Linux 64-bit – Update

Jeff Smith tweeted How to Open the Data Modeler in Oracle SQL Developer

Follow Addidici on twitter for daily OBIEE news and updates.

Even For OBIEE, its all about the database

paperliOBIEE News is out.  Edition of 20th January.

Stories from Jeff Smith, Sunil S. Ranka’s Weblog and M&S Consulting

Videos such as ‘Oracle Business Intelligence Spotlight at Gallup’

blogBlogs of the week

View the blogger database.

1. How-To: File hunt for OBIEE GUI changes

Christian Berg blogs about How to change a part of the GUI of OBIEE? He says “I’m doing these changes quick and dirty to make them instantly visible. The proper way is to create and deploy your own style + skin package within which you do those changes.”

Read in further detail here.

2. Using Oracle Data Pump in Oracle Data Integrator (ODI)

Benjamin Perez-Goytia says, ” This article presents a modified version of the ODI load knowledge module called LKM Oracle to Oracle (datapump) The ODI load knowledge module (LKM) presented in this article has been enhanced with additional options and steps to take advantage of the best features of Oracle Data Pump and Oracle External Tables.  Some of the enhancements include data compression, server to server file transport, threads control, and the use of Oracle Optimizer Hints.  This article shows how to configure and use this knowledge module.”

He then goes through:

  • Using Oracle Data Pump in Oracle Data Integrator (ODI)
  • Overview: LKM Oracle to Oracle Datapump Plus
  • Load Knowledge Module (LKM) Options
  • Configuring your Environment to Work with Oracle Data Pump – There are 3 areas where configuration is required:   the source data server, the target data server, and the ODI studio.
  • Configuring Your Database Link for File-Transfer Operations
  • How does LKM Oracle to Oracle Datapump Plus work? – There are 5 main steps.
  • Understanding the Code Generated by the Knowledge Module

3. How to Add RAC Databases to Enterprise Manager Cloud Control 12c

Gokhan Atil posts here how to add RAC (Clustered Databases) to Enterprise Manager 12c. He says, “Finally I found time to get screenshots and prepare a step-by-step guide!”

4. Better Data Modeling: Color Code Your Data Model Diagrams using #SQLDevModeler

Kent Graziano says, “One of the standards I recommend in my book ‘Check List for Doing Data Model Design Reviews’ is to use colour in your diagrams to visually differentiate types of entities or tables. As luck would have it, Oracle SQL Developer Data Modeler has a feature that makes this very easy. It is Classification Types.” His bonus tip is: If, like me, you want to be consistent across all your designs with the types and colors, I just figured out I can hack the dl_settings.xml file to copy my classification type customizations from one design to another. Just be sure to exit and then restart SDDM after you update the file for it to take effect.

linkedin logoThis week on LinkedIn

 David King posted 6 Desktop BI Tools

Ian Bristow shared OBIEE 11.1.1.140114 Bundle Patch is not Currently Available for Linux 64-bit

Mark Willems shared ‘What is Cloud Computing?

Ujjal Das posted a link entitled ‘Free Cloud Guide: Economics of Cloud Financial Software.’

Saandeep Raghunath posted Change Default Behavior when editing a report

Join the Oracle Business Intelligence LinkedIn group.

twitter logoThis week on Twitter

Oracle Middleware shared In the News: Verizon and Oracle Partner for Better Cloud Access with Fusion Middleware

Perficient & Oracle posted Getting Started With BI In Fusion Applications

Chris Rofidal tweeted The Big Data Doctor is In!

Fusion Applications tweeted SOA Corner: Oracle Introduces Cloud Adapter to Simplify Salesforce.com Integration

Stijn Gabriels shared Successful BI Apps Implementation Part 1: Introduction and the Project Life Cycle

Follow Addidici on twitter for daily updates and OBIEE news.

Yet more Patches for OBIEE

The Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.140114 is now available, fixing a huge list of bugs. There are plenty more bugs in the product so expect many more patches to come.

paperliOBIEE News is out! Edition of 13th January!

Blogs from Siebel Essentials, and John Goodwin.

Videos from Oracle Analytics such as “The Bold Data Project: Big Data Fact Or Fantasy”

blogBlogs of the week

See our blogger database here.

1. OBIEE Version 11.1.1.7.140114 Now Released

The Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.140114 is now available to download via My Oracle Support | Patches & Updates. Follow the links for the single bundle patch (Patch 17886497) and the Dynamic Monitoring Service patch (Patch 16569379).  Also available – Document entitled “OBIEE 11g 11.1.1.7.140114 Bundle Patch is Available for OBIEE and Exalytics” ([Doc ID 1614076.1])

2. Oracle BI Mobile HD 11.1.1.7.0.2365 Now Available

Features include:

  • Using Oracle Business Intelligence Mobile, you can view, analyze and act on all your analyses, dashboards, scorecards, reports, alerts and notifications on the go.
  • Oracle Business Intelligence Mobile allows you to drill down reports, apply prompts to filter your data, view interactive formats on geo-spatial visualizations, view and interact with Dashboards, KPIs and Scorecards.
  • You can save your analyses and Dashboards for offline viewing, and refresh them when online again; thus providing always-available access to the data you need.
  • This app is compatible with Oracle Business Intelligence 11g, version 11.1.1.6.2BP1 and above.

3. OBIEE 11g User Interface (UI) Performance Is Extremely Slow With Internet Explorer 8

Debashis Paul blogs about struggling with OBIEE 11g (11.1.1.5) and IE 8 . He then goes on to find the solution behind ‘HTTP 304 errors’.

4. One of Bill Gates’ favorite graphs redesigned

Bryan Pierce of Perceptual Edge writes a piece regarding a graph selected by Bill Gates to be included in a recent edition of Wired Magazine that he guest edited. He explained why he included the graph as follows:”I love this graph because it shows that while the number of people dying from communicable diseases is still far too high, those numbers continue to come down. In fact, fewer kids are dying, more kids are going to school and more diseases are on their way to being eliminated. But there remains much to do to cut down the deaths in that yellow block even more dramatically. We have the solutions. But we need to keep up the support where they’re being deployed, and pressure to get them into places where they’re desperately needed.”

But how well does the graph tell this story? Read this post for his analysis.

5. Case study: How to implement object level security and data level security in OBIEE 11g – Part 1

Bojie He says, “Recently my team has implemented data level security and object level security in OBIEE 11G for a client who is selling their data to external customers. The requirement is very quintessential of any BI Project and the implementation process is trivial. Therefore, I have decided to detail the process, which I think can be very beneficial to any future security implementation.”

6. 2 Challenges of Converting Legacy Reporting Into OBIEE

This post by Andriy Yakushyn names the 2 Challenges of Converting Legacy Reporting Into OBIEE as Functionality and User Interface..

This post by Pravin Khadakkar answers the Customer Question “The customer would like to make drop down list box default to latest data value available in the list. There is a hidden request which points towards the transactional data availability rather than dimensional values. For e.g. there is a global filter list box defined on Date column, by default the list should shown all date values available irrespective of transactional data is available or not. So there are two different requests we are talking here, the first one to restrict list of dimensional attribute based on transactional data available and then take the latest at default.”

This blog is an attempt to show how this customer request can be fulfilled by using SQL’s within global filter definition.  It is made more interesting when subject area has more than one logical fact.

Ajay Sreedharan firstly goes through the 8 steps in the shapefile import process. Then we can go to the database and query the spatial table. In his next post, he will be discussing Oracle Map Viewer and how Oracle BI is finally plugged in to the equation.

9. Top 10 OBIEE Upgrade Strategies and considerations

Arun Kumar lists the top OBIEE upgrade strategies and consideration, not necessarily in any specific order, as the order of significance would depend upon individual implementation scenarios. He then goes on to say, “In addition to the above considerations, while upgrading, you might want to take advantage of new features of the target version, for example mobile platform support in 11g, like iPads i.e. iOS mobile devices. Android fans no need to be broken hearted yet, as OBIEE has plans for android support in its pipeline.”

linkedin logoThis week on LinkedIn

 Ujjal Das shared a link to a free magazine.  Subscribe for free by following the instructions on the link.

Boris Dahav posted OBIEE BUNDLE PATCH 11.1.1.7.140114 AKA 11.1.1.7.4 is available

Kashinathan K shared Hierarchical Retrieval In ORACLE or Hierarchical Queries

Paul Anderson posted HowTo Videos: Using Smart View to access data in OBIEE.  This links to the YouTube channel Oracle BI TechDemo – OBIEE Samples which has a series of “How to” videos showing how to use Oracle Smart View to access data in Oracle Business Intelligence Enterprise Edition (OBIEE) and display it in MS Office (Excel, Power Point). The examples are built using the Sample App v309.

Smart View with OBIEE – Managing Connections:

Join the LinkedIn group here for daily OBIEE news, discussions and updates.

twitter logoThis week on Twitter

3sixty-analytics shared Navigate the Internet of Things

icCube tweeted Real-Time Business Intelligence

OracleBlogs posted OBIA: Upgrading to Informatica PowerCenter 9.5.1 Hot Fix 2

Daan Bakboord tweeted the HowTo Videos: Using Smart View to access data in OBIEE link.

Stephane Champion posted Performing Text Analytics in OBIEE using Oracle Database features

Follow Addidici on twitter for daily OBIEE news and posts.

Multiple OBIEE 11 on the same server.

Whilst Addidici are not allowed to talk about their current (Military) installation activity, I do like to share what I have been reading each week.
A few years back I installed 10 OBIEE 10g environments on a box (10 env on 8 boxes actually), which was very simple to do. With 11g the challenge was greater, but it still can be done. No need for multiple VM’s.
paperliOBIEE News is out!

OBIEE news is out.  Edition of 6th January.  Blogs from John Goodwin, Oracle BI By Bakboord and Corporate Technologies.

 

blogBlogs of the week

1. Creating ReForms in Oracle APEX

In Vishal’s blog, he defines a ReForm as “an amalgum of Reports and Forms that has the DNA of both.” The discussion in this blog not only presents a ReForm but also demonstrates the enormous benefits of using JQuery in APEX report development. In this post, he discusses the process needed to create a ReForm (Report cum Tabular Form) and also see the process of controlling the data cells for superior reporting.

2. OBIEE 11g Configuration for Interaction for Views

Pravin says in this blog post: “OBIEE 11g offers number options on the way that right-click interactions are handled in views. To configure various options that change the way that right-click interactions are handled in views for an analysis at runtime. The elements in the instanceconfig.xml file specify the default settings for a new or upgraded analysis. One can edit the properties of an analysis in Presentation Services to modify how the analysis handles right-click interactions in views.” Read the whole blog for more details.

3. How-to: Upgrade Usage Tracking OBIEE 10g to OBIEE 11.1.1.x

John Cook discusses the five steps to upgrade usage tracking OBIEE 10g to OBIEE 11.1.1.x as:

1. Make changes to existing OBIEE 10g Usage Tracking RPD

2. Modify Physical Data Model

3. Enable Usage Tracking in Enterprise Manager

4. Deploy Usage Tracking Tables to Your 11g Database

5. Confirm Usage Tracking is Enabled

Read the post and comments here.

4. Creating a Run Button on a Dashboard in OBIEE 11g

Here, M & S Consulting talk us through the steps to create a run button on the dashboard. In the first part of the exercise, they talk about setting up the analysis and in the second part, set up the prompt for it.

5. Speed Mobile

In this post, Mark Rittman writes about: “Creating an Initial Business Intelligence Mobile App” and “Publishing Your App to the Mobile App Store.” He also links to useful documentation including User’s Guide for Oracle Business Intelligence Mobile App Designer 11g Release 1 (11.1.1), also watch videos on how to create a mobile BI app and use key designer features, explore tutorials, review collateral, and interact with social media.

6. Fusion Middleware – OPMN.xml configuration file

OPMN.xml is the main configuration file for OPMN that is used to launch each system component (such as Oracle Business Intelligence).  This post details the various sections and gives an example.

7.OBIEE 11G – staticports.ini

This file is used during the installation of OBIEE 11g to define the ports. This post shows a sample of one.

8. Default OBIEE 11G Ports

Here Sunil says: “Recently came across a situation in which someone, due to some security issue, wanted to bypass OBIEE’s default ports. After looking at multiple places, I could put all information together. I thought it would be a great share.” View the post here.

9. Change Server Port in OBIEE 11g

This ClearPeaks White Paper comprises of the following sections:

  • Stop the WebLogic Managed Server
  • Change the port number
  • Start the WebLogic Managed Server
  • Test that everything is running properly

10. The following Oracle documents are also useful:

11. Oracle BI EE 11g – Managing Host Name Changes

This post by Venkatakrishnan J states that the components at a high level in 11g, which require changes whenever the host name changes are:

1. Admin Server
2. Managed Server
3. Node Manager
4. RCU Schemas Connections
5. System Components
6. Hardcoded Host name entries in Repository, JDBC Connections etc
7. RCU Database Listener

This blog post gives instructions and visuals as to how to carry this out.

12. Error flushing write connection to OPMN

This blog post by “Not just a DBA !!!” talks through the problem – for some reason opmn ports were conflicting for the two domains – and then gives the solution!!

13. Performance and OBIEE – part VII – Optimising OBIEE performance (“Tuning”)

Robin Moffat covers:

  • Anti-patterns in performance optimisation
  • Generally good design principles to observe in OBIEE
  • Optimising OBIEE further
  • BI Server Caching
  • Use fast disk for cache and/or temporary files
  • Web Tier for static content caching
  • Scale out / Scale up
  • Optimising the database
  • Oracle’s tuning document (which can be found here)

linkedin logoThis week on LinkedIn

Kent Graziano posted Oracle Data Warrior: 2013 in Review

Saandeep Raghunath shared Just Analytics blog post “Geospatial Analytics in OBIEE – Part I – The Basics

David Nhan posted Oracle’s Planning and Budgeting Cloud Service (PBCS) Overview and Demonstration

Anand Ekbote posted OBIEE Smartview Integration

Monica Hasebi shared Top Trends in Oracle Business Intelligence & Enterprise Performance Management

Join the LinkedIn group for more Oracle Business Intelligence discussions.

twitter logoThis week on Twitter

Oracle Blogs posted Fusion Middleware Forms & Reports 11gR2 Patchset 2 (11.1.2.2.0) and OBIEE 11.1.1: Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x and a link to ADF Architecture TV in 2014 with 2 bonus episodes, 47 and 48.

Christian Screen tweeted a link to Your OBIEE Commentary and Collaboration Issues are a Thing of the Past…

Andrejus Baranovskis posted ADF Dynamic ADF BC – Loading Multiple Instances (Nr. 100 in 2013)

Follow Addidici on twitter for daily OBIEE news and updates.