Disallow online RPD updates in OBIEE

You may want to disable online updates on your OBIEE RPD for performance reasons or because you have a specific development process that prohibits online updates.

To disallow online RPD updates, do the following:
Log into Enterprise Manager. Navigate the tree menu to Business Intelligence -> coreapplication.  Click tabs “Capacity Management”, and “Performance”.

Under the RPD Updates section, check the box for “Disallow RPD updates”.


This will prevent online RPD updates for all.

If you want to allow a select group of people to have access to perform online updates, such as a lead developer or administrator, then don’t do the above, but instead provide Administrator role to those that should have the access, and remove it from those that should not (and give them BI Author role for example instead).



Installing Tableau Desktop

Tableau is a leading business intelligence software.  Its popularity has grown as a result of its ease of use, awesome visualizations, ability to connect easily to many data sources, its ability to make use of Big Data and Cloud sources, and many other traditional and cutting-edge features.

In this post, I will guide you through the installation of Tableau Desktop 9.  It’s pretty simple.

Go to and click Products, or go directly to


Under Tableau Desktop, click on “LEARN MORE”.


Click on “TRY IT FOR FREE”.


Save the download to your computer.


Click on Run from this dialog box


Navigate to where you saved the download and double-click the file (in this example, TableauDesktop-64bit-9-3-4.exe) to execute or right-click the file and select Run as administrator.




Read and accept the license agreement.


Click Install if you want to install with defaults.

Or you may also click Customize to change some default settings.  Clicking Customize will bring you to the following dialog.


From here you may change the install directory and check/uncheck options as you see fit.  Click Install.


Installation in progress.


Installation is complete. Choose the desired Activation schedule.

You have 14 days from activation to use the product.


Unless you had unchecked this option, Tableau will be added to your Windows start menu.

It’s that simple.


OBIA Financial Analytics – SIL_APTransactionFact_DiffManLoad performance issues

We are on Oracle Business Intelligence Applications (OBIA) and had been experiencing performance issues with the SIL_APTransactionFact_DiffManLoad workflow/mapping. We tried a number of things but only had minimal improvements.   Eventually, I found a solution for the poor performance on Oracle Support.  This change resulted in a drastic improvement of this workflow.

The solution can be found on Oracle Support ( – Oracle Doc ID: 1446397.1), but for your convenience I have included the content below.  There are other mappings that have a similar problem.


OBIA 7963: SIL_APTransactionFact_Diffmanload Mapping And Performance Issue (Doc ID 1446397.1)

In this Document

 Applies to:
Informatica OEM PowerCenter ETL Server – Version [AN 1900] and later Information in this document applies to any platform.

The OBIEE application ( ETL task “SIL_APTransactionFact_DiffManLoad” has run over 68 hours during full load execution.


  1. The size of these columns (DOC_HEADER_TEXT and LINE_ITEM_TEXT )  in DAC is 255 (except AP where its 1020 in DAC and Infa). But in Informatica the size for these two columns is 1020. Ideally it should be 255. This is a known performance issue.
  2. The cause of the problem has been identified in unpublished  Bug 12412793- PSR: B16 INCREMENTAL: SIL_GLREVENUEFACT,

Below are the steps you will follow to modify the size of the fields in the lookup.

  1. Take a backup of existing Lookups ( LKP_W_AP_XACT_F and LKP_W_AR_XACT_F ).
  2. Login to Informatica Designer >Transformations
  3. Open the lookup and modify the size of the fields. The port lengths for the DOC_HEADER_TEXT and LINE_ITEM_TEXT were changed to 255 .
  4. Save the changes
  5. Rerun the test and confirm the performance issue is resolved  and migrate the changes in PROD.


Installing Qlik Sense 3.0 Desktop

This post will guide you through the steps for installing Qlik Sense 3.0 Desktop.

Visit this link to get information on installation requirements and steps:
Installing Qlik Sense Desktop Information

You will get to information such as that shown in the screenshot below …

Click on “System requirements” and “Browser support” to get information on system and browser requirements before starting the installation.  System requirements will show operating system, processor, memory and disk space requirements among other things. And browser support will specify the browsers required for each supported OS.

Click on “Obtaining the setup file” to access the installation file

Click “Download Qlik Sense Desktop”

Click the FREE DOWNLOAD button

After the download is complete, navigate to the folder where you saved the file.

Run the setup executable (Qlik_Sense_Desktop_setup.exe) by double-clicking on it.  In some cases, it is best to right-click on the setup executable, and “Run as administrator”.

Click on “Accept and Install” to acknowledge that Microsoft .NET Framework will be installed and continue to installation process.

Close all other applications, and click Install.

Accept the license agreement and click Next.

If desired, check “Create desktop shortcuts”.  Click Install.

The installation is complete.  Click Finish.

QlikSense_Installation_windowsmenu             QlikSense_Installation_desktopicon
Either from the Windows menu or from the desktop icon, launch Qlik Sense.

You are ready to start using Qlik Sense 3.0.  It’s that simple.

If you get an error message that reads … “An error occurred.  The service did not respond or could not process the request.” … then read the article on this site that addresses that issue to see how to resolve.

Qlik Sense Error on startup – The service did not respond or could not process the request

If you start the desktop version of Qlik Sense and get the following error message, this post might be helpful in resolving.

An error occurred.  The service did not respond or could not process the request.

I ran into this error.  After doing a few searches to try to find the reason for this error, it turns out that this was a result of not having internet connectivity, and Qlik Sense 3.0 requires network connectivity.

To resolve, you can try again once you are somewhere that you have an internet/network connection, or you can create a loopback adapter, which will make Qlik Sense always have a network to connect to.

The following steps through how to install the loopback adapter on Windows 7.

Click the Windows Start icon, and type hdwwiz into the Search box.

The wizard opens with the Add Hardware dialog …
Click Next.

Select “Install the hardware …” option, and click Next

Select “Network adapters” and click Next.

Select Microsoft (on the left), and then select Microsoft Loopback Adapter (on the right), and then click Next.

Click Next

Click Finish.  After installing, Qlik Sense should launch without a problem.


QlikView vs. Qlik Sense

What is the difference between QlikView and Qlik Sense?  QlikView and Qlik Sense are both business intelligence platforms from the same company (Qlik), but are different products. Qlik Sense is not just a new version or release of QlikView.

The below table shows the differences and similarities between the 2 products:

QlikView Qlik Sense
First version released in 1996 First version released in 2014

Data Discovery

Same analysis/calculation engine – scripts and formulas will mostly work between the 2 platforms

Same green-gray-white (included-excluded) functionality

Both products/platforms will be enhanced and supported for the foreseeable future

Guided Analytics – drill-down and drill-through

Self-service data analytics and visualization

Dashboards and analytics/reports built by developers and pre-canned and configured for flexible user interaction Metadata for reporting developed by developers, and users create analytics
Users typically do not have the ability to create new analysis, but use the various features built to slice and dice the data. Users slice and dice the data in any creative manner that they see fit.
Open APIs allow for embedding Qlik Sense into website and other applications, and also for extending the application.
Cutting edge web interface – Responsive web interface – adapt to different screen sizes – from PC to tablet to phones – on any HTML5-compatible browser
Collaboration and story telling
Extensive Pixel-perfect formatting options

Which is better?  It depends.

If you have a user base and business needs that require answers to specific questions, without the need for user self-service BI, then QlikView is a good option.  Also, for very high control over all features of the visualizations you create, QlikView is the better choice.

However, if you have a sophisticated user base that desires to create their own analyses and business needs are more toward data discovery, then Qlik Sense is a good option.  Also, if you plan to or would like to make analytics available on all kinds of devices, then Qlik Sense is the way to go due to the responsive web design interface.

Of course, there will be other factors such as cost, and available resources and skills within the BI Team and supporting teams.  As with any software choice, a full analysis of the options and how they best meet the requirements is needed.

What is Qlik Sense?

Qlik Sense is a business intelligence platform with strengths in self-service usage, data discovery, and visualization.  Qlik Sense is from the same company that develops QlikView, but it is a totally different product. It is not an upgrade to QlikView or a new version of QlikView. However, it provides the core functionality that QlikView offers – such as in-memory storage and processing, the included-excluded/green-white-gray feature, and associative data model; with some additional features and benefits – such as usability, cloud readiness, responsive design, data storytelling, and open APIs.

Qlik Sense is available in 3 editions – desktop (for use on a personal computer for a single-user), enterprise (create and consume via a web interface for the entire enterprise), and cloud (create and consume via web interface on any device while hosted on the Qlik cloud).

You can learn more about Qlik Sense, QlikView, and Qlik (the company that creates these software) by visiting the company’s website at: