Tweet The long weekend gave me the chance to finally write a blog post. I will try my best to be more frequent with posting new content...

Tweet We had a requirement where the user wanted to be able to get into the tool and change his formula and also wanted the change to b...

Tweet I am writing this blog after a loooooong gap and I can tell you that it is worth the wait. In this blog, we discuss about the pro...

Tweet Ok call me a geek for writing this blog on new year's eve, I dont care :-P. I can tell you that this blog is totally worth it...

Tweet We know that we can perform outer joins in OBIEE in the Logical Layer. The problem with this mechanism is that it is not possible...

Tweet This blog is less about a solution and more about an information. If you have written an EJB that uses a obiee report saved in ...

Tweet My last article talked about a maintenance and hassle free mechanism to implement security. The article moved the security archi...

Tweet This blog talks about a hassle free mechanism of OBIEE security implementation with almost zero overhead. We will first look at ...

Tweet We have a replication and the primary database server. Replicating the data takes some time so the replication server is usually ...

Tweet This article talks about the process to share files between Oracle VM and windows host.

Tweet We recently had a requirement that the button sizes in OBIEE had to be increased. The reasoning was that the users of some of the...

Tweet Users often have the requirement to have the selected prompt values suffixed to the name of the exported file. This blog talks a...

Tweet The most skilled task in the world of Oracle Business Intelligence is to design and code the RPD. While we are all aware of the g...

Tweet We know that we can use the evaluate function to call any function stored on the database and pass arguments to it. What if we ha...

Tweet We had a requirement of tracking a query fired from OBIEE. This was to help us find out the Analysis that consume the most databa...

Tweet OBIEE 11g client tool is not certified with Windows 8.  The certification matrix for OBIEE version 11.1.1.7.0+ is in the followi...

Tweet We had a strange requirement. The user did not want the dashboard to be published and he hated the fact that he had to expand the ...

Tweet While we all know about using conditions on sections in a dashboard, and while we all have used presentation variables to show or ...

We had a requirement in which the a column had either pure numbers such as 123 or pure alphabets such as QWED. The requirement was to displa...

This blog talks about a quick way to create BIP reports on top of OBIEE dashboards.

We will learn about configuring Active Directory (AD) for OBIEE 11.1.1.7 today.

SQL query is often used as a data source in BIP and often we have a requirement in which we have to use one table when the user selects a ce...

I was recently involved in a project implementation on OBIEE 10g. The dashboard had a multiselect and the values in the prompt were huge. T...

My client wanted to hide some of the reports from the users and release them at a later date. The however wanted a set of users to have the...

This article introduces the concept of Smart Tables in OBIEE. I call them 'Smart' because these tables have the ability to produce...

This is an awesome feature in BI Publisher 11g but I do not hear a lot of noise about it so let me create some. I'm talking about Even...

This is a discovery more than a solution. OBIEE 11g lets us use Hierarchical column as dimensional attributes for charts.

I had a requirement to indent the levels in a hierarchical column. The solution isn't really innovative but I thought of sharing this b...

 This post focuses on the E nvironment variables as they are vital in coding conditional statements .

In the BI world, we talk about measures and aggregation but we don't talk a lot about string aggregation. String aggregation is about c...

This blog talks about the process to use DB Links on OBIEE.

This is a simple trick that presents the process to have a parametrized BIP report in OBIEE without the need to create new prompts in OBIEE...

This is another one of those articles where I pick a topic from the sample chapter of my book and share with you. Some of the other discus...

We will talk about consuming OBIEE 11g webservices using Java in this article. My previous articles have been about consuming webservices u...

Let me begin by defining a ReForm . A ReForm is an amalgum of Reports and Forms and has the DNA of both. This discussion not only presents ...

Data is often stored in sparse form and business often wants to see data in a more organized and explicit fashion. Report developers workin...

This article is borrowed from one of the topics of my book ( http://www.packtpub.com/oracle-apex-4-2-reporting/book ) on Oracle APEX 4.2 r...

  I faced a rather strange but relatively simple requirement a few days back. The client had employed a resource to refresh the sessions p...

Just read about  http://www.sangam13.info/ .The event has been cohosted by AIOUG and India OAUG Such events are indeed rare and fe...

This article is in continuation of my previous work on Oracle Map Viewer/Map Builder and Oracle 12c database. This article demonstr...

Map viewer is a kool technology and I wanted to write about it for a long time.  Let me first chalk the steps that we will follow. ...

Oracle APEX 4.2 reporting is designed to bring the best of the reporting world for intermediate –advanced readers. The book is available ...

I have finally finished writing my book on Oracle APEX reporting. The book will be  is now available at  www.packtpub.com/oracle-apex-4-2-r...

Let me start this article with an apology for not posting an article in such a long time. I have been involved in writing a book and it is...

The requirement was to generate an output in statement page size or in legal page size, depending on a parameter value. Since the paramete...

I spent almost a day to implement a grouping and sorting requirement and after all that brain storming I found that the requirement can ...

This article describes a mechanism to format time in BI Publisher. Let me explain with an example I have a XML file with the followi...

My 1st article in this blog was about OBIEE repository tuning and this article is an extension to it. This article is inten...

Out of all my posts on BI publisher, this one is my personal favorite. The article describes a mechanism to use any custom function in B...

This article describes a mechanism to create reports in excel using the relations established in Oracle BI Server. We can leverage BI ser...

I haven’t extensively worked on data modeling but I saw this kool feature of sql developer data modeler. It gives you a relational pictu...

OBIEE is a great business intelligence tool but it is a one way highway. Users can use OBIEE to see the intelligence in the data but what i...

In this post, I am unsing unpivot function to change the arity and cardinality in the result. mXn table is used to get pXq result such t...

This article presents a way to set SSL enabled APEX 4.1 on weblogic using APEX listener. The final part shows the process to configure st...

Happy Valentine's day to all :) This is the 2 nd part of the series in which I am using webservies to writeback. In my previous arti...

This article presents an alternate way to do write back in OBIEE. I call it silenced because this doecs not involve the creation of text bo...

<p><br><br>&am...

I’m finally back to my blogging business J. This article deals with the usual OBIEE business of formatting. OBIEE gives a lot of formatting...

Below is a review of Oracle BI Publisher 11g-A Practical Guide to Enterprise Reporting, written by Daniela Bozdoc and ...

I know that I am obsessed with web services, but this is my final article in the series dealing with web services.