OBIEE issues – you asked I answer (find answer)


I’m back after being busy with some really interesting issues at work.  I found a minute and I’d like to post few items.

First of all – the question “In OBI, How to move System Wide default settings from one environment to another?” comes up a lot – here’s an official response that I found on the knowledge base:

System wide default settings cannot be moved from one environment to another by design. The recommended way to move any other changes is to perform an Archive and then an unarchive. But, this method does not work for System wide default settings

The following Bug has been logged to make this feature available in the future releases:

So now you know what to tell your project manager.

Second item I found interesting is:

“How to reduce the space between multiple pivot tables placed side by side?”

1. Provided that s_oracle10 is in use; backup the following files before editing them
– C:\OracleBI\web\app\res\s_oracle10\b_mozilla_4\views.css
– C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\b_mozilla_4\views.css

2. Set the following section in both files above:


3. Restart the OC4j and the Presentation server
Third item,
“When defining multiple connection pools for a database in the physical layer of the rpd, is it possible to make the queries use the 2nd connection pool because current behavior seen is that the 1st connection pool is used by default for all queries?”

There is currently no way to make a query use a specific connection pool. The following bug has been raised to address this requirement- As you are already aware, current workaround is to have separate database defined in physical layer :


Customers requirement :

They have a new application that need connect to mutiple database, so under
physical layer root have two connection pool.
So under Database in physical layer 1st connection pool points to an oracle
instance and second connection pool points to a different oracle instance.
When we run report in answers, the connection information is always taken
from the 1st connection pool by default – hence we get table cannot be found
ora error. Reason being the table exists in the database instance referenced
in the 2nd connection pool.
When we do view data in RPD , the results return fine – this is because while
clicking on view data, we explicitly have to select the connection pool.
While creating the logical table/column, we only specify the database name
and the schema name and the table name- no place to provide connection pool
info – hence the server chooses the 1st one by default.
Need a way to fix this – current workaround suggested is to have multiple
database created in physical layer.

Thank you wonderful Oracle support representatives. You’re doing great job – often overlooked, but appreciated nevertheless.
Have a safe OBIEE day

12 thoughts on “OBIEE issues – you asked I answer (find answer)”

  1. Hi,

    When I click on Manage option in the menu in Administration Tool, I find that Jobs, Session, Cache are disabled in my machine. How can I enable the same ?

    Thanks & Regards,

  2. Do you want to do this dynamically? You should use conditional formatting feature of the BI Answers.

  3. Hi

    i have created multiple hirerachy in time dimension and assigned time_id as chronological key which is at the dimension detail level and acting as shared child level for both of them……

    I have created AGO function for calendar year as

    AGO(Test.”Fact”.amount_sold, Test.”Time Dim”.”Fiscal Year”, 1)

    but when i have used AGO column in answers i am getting below mentioned error:-

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 22046] To use AGO function, the query level (‘Calendar Year, Fiscal Year’) must be a static level. (HY000)

    Report has three columns as FiscalYear,TotalAmount(current Year), lastFiscalYearAmount and filter on calendar year

    any suggestion would be appreciated to solve this.

    thanks & regards

  4. Hi,

    How can I validate date prompts?For eg: If I edit the date as Feb 30th in the date prompts and click on GO button an error message needs to be displayed as the date criteria is wrong.Is it possible??

    Thanks and Regards

  5. Hi,

    I want to merge two identical RPDs, both pointing to different databases.(two connection pools)

    Is it possible. I tried doing it but many physical layer column mappings went amiss.

    Also, if this IS possible, how do we switch between connection pools?

    Thanks and regards

  6. Hi,
    Do you have any idea
    Why the whole OBI platform hangs and becomes inaccessible because of a one or more sessions which is also hanging on the DB level? Actually we have long running sessions and complete platform becomes unavailable because of such sessions. any one has idea how to handle this?


  7. While iam trying to check the network connections am getting the following message can anybody please help on this

    [2011-09-28T22:54:49][opmn][TRACE:1][667][OPMN][code:pm-requests]Request 18 Started. Command: /start
    [2011-09-28T22:54:49][opmn][TRACE:1][662][OPMN][code:pm-process]Starting Process: coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1 (1258315537:0)
    [2011-09-28T22:54:49][opmn][TRACE:1][662][OPMN][code:pm-process]Starting Process: coreapplication_obips1~OracleBIPresentationServicesComponent~coreapplication_obips1~1 (1258315538:0)
    [2011-09-28T22:54:49][opmn][TRACE:1][662][OPMN][code:pm-process]Starting Process: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (1258315539:0)
    [2011-09-28T22:54:49][opmn][TRACE:1][662][OPMN][code:pm-process]Starting Process: coreapplication_obiccs1~OracleBIClusterControllerComponent~BIClusterController~1 (1258315540:0)
    [2011-09-28T22:54:49][opmn][TRACE:1][662][OPMN][code:pm-process]Starting Process: coreapplication_obiccs1~OracleBIClusterControllerComponent~BIClusterController~1 (1258315540:0)
    [2011-09-28T22:54:51][opmn][TRACE:1][][OPMN][code:libopmncustom]Process Ping Failed: coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1 (1258315537:14514) [No addresses matched the properties for the request.]
    [2011-09-28T22:54:51][opmn][TRACE:1][][OPMN][code:libopmncustom]Process Ping Failed: coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1 (1258315537:14514)
    [2011-09-28T22:54:51][opmn][TRACE:1][][OPMN][code:libopmncustom]Ping failed in Ready callback for proc:1258315537
    [2011-09-28T22:54:51][opmn][TRACE:1][][OPMN][code:libopmncustom]Process Ping Failed: coreapplication_obiccs1~OracleBIClusterControllerComponent~BIClusterController~1 (1258315540:14530) [No addresses matched the properties for the request.]

  8. a question…


    I have a report which shows

    date | amount | amount 1 day ago | amount

    Two days ago it worked fine but if I specify a date e.g. place a filter on the date column to show 01/Nov/2011, it shows today’s amount but all the Ago amounts are blank.

    If I change the filter to place it on a non date columns e.g. 20111101, the Ago’s work but I don’t get to use a nice pop up calendar.

    Why is the date filter blocking the Ago results?

Leave a Reply