Suppress the OC4J window that appears upon login

It is pretty annoying , to see OC4J window launch everytime I login to my machine.
Finally I found out a way to get rid of it.

Start:
1. Launch regedit
2. Go to the path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
3. Remove the OC4J entry

Pagination for Pivot table

OBIEE doesn't give pagination for pivot table by default. There is a simple work around for that, using rcount.

I implemented it in two ways.

Creating on UI:
1. Create a dummy column called "Page". Add the formula truncate ((rcount(1)-1)/5,0)+1. 5 is the number of rows that has to be displayed.
2. In the pivot table, add the dummy "Page" column to the pages section of the pivot table.
3. When the report is run, the page dropdown appears at the top of the table.


Creating in RPD:
1. The report would have atleast one lakh of records to display. So I gave the user the option of choosing the number of rows.
2. Created a logical column "rsum" in the fact. The formula used was rcount(1).
3. Created a prompt with rsum and used the "Between" operator. So the rsum would show values from 1 to maximum rows.

4. Created a column in the report which is max(.rsum)
5. In the report rsum had the default value of 21 and made rsum prompted in the report.

6. When the report would run, only 21 rows would be displayed. The user could choose the range of rows needed and check the report.

Creating a "Clear my selection"

Most often the users wouldn't want to use the "Clear My Selection" option under the Page-Options, but they would want it right above the prompts. To implement that we need to write a small piece of HTML code.

Steps:
1. Create a text object in the dashboard. In that paste the content as in the image below.

2. "Clear choices" will work just like the "Clear My Selection". Place the text object right above the prompt.

"New calculated Item" in Pivot Table

I came across this intresting option sometime back.

I have five sales stage 1 to 5. But I needed to display in the same row / column the sum of stages 1 and 2. To achieve it I used the calculated item option which is provided in the
pivot table.

Steps:
1. Click on any row / column for which you need a new calculated item.

2. In the window that appears, give a name as it must appear in the UI. Create the forumla.I have given sum of two sales stages.

3. The result will be as shown below. We have a new value which has sum of the two sales stages.


But, we need to remember that the calculated items appear in the same order as they were created.