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 [...]

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 [...]

Hi Frens, Sorry to keep you waiting  for the next post, but here it comes. Previously, in the second segment we have discussed the Presentation Server and the Presentation catalog. So, lets continue with the third segment where we will see what is the role of the BI Server in the OBIEE Architecture. BI SERVER [...]

Hello, Day before we came across a new requirement in which we had to call a function created in Oracle DB to OBIEE. Thought of sharing the same with you. It is very simple if you know the trick. We made use of the EVALUATE function in OBIEE to call the function created in the [...]

Hi Friends, There are many times when the clients ask for landing to a particular dashboard instead of the default My Dashboard. I came across this request too. So what i did is explained below. There are basically some approaches to it. 1)  Go to the settings -> My Account and set the Default Dashboard [...]

We have discussed the basics about the connection pool in one of the previous post. Connection Pool is a very important repository object and we should have a good knowledge of that. Moreover, many interview questions are based out of this. Now, lets understand something more about it… Share Me!Blog this!Recommend on FacebookShare on LinkedinTweet [...]

Many a times i have heard users facing issues with server picking up improper joins in Admin tool. Lets take an example to understand this and lets c the solution…. Take an example that we have 2 dimension tables viz. Day Dim & Opty Dim and 2 fact tables viz. Revenue Fact & Order Fact. Now, I wana make my [...]

I m back again after some gap… Now, lets understand whts connection pool.. The connection pool is an object in the Physical layer that describes access to the data source. It contains information about the connection between the Siebel Analytics Server and that data source.  The Physical layer in the Administration Tool contains at least [...]

Joins is a very common thing and most of the people don’t give much attention how and when we use Physical Joins and when we use coplex joins… Lets c how and why of joins….. Primary-Foreign Key Joins The PK-FK joins are generally used in Physical Layer. These joins are required to form the physical [...]