OBIEE: April 2012

OBIEE 11.1.1.6.0 coreapplication doesn't start due to the error : MBean attribute access denied

Hello

I happened to install OBIEE 11.1.1.6.0 on my machine. Installation went fine and I could log in to the front end for the first time. Today when i started the BI services - even after waiting for a long time I could not see the starting page of OBIEE 11.1.1.6.0 , so i checked the EM and saw this error MBean attribute access denied due to which coreapplication was not up.

I found this note -[ID 1439413.1] in oracle support knowledge database, As per this note I just had to change one setting in the configuration file.

Search for dms_config.xml in

C:\OBI11g\user_projects\domains\bifoundation_domain\config\fmwconfig\servers\AdminServer

And

Change this entry:

to:

I restarted the BI services and could log in to the front end without any errors.

Thanks to Oracle Support.

Bug 9715457 : DYNAMIC REPOSITORY VARIABLE DO NOT REFRESH IN ANSWERS LOCATIONS

Sometime back I wanted to display the current day time in a customized format in OBIEE 11g Title view.

At first I started with creating a dynamic repository variable which gave me the current datetime value in a customized format and I tried to call this variable in the Title view. I could not see the dynamic value of that variable. Later I want back to check the RPD-The initialization block was OK. I had not set the default value for that variable so I thought let us initialize. I saved the settings and again called that dynamic repository variable in the Title view.Now this time I got to see the DEFAULT value which was initialized in the RPD but not the dynamic value.

After checking with Oracle Support - It was found that that was a bug and they said they would fix in the next release.

Bug 9715457: DYNAMIC REPOSITORY VARIABLE DO NOT REFRESH IN ANSWERS LOCATIONS

So the workaround is to create a session variable and call it in the Title view.

Filtering report with concatenated Year Month

Note - This exercise has been carried out using OBIEE 11g. There are many ways to arrive at the solution - This one is coming to my mind and applicable at the front end.
One assumption : In the "Period" table - I have a unique identifier "Month_Id" that uniquely identifies YearMonth - Just like the Calender_Month_Id in the Times Table of SH schema that comes with Oracle database.

So let us start. In my front end - I have columns named Year and Month. I am gonna concatenate these 2 columns ( December -2002 ). I will call it as YearMonth. Now I want the user to select the
YearMonth between say December 2002 and December 2004 from the dashboard prompt and user would be shown the data filtered on YearMonth.

Look at the YearMonth prompt:

I selected the column Year and changed its column formula to -
"TIMES"."CALENDAR_MONTH_NAME"||CAST("TIMES"."CALENDAR_YEAR" AS CHAR)
I changed its Label to "Select YearMonth between"
In properties - Set the presentation variable A.

I selected one more column Monthname and new column check box and changed its column formula to -
"TIMES"."CALENDAR_MONTH_NAME"||''||CAST("TIMES"."CALENDAR_YEAR" AS CHAR)
I changed its Label to "And"
In properties - Set the presentation variable B.

I am NOT using a single column with the BETWEEN operator but 2 columns with slightly different column formulae and properties.

Now let us create 2 intermediate reports.

Carefully look at the columns, column formulae and filters.

1> INT Y-M

2>INTM Y-M

Now I am creating a main report - For the time being I have taken 3 columns namely Year, Month and Month Id.

Have a look at the filters: I have used these 2 intermediate reports as a source for these filters.

This is my main report: Final YM_2

Month Id column is sorted in ascending order.

Go to dashboard editor.

Section 2 properties - Select Condition - Give the path of main report Final YM_2
( condition : Rows > 0)

I have also added a text object - Look at the note and here is the output.

Let us hide the Month Id column from the Main report Final YM_2.

Thanks.

Checking active user sessions

I wanted to check how many users were really active at that moment - in other words - "How to find active user sessions ? "

I as an Administrator logged in to OBIEE front end.
I asked 2 more users to log in to the same.

Now in my system - I opened a new page with this type of URL -

http://<MyHostName>:9704/analytics/saw.dll?Perfmon

Off course I was expecting 3 active sessions :

I found this counter - Active Sessions -->

Thanks

Showing a column name as a tool tip when the mouse is rolled over the column data

Aim is to show a column name as a tool tip when the mouse is rolled over the column data

Thanks.