After receiving multiple requests to write on OBIEE security, here I am with the details on the topic. It is a vast topic and I will try to cover it to the best of my knowledge. Why do we need security in OBIEE? This is a rather very basic question but to them who have [...]

Thanks to Rohit for giving me a chance to write in his forum.  I have been waiting for good topic to start blogging. Finally I came across with this. We can change connection pool properties like DSN, username and password dynamically by using URL or passing value through URL. I used the same for changing [...]

Hi Friends, Here I am with a new post and a rather interesting one. In this post we will understand that how can we actually assign values dynamically to session variables and how these variables can be further used in data level security implementation. Before starting with this, we also have to understand the concepts [...]

Hi Friends, Today’s topic is a rather common one and could be found on most of the blogs. After a long time, I again implemented the same so thought of sharing it with all. Most of the BI projects have numerous dashboards and the business owners want them to get displayed in a list form [...]

Hi Friends, I have got a number of requests to write on this topic, so here I am with Level Based Measures in OBIEE. As usual to start with lets understand what does this mean and how is it created in OBIEE.   What are Level Based Measures? For all my new readers I would [...]

Hi Friends, I think most of you must be familiar with the term MUDE in OBIEE and for those who aren’t, its Multi User Development Environment. It is a very commonly used technique while development but still I am writing this post here because some people still dont know how can we make use of it. MUDE [...]

Hi Friends, Sometime back I posted about clearing the prompts while navigating between the Dashboard pages. In that post I mentioned about modifying the instanceconfig file and adding the below tag : <PersistPageState>FALSE</PersistPageState> The only drawback with the above method is that it has an Application wide impact. This means that once we update the instanceconfig file, it will [...]

Hi Friends Few days back I got a requirement from one of my friends according to which he wanted to have the value of  Presentation Variable(selected from prompt) being passed amongst the underlying Multi Select prompts on the Dashboard. Requirement: Each national Promotion have NP Relase date and NP End date ,so, the requirement is to [...]

Hi Frens, Sometime back I was under the impression that the Java Host server is only used for displaying Charts,Graphs and all those flashy images, but, after the below incident I found one more usage of the Java Host server. Today, I had a requirement to create some reports in BI Publisher. When I logged in to [...]

Hey Friends, We have been discussing the OBIEE Architecture and we have covered 3 segments. So, here I am with the 4th segment DataSources. This is a rather simple one as we all know till now that OBIEE is a reporting tool and works on data from  underlying Databases, so here DataSources are the underlying [...]