Skip navigation.

Feed aggregator

Deploying applications remotely with WebLogic REST Management Interface

Steve Button - Wed, 2015-04-08 19:20
WebLogic 12.1.3 provides a fully documented REST Management Interface that enables deployment and management operations to be performed using REST calls.

The table of contents from the documentation lists the set of operations available:
To use the REST Management Interface, it first must be enabled for a domain. This can be done from the WebLogic Console.

Domain > Configuration > General [Advanced] > Enable RESTful Management Services

To deploy an application to a remote server, the REST Management Interface provides the ability to upload an application archive and execute the deployment operation:
To perform this type of deployment operation a HTTP POST on the deployment URL is invoked specifying:
  1. The HTTP Header of multipart/form-data;
  2. The application archive is supplied as form field deployment;
  3. The deployment information specified using the form field model in which the application name, targets and other attributes are supplied;
Using curl this looks like the following:

$ curl \
--user weblogic:welcome1 \
-H X-Requested-By:TestForRest \
-H Accept:application/json \
-H Content-Type:multipart/form-data \
-F "model={
name: 'basicwebapp',
targets: [ 'AdminServer' ]
}" \
-F "deployment=@/tmp/basicwebapp.war" \

When this REST call is made with curl, the application archive specified as @/tmp/basicwebapp.war is uploaded as a binary file using the form field deployment and the configuration information supplied in the model form parameter used to define and perform the deployment.

The response returned from the REST call contains a payload with the result of the operation that was performed.

"messages": [{
"message": "Deployed the application 'basicwebapp'.",
"severity": "SUCCESS"
"links": [{
"rel": "job",
"uri": "http://adc2101001:7001/management/wls/latest/jobs/deployment/id/3"
"item": {
"name": "ADTR-3",
"id": "3",
"type": "deployment",
"status": "completed",
"beginTime": 1428541581923,
"endTime": 1428541584150,
"targets": [{
"name": "AdminServer",
"type": "server",
"errors": [],
"status": "completed"
"description": "[Deployer:149026]deploy application basicwebapp on AdminServer.",
"operation": "deploy",
"deploymentName": "basicwebapp"

Further information about the deployment resource can be obtained using a further REST call, which provides links to operations that can be performed on the application, URLs to access the application, context-paths for registered servlets, runtime data and other useful information.

$ curl \
--user weblogic:welcome1 \
-H Accept:application/json \

Which returns a response containing a payload with details of the deployment:

"links": [
"rel": "parent",
"uri": "http://adc2101001:7001/management/wls/latest/deployments/application"
"rel": "action",
"uri": "http://adc2101001:7001/management/wls/latest/deployments/application/id/basicwebapp/redeploy",
"title": "redeploy"
"rel": "action",
"uri": "http://adc2101001:7001/management/wls/latest/deployments/application/id/basicwebapp/update",
"title": "update"
"rel": "action",
"uri": "http://adc2101001:7001/management/wls/latest/deployments/application/id/basicwebapp/start",
"title": "start"
"rel": "action",
"uri": "http://adc2101001:7001/management/wls/latest/deployments/application/id/basicwebapp/stop",
"title": "stop"
"rel": "bindables",
"uri": "http://adc2101001:7001/management/wls/latest/deployments/application/id/basicwebapp/bindables"
"item": {
"name": "basicwebapp",
"state": "active",
"type": "application",
"displayName": "basicwebapp",
"targets": ["AdminServer"],
"planPath": "/scratch/sbutton/Oracle/Middleware/user_projects/domains/arq_domain/servers/AdminServer/upload/basicwebapp/plan/Plan.xml",
"urls": ["http://adc2101001:7001/basicwebapp"],
"openSessionsCurrentCount": 1,
"sessionsOpenedTotalCount": 1,
"servlets": [
"servletName": "JspServlet",
"contextPath": "/basicwebapp",
"aggregateMetrics": {
"executionTimeTotal": 0,
"invocationTotalCount": 0,
"reloadTotalCount": 0,
"executionTimeHigh": 0,
"executionTimeLow": 0
"servletMetrics": [{
"serverName": "AdminServer",
"executionTimeTotal": 0,
"invocationTotalCount": 0,
"reloadTotalCount": 0,
"executionTimeHigh": 0,
"executionTimeLow": 0
"servletName": "Faces Servlet",
"contextPath": "/basicwebapp",
"aggregateMetrics": {
"executionTimeTotal": 22,
"invocationTotalCount": 1,
"reloadTotalCount": 1,
"executionTimeHigh": 22,
"executionTimeLow": 22
"servletMetrics": [{
"serverName": "AdminServer",
"executionTimeTotal": 22,
"invocationTotalCount": 1,
"reloadTotalCount": 1,
"executionTimeHigh": 22,
"executionTimeLow": 22
"servletName": "FileServlet",
"contextPath": "/basicwebapp",
"aggregateMetrics": {
"executionTimeTotal": 0,
"invocationTotalCount": 0,
"reloadTotalCount": 0,
"executionTimeHigh": 0,
"executionTimeLow": 0
"servletMetrics": [{
"serverName": "AdminServer",
"executionTimeTotal": 0,
"invocationTotalCount": 0,
"reloadTotalCount": 0,
"executionTimeHigh": 0,
"executionTimeLow": 0
"ejbs": [],
"deploymentPath": "servers/AdminServer/upload/basicwebapp/app/basicwebapp.war",
"applicationType": "war",
"health": {"state": "ok"}

The documentation provides extensive coverage of the many resources and entity types that can be reached via the REST Management Interface.

Oracle PaaS Hands on Workshops

Anshu Sharma - Wed, 2015-04-08 13:59

To selected partners we are offering hands on workshop this month at Oracle HQ (Redwood City) on two exciting tool set in Oracle PaaS. These are -

1)  Oracle Stream Explorer - One Day workshop on Apr 14

The role of Oracle Stream Explorer is to help customers know what is happening in their business at this very moment and act accordingly. Oracle Stream Explorer provides a business friendly user interface on top of the core Event Processing engine. Examples of innovative solutions built using Stream Explorer include -

  • Telecommunications: Perform real-time call detail (CDR) record monitoring and distributed denial of service attack detection.
  • Financial Services: Perform real-time risk analysis, monitoring and reporting of financial securities trading and calculate foreign exchange prices.
  • Transportation: Create passenger alerts and detect baggage location in case of flight discrepancies due to local or destination-city weather, ground crew operations, airport security, etc.
  • Public Sector/Military: Detect dispersed geographical enemy information, abstract it, and decipher high probability of enemy attack. Alert the most appropriate resources to respond to an emergency.
  • IT Systems: Ability to detect failed applications or servers in real-time and trigger corrective measures.
  • Supply Chain and Logistics: Ability to track shipments in real-time and detect and report on potential delays in arrival.

2) Oracle Integration Cloud Service (ICS) - 2 Days Workshop on Apr 21-22 

In Oracle Cloud, equivalent of Oracle SOA is Oracle Integration Cloud Service (ICS). ICS has a Cloud SDK which will be used by Application providers to create Adapters to their Apps. Oracle Apps teams are writing their adapters and we would like to extend this offer to select ISV partners. ISVs can join this workshop to learn more about the development process. Your application can run in third party Cloud or your own data center but simply participate in integrations running in ICS. You can also offer your adapters through Oracle Cloud Marketplace

Please register to attend these workshops.

Simple (Effective) Refresh Approach for ADF Regions

Andrejus Baranovski - Wed, 2015-04-08 12:56
I often hear developer asking about how to refresh different regions on the same page, when specific event happens in one of the regions - to refresh dependent regions. Usually developers would like to use something more simple than Contextual Event approach. There is more simple approach, may be it doesn't work for all the possible use cases - but it does it job, when just refresh is needed. This approach is based on dummy parameter value, being used as dependent region input parameter, with refresh option set to be ifNeeded.

For the sample test case, I'm using ADF 12c application ( This application contains two AM's, to simulate two Data Controls to be used in separate regions:

Fragment from the first region, generates refresh event, when Save button is pressed. For this purpose, I have registered Property Listener to update flag variable. This variable value is initialised from refreshToken method, available in RefreshHelperBean:

Bean method is very simple, it takes current timestamp value and returns it to String. This value always will be changed and this ensures dependent region refresh:

Make sure to set input parameter for the region TF you want to refresh, this should be simple parameter of type String:

TF must call Execute operation, this will force to reload VO rowset data, before loading the fragment:

In the main page, where region is consumed, change refresh condition to ifNeeded and set refreshFlag parameter to point to the variable initialized in the first region (by property listener):

There are two regions rendered on the UI. Once I change data in the top region (form component) and press Save, second region below is refresh automatically and it fetches latest available data from DB:

DataGuard wait events have changed in 12c

Yann Neuhaus - Wed, 2015-04-08 11:11

There are several new features in 12c about Data Guard: cascaded standby, far sync instance. But there are also some architecture changes: new processes and new wait events.

Sample Payload : Creating a Lead

Angelo Santagata - Wed, 2015-04-08 10:43

Very common operation

 Object Name
Lead Version Tested on
 Description This payload demonstrates how to create a salesLead, assign a primary lead owner AND add additional resources to the lead
Operation createSalesLead  Parameters



<soapenv:Envelope xmlns:soapenv="" xmlns:typ="" xmlns:lead="" xmlns:lead1="">
            <lead:Name>gold2 - cust</lead:Name>
            <!--PartyID of person you want to assign it to-->
        <!-- ResourceID is PartyID of additional Resource -->



APEX 5.0: Directory Support for Static Plug-in Files

Patrick Wolf - Wed, 2015-04-08 07:21
Since day one, the APEX Plug-in framework provided the capability to create self containing installations which included all static files needed by the Plug-in. But this file storage was somehow limited in APEX 4.x, because it didn’t allow to reference files with … Continue reading →
Categories: Development

OBIEE and the Oracle Database 12c In-Memory Option – Article and New Services from Rittman Mead

Rittman Mead Consulting - Wed, 2015-04-08 07:00

NewImageMy latest Business Intelligence column for Oracle Magazine is on the In-Memory Option for Oracle Database 12c, and using it to speed-up dashboards and reports in OBIEE11g. In the article I go through the basics of the in-memory option explaining how it adds in-memory columnar processing to the standard Oracle Database Enterprise Edition, and then I take the Airline Flight Delays dashboard in the OBIEE11g SampleApp v406 and enable it for in-memory processing; for queries that go against the base detail-level tables in the Oracle Database queries run roughly twice-as-fast, whilst queries going against aggregate tables return data instantaneously, all without any need to alter the underlying database schema or migrate to a new database engine.

To my mind there are two main groups of customers who could benefit from moving to Oracle Database 12c and the In-Memory Option; customers who are currently using earlier version of Oracle Database with regular disk-stored row-based storage (or indeed customers using other databases, for example Teradata or Microsoft SQL Server), and customers who’ve implemented Oracle Exalytics with TimesTen as the in-memory database cache, and who would now like to take advantage of the additional features and lower cost-of-ownership with in-memory processing directly in the Oracle Database.

If you already have licenses for Oracle Database Enterprise Edition you’ll only need to add the additional In-Memory Option license to enable these new features, whereas if you’re using TimesTen on Exalytics there are special terms for customers who wish to trade-in those licenses for Oracle Database Enterprise Edition and In-Memory Options licenses – and once you’ve moved over to Oracle Database 12c and the In-Memory Option, you’ll benefit from:

  • Access to full Oracle SQL including advanced analytics functions, aggregation and transformation capabilities
  • Moving to Oracle’s strategic database technology for in-memory analytics and Exalytics in-memory aggregate caching
  • Compatibility with existing Oracle Database functionality, making it easy to move reporting databases into Exalytics and enable for in-memory analytics
  • Columnar processing, an alternative to traditional row-based storage that’s better suited to BI-style filtering against attribute values
  • Full compatibility with all reporting and ETL tools that support access to Oracle Database data sources
  • Additional optimisations around aggregation, table joining and other BI-style queries
  • Faster dashboards, more interactive reporting and less maintenance compared to maintaining TimesTen

To get you started with either of these options, Rittman Mead have created two packages for customers looking to adopt Oracle Database 12c In-Memory Option; one for customers on traditional data warehouse databases looking to use In-memory for the first time, and another for customers using Exalytics who want to migrate from Oracle TimesTen. Full details of these two packages are now up on our website at our Supercharge OBIEE with the Oracle 12c In-Memory Option web page, or you can contact us at to talk through your particular requirements in more detail.

Categories: BI & Warehousing

Tuning Database XQuery Statements (1)

Marco Gralike - Wed, 2015-04-08 06:46
I had a question of a colleague to have a look at a statement that…

ORA-31145 – “Duplicate listener, %s, found in resource configuration”

Marco Gralike - Wed, 2015-04-08 06:07
Today I had an error on my test environment which surprised me…initially… While I was…

Take Part in the BI Survey 15, and Have Your Voice Heard!

Rittman Mead Consulting - Wed, 2015-04-08 04:00

Long-term readers of this blog will know that we’ve supported for many years the BI Survey, an independent survey of BI tools customers and implementors. Rittman Mead have no (financial or other) interest in the BI Survey or its organisers, but we like the way it gathers in detailed data on which tools work best and when, and it’s been a useful set of data for companies such as Oracle when they prioritise their investment in tools such as OBIEE, Essbase and the BI Applications.


Here’s the invite text and link to the survey:

“We would like to invite you to participate in The BI Survey 15, the world’s largest annual survey of business intelligence (BI) users.
BARC’s annual survey gathers input from thousands of organizations to analyze their buying decisions, implementation cycles and the benefits they achieve from using BI software.
As a participant, you will:

  • Receive a summary of the results from the survey when it is published
  • Be entered into a draw to win one of ten $50 Amazon vouchers
  • Ensure that your experiences are included in the final analyses

Click here to take part
Business and technical users, as well as vendors and consultants, are all welcome to participate.
You will be able to answer questions on your usage of a BI product from any vendor and your experience with your service provider.
The BI Survey 15 is strictly vendor-independent: It is not sponsored by any vendor and the results are analyzed and published independently. 
Your answers will be used anonymously and your personal details will not be passed on to software vendors or other third parties.
The BI Survey 15 should take about 20 minutes to complete. For further information, please contact Adrian Wyszogrodzki at BARC ( 

Thank you in advance for taking part.”


Categories: BI & Warehousing

LPAR and Oracle Database

Pakistan's First Oracle Blog - Tue, 2015-04-07 19:30
What is LPAR?

LPAR stands for Logical Partitioning and it's a feature of IBM's operating system AIX (Also available in Linux). By abstracting all the physical devices in a system, LPAR creates a virtualized computing environment.

In a server; the processor, memory, and storage are divided into multiple sets. Each set in a server consist of resources like processor, memory and storage. Each set is called as LPAR.

One server can have many LPARs operating at the same time. These LPARs communicate with each other as if they are on separate machines.

What is DLPAR?

DLPAR stands for Dynamic Logical Partitioning and with DLPAR the LPARs can be configured dynamically without restart. With DLPAR, memory, CPU and storage can be moved between LPARs on the fly.

What is HMC?

HMC stands for Hardware Management Console. The Hardware Management Console (HMC) is interface which is used to manage the LPARs. Its Java based and can be used to manage many systems.

If LPAR is in shared processor mode, without the following fix, LPAR may see excessive CPu usage: 

IV01111 AIX 6.1 TL05 if before SP08 (fixed in SP08)
IV06197 AIX 6.1 TL06 if before SP07 (fixed in SP07)
IV10172 AIX 6.1 TL07 if before SP02 (fixed in SP02)
IV09133 AIX 7.1 TL00 if before SP05 (fixed in SP05)
IV10484 AIX 7.1 TL01 if before SP02 (fixed in SP02)

This problem can effect POWER7 systems running any level of Ax720 firmware prior to Ax720_101. But it is recommended to update to the latest available firmware. If required, AIX and Firmware fixes can be obtained from IBM Support Fix Central:
Categories: DBA Blogs

APEX 5.0: Want to learn all about Universal Theme?

Patrick Wolf - Tue, 2015-04-07 15:29
And do you want to learn it straight from Shakeeb Rahman the Designer of Universal Theme? Then you have to sign up for the free ODTUG Webinar on Thursday, April 9 at 12:00PM EDT. That’s 17:00 London, 18:00 Vienna or … Continue reading →
Categories: Development

Finance and HR: A Marriage Made in Cloud Heaven

Linda Fishman Hoyle - Tue, 2015-04-07 14:09

800x600 A Guest Post by Dee Houchen (pictured left), senior principal product marketing director for Oracle ERP Cloud

What’s keeping CFOs up at night?

In conversations with chief financial officers, there are a number of business issues that are common across industries and geographies. One such issue—finding and retaining the best finance talent—is a topic that can dramatically impact the CFO’s effectiveness within his or her own organization.

Over the past several years, the role of the CFO has evolved from someone who keeps the books, to a more visionary and advisory role. Modern CFOs provide the essential reports, insight, and information needed to drive strategy around the boardroom table. This requires a new skill set—much different from the traditional accounting role. The best CFOs have learned to ask themselves the following questions:

  • How is the role of finance officer changing?
  • What sort of skills do finance professionals need today?
  • How do I attract and retain the best talent?
  • Do I have the right technology in place to keep my best and brightest engaged and intellectually challenged?

Wall Street Journal Custom Studios recently issued a report that addresses some of the above questions. Winning the War for Finance Talent: Game Plan for the Digital Age provides six recommendations on how finance leaders can improve bench strength within their own organizations. This infographic summarizes the report’s six recommendations:

  1. Recruit—and pay for—talent armed with a greater variety of skills
  2. Fill talent gaps by grooming from within
  3. Ask the right questions when analyzing data—you want answers that propel your business
  4. Share data with your team or it has no value
  5. Use technology and data insights to read your customers’ needs more accurately—making you a better business partner
  6. Upgrade your technology to attract and retain the best and the brightest. If you don’t, you may lose gifted people to more modern rivals.

On the last recommendation, many finance offices are looking to the cloud to not only update their technology, but improve efficiency between finance and HR. A modern ERP and HCM cloud—with built-in social capabilities, data analysis and dashboards, designed for today’s mobile workforce—can provide the technology edge that CFOs need to attract, and retain, the best talent. Read more in the recent articles, How to Win the Finance Talent You Need and Turning Bean Counters into Difference-Makers: How Corporate Finance is Changing with the Times.

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Calibri",sans-serif;}

Get Recognition for your Knowledge of My Oracle Support by Becoming a My Oracle Support Accredited User

Joshua Solomin - Tue, 2015-04-07 08:55
.xContainer { width:99%; margin-left:auto; margin-right:auto; font-family:inherit; } .xContainer img { display:block; margin:0; padding:0; border:0; width:100%; } .xContainer .imgBox { margin:32px 0; width:100%; } .xContainer .imgStyle { border:1px solid #999; box-shadow:2px 2px 3px #bababa; } .xContainer .floatLeft { float:left; margin-right:20px; margin-bottom:12px; } .xContainer .floatRight { float:right; margin-left:20px; margin-bottom:12px; } .xContainer .oRed { color:#ff0000; } .xContainer .darkRed { color:#c00000; } .xContainer .bold { font-weight:bold; } .xContainer .italic { font-weight:italic; } .xContainer .underline { text-decoration:underline; } .xContainer .strikethrough { text-decoration:line-through; } Join us as part of our live Collaborate15 event.

If you are attending the Oracle Application User's Group (OAUG) Collaborate15, use the event Scheduler to locate Accreditation sessions.

Sessions are available for Oracle DB, Oracle E-Business Suite, JD Edwards, PeopleSoft and Primavera. Take the opportunity to attend expert Q&A sessions to learn more about the accreditation and ask questions; you can also attend the exam session to take your accreditation

(Expert sessions are not replacements for the pre-training refresher videos. Oracle Support staff will be on hand to assist in the exam session—but they will not answer the questions in the exam.)

Add sessions to your planner by entering the term Accreditation and click Search to locate them. You can refine your search further by selecting a date.

Session Scheduler What happens if I am not going to Collaborate15?

Don't miss out—Join us virtually by doing the pre work and watching the Accreditation Series for My Oracle Support and the Level 2 Products you use. If anything is new to you, take time to deep dive by reviewing the online help or taking the additional how to training modules listed in Document 603505.1

Share your experience—via Twitter and include @myoraclesupport to share your success story.

Join Us in the Accreditation Community—At times we will deconstruct questions similar to those in the exam, breaking down the purpose of the question and the answers the exam is looking for. Please note that posting exam questions in public forum is a violation of the Accreditation Program terms of use.

The community is the place to post your questions about the exam itself—share us what you thought about the exam experience:

  • Did you learn new Best Practices?
  • Any issues printing your certificate?
  • Did you vote in the Poll to have an Accreditation Community Badge?

Previewing Three Sessions at the Brighton Rittman Mead BI Forum 2015

Rittman Mead Consulting - Tue, 2015-04-07 03:00

As well as a one-day masterclass by myself and Jordan Meyer, a data visualisation challenge, keynotes and product update sessions from Oracle and our guest speaker from the Oracle Data Warehouse Global Leaders Program, the Brighton Rittman Mead BI Forum 2015 has of course a fantastic set of speakers and sessions on a wide range of topics around Oracle BI, data warehousing and big data. In this blog post I’m going to highlight three sessions at the Brighton BI Forum, and later in the week I’ll be doing the same with three sessions from the Atlanta event – so let’s start with a speaker who’s new to the BI Forum but very well-known to the UK OBIEE community – Steve Devine.

Steve is one of the most experienced OBIEE practitioners in the Europe, recently with Edenbrook / Hitachi Consulting, Claremont and now working with Altius in the UK. In his session at the Brighton BI Forum 2015 Steve’s going to talk to us about what’s probably the hottest topic around OBIEE at the moment in his session “The Art and Science of Creating Effective Data Visualisations”. Over to Steve:


“These days, news publications and the internet are packed with eye-catching data visualisations and infographics – the New York Times, the Guardian or Information Is Beautiful to name but a few. Yet the scientists and statisticians tell us that everything could be a bar chart, and that nothing should ever be a pie chart! How do we make sense of these seemingly disparate, contrasting views?
My presentation provides an introduction on how graphic design principles complement the more science orientated aspects of data viz design. It will focus on a simple-to-apply design framework that brings all of these principles together, enabling you to create visualisations that have the right balance of aesthetics and function. By example, I’ll apply this framework to traditional BI scenarios such as operational and exploratory dashboards, as well as new areas that BI tools are just beginning to support such as commentary and storytelling. I’ll also look at how well Oracle’s BI tools address today’s data visualisation needs, and how they compare to the competition.”

On the topic of data visualisation, I’m also very pleased to have Daniel Adams from Rittman Mead’s US office coming over to the Brighton BI Forum to talk about effective dashboard design. Daniel’s been working with Rittman Mead clients in the US and Europe for the past year helping them apply data visualisation and dashboard design best practices to their dashboards and reports, and he’ll be sharing some of his methods and approaches in his session “User Experience First: Guided information and attractive dashboard design”:


“Most front end OBI developers can give users exactly what they ask for, but will that lead to insightful dashboards that improve data culture and escalate the user xperience? One the biggest  mistakes I see as a designer, are dashboards that are a cluttered collection of tables and graphs. Poorly designed dashboards can prevent users from adopting a BI implementation, diminishing the ROI. 
In this session, attendees will learn to design dashboards that inform, instruct, and lead to smart discussion and decisions.  This includes learning to visualize data to convey meaning, implementing attractive visual design, and creating a layout that leads users through a target rich environment. We will walk through a series of “before” and “after” dashboards that demonstrate the difference between meeting a requirement, and using proven UX and UI design concepts to make OBIEE dashboards insightful and enjoyable to use.”

Finally, someone I’m very pleased to have over to the Brighton BI Forum for the first time is Gerd Aiglstorfer. I first met Gerd at an Oracle event in Germany several years ago, and since then I’ve noticed several of his blogs and the launch of his Oracle University Expert Sessions on OBIEE development, administration and RPD modelling. Gerd is one of Europe’s premier experts in OBIEE and Oracle BI, and for his inaugural BI Forum presentation he’ll be deep-diving into one of the most complex topics around repository modeling in his session “Driving OBIEE Join Semantics on Multi Star Queries as User”:


“Multi star queries are a very useful and powerful functionality of OBIEE. But when I examine reports developed by business users or report developers I often find some misunderstandings on how it is working and queries are build by OBIEE. As additionally the execution strategy in OBIEE has changed to generate SQL of multi star queries I had the idea to introduce the topic at the BI Forum. Thus, it’s a quite interesting topic to go into technical details of OBIEE SQL generator engine.
I’ll introduce how users can drive join semantics on common fields in multi star queries. You will get a full picture of the functionality for a better understanding of how report creation affects SQL generation. I recognized some inconsistencies during my tests of the new OBIEE logic in January 2014. I will demonstrate the issues and would like to discuss if you would say: “It’s a defect within the SQL generator engine” – as I do.”

Full agenda details on the Brighton Rittman Mead BI Forum 2015 can be found on the event homepage, along with details of the optional one-day masterclass on Delivering the Oracle Information Management and Big Data Reference Architecture, and our first-ever Data Visualisation Bake-Off, using the dataset.

Categories: BI & Warehousing

QlikSense – The easy way to create a QlikView report

Yann Neuhaus - Tue, 2015-04-07 00:57

Today, one of the most used Business Intelligence products is undoubtedly QlikView. This Swedish product is one of the best positioned in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms matrix and has been for a number of years.


To make Business Intelligence even more accessible to Business users, the Qlik Company decided to add an additional product in its range. This product should be more accessible and easier to use to create analytics reports. That’s why QlikSense was created.

1.Build a report in a few mouse clicks

One of the great strengths of QlikView is that the use of an analytical report has become very simple. The user of a QlikView report need only to select the various criteria they wish to apply to these tables and graphs so that they are automatically adapted to the application.



In this case, the user has just clicked on the criteria "Argentina" and all report data has been filtered to show only the data for this country.

However, the construction of a QlikView’s report is not so simple. The multitude of options available for creating each artifact can quickly become quite complex. This makes the end user still dependent on the developer's report both for its construction than for any changes they would make.

To make the creation of these reports more accessible to the majority, Qlik decided to launch Qlik Sence. This product brings simplicity in building reports because it’s using the Drag and Drop technology. The user can now create his tables and charts using only the mouse, making the creation of a report as easy as in Excel.

To create a new report in QlikSense, click "Create a new App"


Give the new application a name and click « Create »


Click on « Open»


As in any QlikView report, the first thing to do is to retrieve data. There are two options to do that:

"Quick Data Load" or " Load Data Editor."

  • “Quick Data Load" allows you to select any data coming from a flat file or located in a XLS sheet.
  • "Data Load Editor" allows you to create more complex data sources based on SQL -type queries


For our example, we are using « Data Load Editor ». After opening the application, you should only select the data source connector you want to use and set up your connection to your data source.


I will created later a new blog focused on the creation and the setup of data connection in QlikView and QlikSense.

In this case, we will use a .qvx file type. Such files are created through the QlikView ETL application called "QlikView Expressor ".

The load script is then displayed on the screen in SQL format.


You just have to launch the data load.


When it’s done, you should activate the « App Overview » mode.


Then, the user can create a new sheet:


He gives it a name and click on it.


To display the « Edit » mode, you just have to click on this icon:


At this point, the user can create his graphic using the Drag and drop mode


After chosen the chart type, select your dimensions and measures


And that’s the result.


Despite its simplicity, Qlik Sence retains the power of creating and setting chart from QlikView. But the bulk of operations is now made via selection of options, making much easier to create different artifacts.

2.Type "Map" chart

Qlik has not only added the notion of Drag and Drop. One of the great innovations in QlikSense regards the possibility to create very easily a type "Map" chart, that is to say containing geographical information. It was quite difficult to do it in QlikView because it required the use of fairly complex calculated variables. With QlikSense, you just have to use the type "Map" object specially created for this purpose and complete the requested information.

To create a chart "Map", select the chart type "Map"


The only constraint to achieve this kind of graph is to have a GeoMakePoint type object. It is created by combining two geolocation information type objects (latitude and longitude).

In the example below, the object GeoMakePoint "Location" is the location of cities.


Click in the " Layers " menu. In the "Add Layers " box, insert the GeoMakePoint object you just have created. And in the "Expression" box, add an aggregate expression.


Then, go to the "Background" menu, select the Slippy map server you want to use and copy the URL and the duties of the selected server

Small comment: All Slippy Map servers can be used by QlikSense. They are listed on the website of QlikView. To access it, simply click on the hyperlink "URL and Allocation".


To activate the different colors from your dimensions on the map, go in the menu « Apparence » and choose the following options:


Final result will be displayed on a map. Points are the dimension “city” and the size of the point will be the measure (Sum(Profit)).


This chart is as interactive as the other, it will also apply the filters selected by the user.

3.The mode "Story"

QlikSense also offers the possibility to create "Stories", a kind of Microsoft Powerpoint presentation. A "Story" is simply a result of various reports that have been fixed with the values that the user wishes to highlight. These presentations can also contain some kind of animation options from those used in Microsoft Powerpoint. These Stories are built from existing QlikSense reports on which the user takes a snapshot after having applied the desired filter.

To create a "Story" , simply activate the "App Overview" mode.


Then select the « story » mode and click on « new story ».


Give it a name, push « Enter » and click on the story.


Before creating the story, you should have taken snapshots from other sheets.

Warning : You can’t insert snapshots located in some other QlikSense applications.

To create a snapshot, open a Qliksense sheet located in your application.


Open the story you have made and insert the snapshots you need.


You can add some text zones, Microsoft Powerpoint animations, special forms and media objects.


And that’s the final result.


In conclusion, we can say that QlikView and QlikSense are complementary products that are not reserved to the same type of user.

  • QlikSense is easier to handle and is designed especially for use as a dashboarding tool
  • Using HTML 5 technology, it allows you to create reports for any kind of devices
  • Map type graphs are easier to create
  • You can create Stories

So we can say that QlikSense will be more easily used by the Business than QlikView because of its friendliness to use.

APEX 5.0: Create Plug-ins as Subscription from Master Application

Patrick Wolf - Mon, 2015-04-06 15:00
In APEX 4.x it was a little bit cumbersome to use new Plug-ins in an application when you followed the best practice to subscribe Plug-ins from a Master Application which contained all Plug-ins of your workspace. Having such a Master Application has … Continue reading →
Categories: Development

Oracle Extends Integrations Between Marketing, Web, and Commerce Solutions To Help Marketers Enhance the Customer Experience

WebCenter Team - Mon, 2015-04-06 11:35

Latest integrations help marketers increase efficiencies, drive revenue and orchestrate personalized customer experiences


MODERN MARKETING EXPERIENCE – LAS VEGAS – April 1, 2015 – To help marketers deliver more personalized and engaging customer experiences across digital channels, Oracle today announced the integration of Oracle Marketing Cloud’s cross-channel marketing solution with Oracle Commerce and Oracle WebCenter Sites. The integrations help marketers increase conversions and drive revenue through cross-channel marketing efforts by enabling personalized customer experiences to be seamlessly orchestrated across digital channels.

Read the press release and CMSWire article

Collaborate 2015: WebCenter Discussions and Networking in Sunny Las Vegas

In less than a week, Fishbowl’s WebCenter experts will be heading to sunny Las Vegas for Collaborate 2015! We have a wide range of activities planned, and are looking forward to meeting and learning from other WebCenter users. If you’d like to view a full list of what Fishbowl will be participating in at Collaborate, download our Focus on Fishbowl guide. IOUG also has detailed information about Collaborate on their website.

Collaborate Image 1  Collaborate Image 2

Exhibit Information | Booth #948

Stop by Fishbowl’s booth for demos and discussions of Google Search for WebCenter, next-generation portals and intranets, image-enabled accounts payable solutions, and our newest product, ControlCenter, which provides an intuitive user interface along with workflow and review automation for controlled document management. We’ll be holding a special giveaway related to ControlCenter; stop by the booth for more details and to also register for an iPad drawing!

Presentation Information | Room Banyan F

Fishbowl will be holding three presentations at Collaborate, all in room Banyan F at Mandalay Bay. Be sure to attend to hear firsthand how our WebCenter team is working with customers to solve business problems.

Tuesday, April 14, 3:15-4:15 PM: Engaging Employees Through an Enterprise Portal: HealthPartners Case Study
Presented by Neamul Haque of HealthPartners and Tim Gruidl and Jerry Aber of Fishbowl Solutions

  • Issues HealthPartners had with previous portal sites
  • Benefits of deploying a content-centric, portal-focused framework
  • Improvement in end-user experience HealthPartners has seen with the new portal

Wednesday, April 15, 2:45-3:45 PM: The Doctors Company Creates Mobile-Ready Website Using Responsive and Adaptive Design
Presented by Paul Manno of The Doctors Company and Jimmy Haugen of Fishbowl Solutions

  • Importance of The Doctors’ website for educating customers and prospects
  • How responsive and adaptive design transformed user experience
  • Technologies leveraged to create a mobile-optimized site

Thursday, April 16, 8:30-9:30 AM: Using Oracle WebCenter Content for Document Compliancy in Food and Manufacturing
Presented by Kim Negaard and George Sokol of Fishbowl Solutions

  • Techniques for using revision control and automatic conversion
  • How to provide additional security and auditability around document approvals
  • How to increase efficiency and control over changes in documents

If you’d like to schedule a meeting with anyone on the Fishbowl team during Collaborate, feel free to contact us at See you in Las Vegas!

The post Collaborate 2015: WebCenter Discussions and Networking in Sunny Las Vegas appeared first on Fishbowl Solutions' C4 Blog.

Categories: Fusion Middleware, Other

The Fitbit Surge: Watching Where the Super Watch Puck Goes

Oracle AppsLab - Mon, 2015-04-06 10:26

Editor’s note: Here’s a review of the Fitbit Surge from Ultan (@ultan, @usableapps); if anyone can road-test a fitness tracker, it’s him. As luck would have it, the Surge is on my list of wearables to test as well. So, watch this space for a comparison review from a much less active person. Enjoy.

I’ve upgraded my Fitbit experience to the Fitbit Surge, the “Fitness Super Watch.”


I’ve been a Fitbit Flex user for about 18 months. I’ve loved its simplicity, unobtrusiveness, colourful band options, and general reliability. I’ve sported it constantly, worldwide. I’ve worn out bands and exhausted the sensor until it was replaced by the help of some awesome Fitbit global support. I’ve integrated it with the Aria Wi-Fi scales, synching diligently. I’ve loved the Fitbit analytics, visualization, the badges, and comparing experiences with others.

The human body makes more sense for me as a dashboard than a billboard, as Chris Dancy (@servicesphere) would say.

But I wanted more.

The Flex didn’t tell me very much on its own—or in the moment—other than when a daily goal was reached or the battery needed attention. I had to carry a smartphone to see any real information.

I am also a user of other fitness (mostly running) apps: Strava, MapMyRun, Runcoach, Runkeeper, and more. All have merits, but again, I still need to carry a smartphone with me to actually record or see any results. This also means that I need to run through a tiresome checklist daily to ensure the whole setup is functioning correctly. And given the increasing size of smartphones, I am constantly in need of new carrying accessories. I’m a mugger’s dream with twinkling phablets strapped to my arms at night, not to mention asking for technical grief running around in European rain.

The Surge seemed like a good move to make.

Spinning up the Fitbit Surge in the gym

Spinning up the Fitbit Surge in the gym

Onboarding the Superwatch Experience

I tested my new Fitbit Surge right out of the box in Finland on long snowy runs around Helsinki and have hammered it for weeks now with activities out in the Irish mist and in gyms, too. My impressions:

  • I love the fact that the Surge is standalone. I can record and glance at activity performance quickly, without the whole smartphone connectivity checklist thing.
  • The UI is intuitive with just three buttons (Home, Activity, and Select), and it incorporates swipe gestures and click interactions to get through the little cards that make up the UI paradigm. Familiar. Easy.
  • The Surge records and shows my heart rate, something that I realize should always be part of my fitness plan (duh). I discovered a resting heart rate bpm of around 50 BPM. Read. Weep.
  • The Surge has enhanced notifications capability, and I can see SMS messages or cell phone calls coming in. Nice.
  • The Surge has options for choosing between predefined activities. Fast.
  • The battery life (charging is via USB) is a major bonus over other smartwatches. The limited battery life of the Moto 360, for example, drives me crazy. The Surge battery life gives me about three days (although that is less than that advertised).
  • Having GPS is awesome, as I like to record and see where I have been, worldwide.
  • I am happy with the recorded data, and it seems comparable to the data quality I demand for my runs. I’ve had concerns about the Flex and other devices in this regard.
2_gps_surge 3_cardio_surge 4_ios_app_surge 5_ios_app_overview

On the downside:

  • I don’t like the fact that the Surge is available only in black (as of now), that the display is monochrome, and that there are no interchangeable band options. I’m a #fashtech kinda guy.
  • You can only use one Fitbit device at a time. (I’m like that; I might like to wear a different device on different occasion.)
  • The predetermined activities are slightly limiting. Who knows, maybe ironing in the nude burns lots of calories? (I don’t, by the way.)
  • The call notifications and text notifications are great, but to do anything in the moment with those alerts means that I need to turn to my phone, unlike say my Android Wear Moto Motorola 360 that lets me respond using voice.
  • Having to actually tell the watch what you’re doing first is pure Age of Context denial. Google Fit, for example, does a decent job of automatically sensing what activity I am up to, and where and when I am. Plus, it lets me enter data manually and plays nice with my Moto 360 for a glanceable UI.
  • And then there’s the “unlearning” of the Flex invisibility. I’ve walked off quite a few times forgetting Surge is still in action, and only hours later realized I needed to stop the thing.
 Fitbit Surge versus Motorola Moto 360

Relative glance: Fitbit Surge versus Motorola Moto 360

Thoughts on the Surge and Super Watch Approach

An emerging wearable technology analyst position is that upped smartwatches such as the Fitbit Surge or “super watches” will subsume the market for dedicated fitness bands. I think that position is broadly reasonable, but requires nuance.

Fitness bands (Flex, Jawbone Up, and so on), as they stand, are fine for the casual fitness type, or for someone who wants a general picture of how they’re doing, wellness-wise. They’ll become cheaper, giveaways even. More serious fitness types, such as hardcore runners and swimmers, will keep buying the upper-end Garmin-type devices and yes, will still export data and play with it in Microsoft Excel. In the middle of the market, there’s that large, broad set of serious amateurs, Quantified Self fanbois, tech heads, and the more competitive or jealous wannabe types who will take to the “super watches.”

And yet, even then, I think we will still see people carrying smartphones when they run or work out in the gym. These devices still have richer functionality. They carry music. They have a camera. They have apps to use during your workout or run (be they for Starbucks or Twitter). And you can connect to other people with them by voice, text, and so on.

I like the Fitbit Surge. Sure, it’s got flaws. But overall, the “super watch” approach is a sound one. The Surge eliminates a lot of complexity from my overall wearable experience, offers more confidence about data reliability, and I get to enjoy the results of my activity efforts faster, at a glance. It’s a more “in the moment.” experience. It’s not there on context and fashion, but it will be, I think.

Anyone wanna buy some colored Fitbit Flex bands?Possibly Related Posts: