Monthly Archives: October 2010

Hide dashboard prompts/Section in OBIEE



There is a way to hide the dashboard prompts in OBIEE.

But, need to have a separate section containing this prompt.. that’s reason i made my article title as: prompt/Section 😉

Here is the way..

1. Edit Dashboard, go to Properties of Section > Format Section..

2. Expand Custom CSS Style Options (HTML Only) then select Use Custom CSS Style check box… and write the following code as shown:


It’s more effective then collapsible option..

And, you may ask what is the use of this. Because, when it’s not useful just get rid of it from dashboard.. 😉

But, i used it Here… I guess, now it has got credit. 😛



Kishore Guggilla.


Year Ago Calculation Without Time Series Functions


This article explains you how to calculate year ago measures with out using time-series function.

Usually, for requirement like: measure, year ago measure want to show.. we’ll go for 2 measures. One is: Measure and YearAgoMeasure calculated through time-series.

This blog entry also avoid to create other column for calculating year ago measure..

Here is the procedure:

I’m assuming you have Year dashboard Prompt, assigned with presentation variable: var_Year

1. Create a filter on year column in this way:

2. And filter should be like this:

3.  go to Pivot then arrange columns in this fashion and view Results:

You’ll be noticed that results are giving current/(selected year from prompt) and previous year values ..

Note: Apply descending order on Year column..

You may not like the labels showing year values. Instead of that, you may need to see the labels like: Current and Prior..

This can be done by writing following condition in Year Fx :

CASE WHEN Time.”Fiscal Year” = @{var_Year} then ‘Current’ when Time.”Fiscal Year” = @{var_Year}-1 then ‘Prior’ END

Hope it’ll helpful to you..

Limitation with this approach is: we’re using Advanced filter, which will not appear dynamically changing years in filters view (if you add filter view to compound layout)


Kishore Guggilla.


Calendar View in OBIEE and Applications



Calendar View in OBIEE with Year selection.

Here is the Pivot Layout, you can see the columns used ..

Don’t forget to set an aggregation rule to Max or Min (not sum) for Day Number column there in Measure block of Pivot.

Calendar Week is the column which treat Sunday to Saturday as one week from day starting of year, but not like 1 to 7 is one week, 8 to 15 is 2nd week…

Here is the output:

Applications are like:

Enable a drill report on the day number column to know the transactions for that date..

(it’s not straight forward.. but, possible. If i get time, i’ll come up with an article about that.. )

Please propose other applications on this, i’ll appreciate it .. 🙂


Kishore Guggilla.


Leading Zeroes suppressed of Excel download in obiee


Hi Guys..

I thought of blog this long back.. Unfortunately, forgot about it. But these days i’m frequently seeing this question in OTN Forums..

Here is the workaround i provided:

I’m providing just link this time. When i get i’ll re-write/edit this article with content.


Kishore Guggilla.