Change or remove the Powered by Oracle image

Would you like to change/remove the “Powered by Oracle” image link in OBIEE Answers/Dashboards. The file (“siebelbug.gif”) path is known, but which *.css file does it exist in?

1. Open OracleBI\web\msgdb\l_en\messages\productmessages.xml file.
2. Search for the fmap:siebelbug.gif line on this file
3. Replace it for fmap:empty.gif and save it.
4. Restart Oracle BI Server and Oracle BI Presentation Server Services in order to apply this changes. Or if you are already logged in the application, prior to stop and start both services, you can click on Settings > Administration. On the Administration window opened, click on Reload Files and Metadata. Wait a few seconds, then go back and access the Download Link. The changes will be applied there.

OBIEE Linux components

QUESTION 1) Whether all OBIEE 10.1.3.3 Infrastructure components can now be deployed exclusively on a Linux platform?

ANSWER: According to the Oracle Business Intelligence Infrastructure Installation and Configuration
Guide> Installing Oracle BI EE Infrastructure > Oracle BI Installer Screens and Prompts

There are restrictions on Installing Oracle BI Under Linux. Using the Custom installation choice, only the following components are available under Linux:

> Oracle Business Intelligence JDBC Driver
> Oracle Business Intelligence Systems Management
> Oracle Business Intelligence Server
> Oracle Business Intelligence Cluster Controller
> Oracle Business Intelligence Scheduler
> Oracle Business Intelligence Client
> Oracle Business Intelligence Presentation Services
> Oracle Business Intelligence Presentation Services Plug-in
> Oracle Business Intelligence Publisher

Therefore, this implies that that the other OBI components can only be installed on Windows.

OBIEE and session cookies, and Google Chrome rambling

I was wondering about different behavior while using OBIEE in different browsers – by the way, Answers isn’t working in Google Chrome, I’ve created an enhancement request – but I don’t think it’s a critical issue as of right now. Reason for my amusement was that Chrome is supposedly very good and robust at handling Java scripts. However, in Answers, it’s not rendering left frame at all. I’ve not checked it thoroughly, but I think, it’s because of the way the Java-Script is produced on the server.

But to keep us on track here, I read about the following question.

Why is this happening?

1. User logs into dashboard .
2. After the dashboard is shown the user opens another browser instance and selects the link from the dashboard login window.
3. After that the dashboard is shown without asking for the login/pwd.

Why its not asking for the login/pwd again when another browser instance is opened?

They also noticed that this happens when they used tabs in the same window. But when they open a new window and put the link it shows the log in page first. They want to know why this is so?

Answer.

This is happening because the Presentation Server is probably using the same cookie. If you connect and have a cookie that hasn’t expired, then it will assume you’re the same user. Check the URL – does it have a sessionid?

One test you could do is to log in first and than open the session viewer and note how many sessions are open (the top half lists the sessions with their unique sessionID’s). Now open another browser window and copy the dashboard link….check your session viewer again do you have a new session? If not than you will need to check your browser settings to make sure the cookie is not being saved.

Regarding the last question “when they open a new window and put the link it shows the log in page first” this is normal – the tabs are sharing the same cookie session file. If they close the window, they loose the active session. The cookie is keeping track of the browser session in use. That’s why when they open a new browser window, they still have to login.

That’s it for now. Have a great week

Hierarchy – order of displaying lowest level attributes

There was a problem in drill down in one of the hierarchy with the order it displays the lowest level attributes.

When drilling down on a certain category – “Organization”, Answers always shows columns in the following order:
Organization Name,Department Name, Sub-Department Category, Org Detail Number, Org Detail Name

The desired order is:
Organization Name,Department Name, Sub-Department Category, Org Detail Name, Org Detail Number

The hierarchy was defined as following in the RPD (please note that Org Detail Name and Org Detail Number are at the same lowest level defined as keys):

Organization Name
Department Name
Sub-Department Category
Org Detail Name | Org Detail Number

It has been found that it doesn’t sort alphabetically.

With Oracle’s OBIEE support and help – the solution has been found:

1. Use the Query Repository feature under Tools menu in the RPd to do a search of these 2 columns in the RPD.
2. In the Query Repository window note down the IDs for these 2 columns. Please check which one is bigger than the other.
3. The logical table, delete the 2 columns (Org Detail Name and Org Detail Number) and add them again in the desired order. Make sure you add them in the correct order. Query for the columns again, the IDs should be in the reverse order as step 2.
4. Add them in the hierarchy again
5. Change the order of level keys in Dimension hierarchy
6. Save the changes and test again.

After RPD re-deployment – it was working.

There must be an easier way to change order of composite key (complex key) columns.