Tag Archives: obiee projects

January 2012 Update

Happy New Year! 2011 was extremely difficult to blog not just for me – but for so many other OBIEE bloggers – I re-visited links on my right hand side and noticed that many people didn’t post anything for several months.In some way it makes me feel better as I am not the only one who is not writing on a regular basis. On the other hand, I realized that blogging about OBIEE is what can keep me in better shape technically and let me study new practices and topics. I can only assume that this business intelligence writing block is due to workload and other commitments. I have not made any OBIEE New Year resolutions, however, it seems as my goal is to have at least a posting per week. I’ll try to focus on OBIEE 11g topics as well as some general business intelligence topics. I’m also going to analyze interesting bugs I can find from Oracle’s support.

I have seen an excellent post by Stewart Bryson – Agile Data Warehousing with Exadata and OBIEE: Model-Driven Iteration – he continues to write about a very relevant topic – OBIEE agile development. It’s absolutely necessary to have an idea about this topics since more and more companies and organizations are researching agile development.

I’ve read this with great interest and waiting for more. I also made a point to check Christian Screen’s podcasts – ArtOfBI.com Podcast on iTunes.

Thank you very much for visiting and please leave a comment suggesting which topics you’d like to have covered.

OBIEE topics of interest

Good morning All,

I’m back from Florida vacation. What a change – to come from sunny Florida to cold and raining New York.

Trying to see what’s going on in the OBIEE world. Couple interesting topics on the OTN:

Write back – topic – very interesting and growing

Example on how not to ask questions about complex joins – the author should have provided all the details in the beggining

Not using AGO and TODATE functions – I don’t know why anyone would like to avoid using AGO and TODATE functions for time-series analysis. The only two options are: non-Oracle DB which doesn’t support complex PARTITION BY queries or someone doesn’t want to create time dimension.

Also, there’re some very good discussions on the OBIEE Enterprise Methodology Group.

Good luck and enjoy your week.

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

Digest of some OBiEE errors (not necessarily NQSErrors)

A. “Ago function returning wrong results in answer when comparing this year versus last year” This actually happened to me once – and i thought it was an incorrectly configured time dimension. You can experience this error when your “Time Series functions gives incorrect results when leap years are involved”. Oracle support suggested the following action plan :

1) Leave the logical column definition as earlier i.e. Ago(Measure, Year, 1)
2) Change the filter condition in the request to filter on year and months instead of date range e.g.
year = 2009 and month in (1,2,3,4)

B. “Value Suppression doesn’t work for Level Based Measures”. Someone had a requirement where they wanted to use level-based measures for reports accessing several fact tables in the future. To realize a prototype before starting with the necessary reports they tried to implement an easy example to test the ‘value suppression’ functionality

Unfortunately they are not able to build a nice looking report with four simple columns showing the year, # of orders (per year), quarter and # orders. Their problem is that the level based measure ‘# of order (per year)’ is shown line by line. They wanted to suppress these values and only show the value once per year. They tried to use the ‘value suppression functionality’ without success. They were able to Work around this issues by using a Pivot Table.

C. This issue in pivot table is very common –

OBIEE says “governor exceeded error”. The pivot tables and the charts might give these errors:

Error Generating Chart
An exception occurred in the cube.
Error Details
Error Codes: MOJ5XVNL:QBVC92JY
Governor limit exceeded in cube generation (Maximum data records exceeded.)

and for pivot table

View Display Error
Governor limit exceeded in cube generation (Maximum data records exceeded.)
Error Details
Error Codes: QBVC92JY

Theses messages mean that users are trying to return more rows to the pivot table then the governor will allow. One needs to adjust the following parameters until the report runs successfully.

Adjust the parameters below in instanceconfig.xml (add those tags if you don’t have them – since those values are by default) and then restart Presentation Server (sawserver)

< CubeMaxRecords >40000< /CubeMaxRecords >
< CubeMaxPopulatedCells >150000< /CubeMaxPopulatedCells >

Quiet Time in OBIEE World

It’s been very quiet lately. Maybe because the summer is leaving and everyone is trying to take advantage of its latest days. I’m still learning my ways around newly updated Oracle’s MySupport. So far I have mixed feelings – I like the speed compared to metalink3, however, I’m still not sure if I get the new interface as well as flash-based navigation.

Tom Siebel got into problem with an elephant – but everyone probably knows about it by now. I wish him a speedy recovery.

I’ve been busy preparing environment for new project. Learning about configuring SSO for WNA-enabled security under Linux using OAS. Luckily for me, there’s a good discussion in regards to this here: http://forums.oracle.com/forums/thread.jspa?threadID=847808

Also, I’ve started re-reading “The Data Warehouse Toolkit”. It’s an awesome book.

I can’t dedicate enough attention to OTN anymore, but cheers to everyone who’s doing a great job of helping people to learn. I’m still about 15 questions away from 10th spot, so don’t relax too much Goran :-)

This is how top-10 looks like as of today:
Kishore Guggilla (2160)
Stijn Gabriels (1295)
John Minkjan (1175)
Turribeach (1155)
Madan Thota (1070)
gerardnico (925)
Christian Berg (805)
mma1709 (795)
David_T (775)
Goran O (680)

Good luck all.