How to report data dynamically based on user's personal time zone setting -- Part 1

Hello again. Ever since the introduction of global time zone concept, the information that business want to see has a whole different meanings. The transaction with certain amount took place at certain time means the world of difference if considering the time zone in where it occurred. Therefore, viewing data at user's preferred time has always been requirements. One of the trivia situation where time zone matters a lot is when it comes to stock...

Read More

Time series measures -- ago, to_date function for trending comparison

Hello again One of my audience brought up an interesting question a few days back. Below is the message: Hi, Please give me a solution for the below scenario. i have pulled concept name, date, sale value(measures). my requirement is that the report should show sale value based onconcept name and current_year date and last year date of CY date' date like(12-sep-2012 & 12-sep-2011). It is like concept name, CY_date, LY_date, Vales_Val_CY_date,Sal_val_LY_date....

Read More

case study --- How to pass values to different dashboard prompts interactively part 2

In the previous post i have discussed the requirement and passing values from 1 dashboard to another dashboard as we navigate, and also the issues and challenges I was facing in this particular. In this post, we will continue exploring the solutions. So like I said before, I need to find a way to fool OBIEE into thinking these prompts are the same first of all. The first difference I see is that the date prompt in one dashboard is using a between...

Read More

case study --- How to pass values to different dashboard prompts interactively part 1

Hello again There is a scenario where I have to navigate from one dashboard to another while keeping the values selected as the criteria in the next dashboard. OBIEE has a pretty standard functionality that allows you to navigate. In 10G version, you can define the navigation path in the column property while in 11G, you add action links to it. All these are great and simple, but there is a problem when the prompts on these dashboards are different....

Read More