Multiple columns in a Single Column

There are certain times where we require multiple columns in a single column. For eg there is a Plan Name and Plan Type where the client doesn’t want to drill down to the next level but wants to see the Totoal Amount of all the Plan Name and Type together. For this we can use this method from the Analytics itself to bring about the … Continue reading Multiple columns in a Single Column

Google Search on the Dashboard

We can place google search on the Dashboard .It is very simple. In the Dashboard take a text box and copy this HTML. Make sure to tick the HTML box. Once this is done save it and you can use Google search on your dashboard.         Cheers !!Jethin Continue reading Google Search on the Dashboard

Multimedia in Dashboard

Playing Video in Dashboard Now a days people want all the Dashboard really interactive. Imagine if you can play a video clip in your Dashboard along with all the other reports. Yes this is possible. Just follow the steps below.1. Turn on the IIS feature from the Control Panel. 2. Reboot the computer. Go to C Drive and in the select all the hidden folders. Traverse … Continue reading Multimedia in Dashboard

Siebel OBIEE Integration

These are the steps to integrate OBIEE with Siebel Application. The Analytics Connection parameters setting are found in following places: 1)      Site Map > Administration Integration > WI Symbolic URL List > Host Administration (drop down). 2)      Site Map > Administration Integration > WI Symbolic URL List > Symbolic URL Administration (drop down). Please login as “SADMIN” user (Take prior permission), since they have only … Continue reading Siebel OBIEE Integration

Hide the Apply and Reset Button in the prompts

Today while presenting reports to the client, he didn’t want the “Apply” button below the prompts. For this there are 2 methods. First Option 1. Edit the Dashboard Prompt and in the Page area edit it and untick the option Apply and Reset according to requirement.2. Save the option and it will turn up.   Second Option Here Edit the Dashboard and in tools option choose … Continue reading Hide the Apply and Reset Button in the prompts

Backspace and Delete is not working in Oracle SQL Developer

Today while I was working on Oracle SQL Developer when I open the worksheet the backspace,delete and enter button is not at all working. If I try to setup a new connection there things work fine but it is in this SQL Worksheet that the backspace,delete and enter button do not workI tried all possibilities and was planning to go for re-installation  where I found … Continue reading Backspace and Delete is not working in Oracle SQL Developer

Error: BEA-141281, unable to get file lock, will retry … – (Solved)

I installed OBIEE 11G in my machine and after the first restart faced this issue after which the weblogic server got shutdown.       This is because there is a lock in the WLS which has to be removed. For that go to the path   ORACLE_HOME//user_projects/domains/bifoundation_domain/servers/AdminServer/tmp and delete the file.   When you later start the services its going to work fine. Continue reading Error: BEA-141281, unable to get file lock, will retry … – (Solved)

Creation of Users and Groups Users and Groups are created using the Weblogic Server Administration Console. It is easier to create users and assign the users to groups. Oracle strongly recommends to assign Application Roles to the groups and not to the users. 1. In order to create a user first we have to go to the console which will be a path somthing like … Continue reading