OBIEE 11g training in UK

.

Oracle - UK - 2014-10-06 - OBIEE 11g Bootcamp - Training Image

Last week, the ClearPeaks Academy provided an OBIEE 11g Bootcamp training for Oracle BI Partners in Reading, UK. The previous experience of the training delegates ranged from none to more than a year, which made the training a challenging one for the trainer. Also there were delegates with very good knowledge on OBIEE 10g, who were particularly interested on the comparison between both 10g and 11g versions of the product. The trainer was Alex Caminals, our ClearPeaks Academy Manager, who has been providing training courses for more than 7 years in the BI space, accumulates more than 12 years bringing hands-on knowledge and experience in BI projects, and has been working with both OBIEE versions for a long time. That helped him to overcome the challenges faced in the training course without problem. The feedback from the attendees was very good on the trainer’s teaching capabilities and subject knowledge. That must be true as according to Alex the delegates were continuously asking questions related to and even beyond the topics of the training. A clear sign that they were getting their questions answered! The next training will be in two weeks in Munich, Germany. We’ll be there again full of energy to provide a professional service to our customers.

 

If you want to get some information about the ClearPeaks Academy training courses, please visit our Academy page or contact us via our web page form or by sending an email to academy@clearpeaks.com.

Rock on, it’s GITEX time

.

bannerinvitation3partnersa

Yes! it’s that time again, when Dubai becomes the IT point of focus for many enterprises in the MEA region, and yes, ClearPeaks will be present once again!

It will be our absolute pleasure to welcome you to our pod to discuss the Oracle BI and Endeca product stack and to see a very cool showcase which we have built in-house which addresses the benefits of OBIEE as a reporting and dash-boarding product and how Endeca can be used in tandem to solve real business problems.

Technical Sessions every day!

Come visit us at our stand, and we will tell you all about making the most of your BI investment with our scheduled Tech Sessions:

  • Data everywhere: Creating Oracle Mobile Applications
  • Tuesday, October 14th, 3.45p.m. : Discovering the undiscovered (to be broadcasted in the Oracle BI Innovation Zone!)
  • Stunning, powerful BI Visualisation with Oracle BI EE
  • „BI in the Real World“ presentations every day!

In our best tradition, we will share with you our thoughts and experience on the hottest topics for Business and Managers that want to embark on their first BI endeavour, or want to ensure that their ongoing BI project will be successful:

  • The Right Foot Forward: starting your first BI Project
  • BI Projects in UAE: challenges & opportunities
  • Implementing Oracle BI Applications: challenges and benefits

Where are we? Hall 5, Oracle Partner area, WS-10! 

Looking forward to see you soon …

OBIEE 11g training in Sweden

.

Oracle - Sweden - 2014-09-22 - OBIEE 11g Bootcamp - Training Image

Last week, the ClearPeaks Academy provided another OBIEE 11g Bootcamp training for Oracle BI Partners. This time, the country were the training course took place was Sweden and the city was Kista (near Stockholm), also called the Swedish Silicon Valley. The attendees of the course ranged from none to some months of previous knowledge and experience with OBIEE 11g. This is always a challenge for the trainer as the learning curves are very different depending on the delegate knowledge starting point. But no one said providing a training was bread & butter, right? As in our last training, the trainer was Alex Caminals, our ClearPeaks Academy Manager, who has been providing training courses for more than 7 years in the BI space, accumulates more than 12 years bringing hands-on knowledge and experience in BI projects, and has dealt with this type of situations in multiple occasions. The feedback from the attendees was very good on the trainer’s teaching capabilities and subject knowledge. That gave Alex a boost of energy to go for the next training in two weeks, this time in Reading, UK.

If you want to get some information about the ClearPeaks Academy training courses or OBIEE 11g training, please visit our Academy page or contact us via our web page form or by sending an email.

OBIEE 11g training in Norway

.

OBIEE 11g Training

Last week, the ClearPeaks Academy provided another OBIEE 11g Bootcamp training for Oracle BI Partners, this time in Oslo (Norway). The attendees of the course had in general very low or null experience with OBIEE 11g. With this scenario, the biggest challenge of the bootcamp was to bring them up to speed in record time (5 days). The trainer was Alex Caminals, our ClearPeaks Academy Manager, who has been providing training courses for more than 7 years in the BI space and also accumulates more than 12 years bringing hands-on knowledge and experience in BI projects. The feedback from the attendees was excellent and that is encouraging Oracle to keep relying on the ClearPeaks Academy to train their BI Partners in EMEA.

If you want to get some information about the ClearPeaks Academy training courses or OBIEE 11g training, please visit our Academy page or contact us via our web page form or by sending an email.

Pop up effect in OBIEE using jQuery

.

In this article of our OBIEE Customization Series I will show you how to introduce the Pop up effect in OBIEE using jQuery. The tooltip can provide additional details (like an explanation of a KPI) or load content such as target report.

Motivation

For our example let’s imagine we have a summary level report with purchase orders listed. We can navigate to order details level, but that would require leaving the current page or opening the content of detail report in a new window. What if we could have a summary level report and peek into details on the same page? Implementing the dynamic navigation to a report inside the tooltip will allow us to achieve that.

Pop up effect in OBIEE using jQuery

Because OBIEE Answers and Dashboards allow using web technologies such as HTML5, JavaScript, CSS3, and AJAX we are able to customize the look and user interface of any report just like we can do with websites. To achieve that, we will use the most popular JavaScript library called jQuery. It’s an optimized .js file containing Document Object Model (DOM), events, effects and Ajax functions that can be called from the report. JQuery is widely used in website development and allows implementing complex components using pre-defined methods defined in library. For the tooltip we will need also a plugin, an additional library that defines the effect. There are many available plugins for tooltip functionality both free and requiring paid license. Many UI libraries such as jQuery UI or Kendo UI offer, among others, a tooltip functionality. For the example in this article we will use the Tipped tooltip library, which offers a lot of customization options but requires a licence for commercial use.
As an example in this article we will invoke a tooltip that loads the contents of target report when hovered on a column’s value. To create this effect we will need to use AJAX technology. Such method is already included in the jQuery library. We will need to specify the target page or report from which the external content will be loaded.

Implementing the tooltip

Let’s start by creating a simple report showing Order Number, Number of Order Lines and Order Cost.

graph1

Our objective here is to provide additional information of the orders displayed in the first report but without navigating. Therefore let’s create another simple report that will contain more details on a given Order and its Order Lines. We need to add a filter - Order Number is prompted to enable navigation.

graph2

Let’s go to the results tab and edit the views. The contents of this report will be displayed in a tooltip. We can add a pie chart with breakdown of the line cost and save the report as Order Lines Report.

graph3

Let’s get back to the main report. We will need to add a static text view with code to load libraries. Those files could be referred pointing to the file on the internet (we can do it by loading jQuery library from google developers and for example jQuery UI library which contains tooltip functionality). However we should have those files on our OBIEE server. Often internal network security settings disallow loading content (especially script files with .js extension) from external sources. A one-domain policy is used to prevent security breaches. Because of that we will need to save those library files on OBIEE server. To be able to link a file on a OBIEE server we will need to create a virtual directory on OBIEE server in weblogic settings.
When we have the virtual directory created we can refer to the libraries using such link: http://localhost:9704/userfiles/jquery.1.9.0.min.js

graph4

 

First, we need to load the jQuery library:

<script type="text/javascript" src="http://localhost1:9704/user_files/jquery-1.9.0.min.js"></script>

Tipped libraries:  

<script type="text/javascript" src="http://localhost:9704/user_files/Tipped/tipped-3.1.8/js/tipped/tipped.js"></script>
<script type="text/javascript" src="http://localhost:9704/user_files/Tipped/tipped-3.1.8/js/excanvas/excanvas.js"></script>
 

Tipped CSS stylesheet, which contains the styles used for tooltip customization:

<link rel="stylesheet" type="text/css" href="http://localhost:9704/user_files/Tipped/tipped-3.1.8/css/tipped/tipped.css"/>

Then let’s edit the column formula to dynamically generate a tooltip with navigation to Order Line Details.

graph5

We need a couple of elements here. Instead of just "Order"."Order Number" column value we need to embed some more elements in the formula code. The code inside will contain HTML tags so let’s mark Constains HTML Markup option.

graph6

For our example we will need to use the following column formula: '

'<div id="popup' ||"Order"."Order Number"|| '">
' ||"Order"."Order Number"|| '
</div>'
||'<script type="text/javascript"> Tipped.create("#popup' ||"Order"."Order Number"||'", "saw.dll?Go&path=%2Fshared%2FReports%2FOrder%20Lines%20Report&Action=extract&p0=1&p1=eq&p2=%22Order%22.%22Order%20Number%22&p3='||"Order"."Order Number"||'",
{ajax: true,
 skin:"white",
 hook: "bottomright",
 border: { size:1},
 afterUpdate: function()
{}
} );
</script>'

Explanation:
To separate HTML formatting from the OBIEE column value ("Order"."Order Number") we will need to use single quote (') and to merge HTML formatting with the column value we need to use concatenate (||).

<divmarkup is a placeholder for our tooltip. Its id is generated dynamically by concatenation with value of the "Order"."Order Number" column.
Here we initialize Tipped script and call plugin’s method to create a tooltip. The syntax of the script to create a Tipped tooltip is as follows:
<script type="text/javascript">
Tipped.create("#target", "url", { ajax: true });
</script>

# is a jQuery selector that points to a single element with the given id attribute, in our case #popup div concatenated with Order Number. Then there is a url with the external content to be loaded inside ("url"). The important part here is the ajax: true option, which allows loading of external content.

<script type="text/javascript"> Tipped.create("#popup' ||"Order"."Order Number"||'

So basically, the popup will display whatever contents are displayed in the url, therefore we can pass a GOURL link to the detail report passing the order as a parameter. Note the Extract parameter which displays just the results of target report in a format without the paging control, hot links and other elements.

"saw.dll?Go&path=%2Fshared%Reports%2FOrder%20Lines%20Report &Action=extract&p0=1&p1=eq&p2=%22Order%22.%22Order%20Number%22&p3='||"Order"."Order Number"||'"

Here we specify the formatting options of the tooltip. For Tipped tooltip to load external content we will need to use  ajax: true option. Tipped offers richness of customization options for skins, positioning and effects.

{ajax: true,
 skin:"white",
 hook: "bottomright",
 border: { size:1},
 afterUpdate: function()
{}
}

Because the column formula does not include the whole script (it references to the scripts loaded in the Narrative View) we will get a “Formula syntax is invalid” error:

graph7

We can ignore it, as it will work correctly with the whole script at the report execution. We also need to change the Data Format Column Properties:

graph8

We need to override Default Data Format in order to treat text as HTML:

graph9

Let’s make sure that report has the Static Text view added to the Compound Layout.

graph10

Now we can try out our development. The table with Orders should display the tooltip with navigation to target report with the Order details.

graph11

On hover, the order details from the target report are displayed in a tooltip:

graph12

The contents of the tooltip are displayed dynamically based on the navigation condition (in our case Order Number)

Maintenance and other considerations

We need to take into consideration that by embedding scripts to the OBIEE reports we are adding another layer of complexity.  This is especially true for the maintenance reasons as it requires more time and skills for the end users and developers to edit and create reports that contain scripts. Another concern should be that adding too many scripts to the report may negatively affect the performance of the report. We also need to take into consideration the web browsers used by users in the company. Some of the plugins and the latest versions of jQuery library are fully compatible only with the latest versions of browsers.

Conclusions

Thanks to the possibility of using many web technologies such as JavaScript we are able to customize OBIEE reports and dashboards. Tooltip can be a valuable tool to enhance the functionality of OBIEE reports, allowing users to get detailed information when hovering over a link.

Do you have another method to achieve the pop-up effect? Please leave us a comment below, we would be happy to answer it! If you would like to know more about visual enhancements in OBIEE, read our blog posts series about enhanced visualization:

Rich Visualizations in OBIEE with Javascript

privacy policy - Copyright © 2000-2010 ClearPeaks

topnav