Category Archives: Pivot

change (increase/decrease) drop-down control width of Pivot Pages, Dashboard or column filter prompts in OBIEE

Standard

Hello Everybody,

Today i have a requirement to change(increase/decrease) width of drop down controls from Pivot Pages, Column filter prompts, dashboard prompts.. etc.

Generally, drop down width will be controlled by the maximum width of values in drop-down.
If you want to set the width to be static and fixed one, then go for this approach:

I must be thankful to my colleague Sravanthi Nuthi for helping me here..

Here we go..

1. Go and edit the views.css file properties located at:

•    <BI_HOME>:\OracleBI\web\app\res\s_oracle10\b_mozilla_4\views.css
•    <BI_HOME>:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\b_mozilla_4\views.css

2. locate this code:

SELECT {
font-family: arial, helvetica, sans-serif;
font-size: 8pt;
}

3. Edit above property to:

SELECT {
width: 120px;  /* Add this property and set width to desired value */
font-family: arial, helvetica, sans-serif;
font-size: 8pt;
}

4. Restart OC4J/web server service where analytics is hosting..

Note: This change will affect all across bi environment.


Regards,
Kishore Guggilla.

Advertisements

Calendar View in OBIEE and Applications

Standard

Hi…

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 .. 🙂

Regards,

Kishore Guggilla.

 

Pagination or “Page Contol” in OBIEE Pivot View

Standard

Hello Everybody,

There are several blog entries which explains about pagination in OBIEE Pivot

Please, include this entry also in that list. J

Suppose, i want to see 10 rows for every page in pivot.

Apart from the columns selected in the criteria for particular request, select another column and modify it’s functionality to CEILING((RCOUNT(1))/10.0). Now, change it’s column heading as: Select Page Number:  and drag this column into Pages block of Pivot

Pages of Pivot

Results are like:

Pagination Control

Note: In denominator of the formula, use ‘10.0’ instead of ’10’.  If you use 10, page Numbers are populated  from ‘0’ and in the 0th page only 9 records will be shown for this particular scenario.