We had to do a POC on some MS-SQL data. Instead of bringing an extra Oracle DB we used an existing MS-SQL instance.
1. Create a repository database:
We called ours “Repositories”
2. Enable case-sensitive collation
ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS
3. Enable Row versioning
ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON
4. Allow TCP/IP access to the database:
(Bounce the service if you changed it!)
4b. If you have a firewall running check if the ms-sql port is open (1433 for a default instance)
5. Create a user (fi: REP_OWN)
6. make the default database repositories:
7. Set (more...)
OBIEE is a great business intelligence tool but it is a one way highway. Users can use OBIEE to see the intelligence in the data but what if users want to put a few things of their own. I am presenting a mechanism to make OBIEE a 2 way highway
If you have missed it:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html ==> 188.8.131.52.0 is out
See the nice new features:
Till Next Time
Boris has set up an OBIEE blog in hebrew: http://obiee.co.il/.
Translatesd : http://translate.google.com/translate?sl=iw&tl=en&js=n&prev=_t&hl=en&ie=UTF-8&layout=2&eotf=1&u=http://iloug.org.il/BI/
For those of you who also have a non english OBIEE blog feel free to sent me a link and I will gladly advertise it here.
Till Next Time
For those of you having problems with the new FireFox 10 client. Michal Novy posted a solution on Christians Blog:
Hi, I found the way how to do a workaround:
1. type "about:config" into an address bar
2. right click anywhere and choose New / String
3. name it "general.useragent.override"
4. put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0"
5. refresh OBIEE login screen
Then it works without any problems!
Seems that Oracle is already working on some patches: see patch # 13564003 released by Oracle Support which repairs this limitation.
Till Next Time
Ranking is a very usual requirement of BI reporting. People tends to sort things in order and focus on the top performers. Which sales region is generating the most of revenue? What are my most popular products? Who are my best performing employees? All these type of queries can be easily answered via invoking the Rank() function on relevant fact measure.
What about "the other 80%" (Pareto Principle
)? We normally are not interested in the details of "insignificant" individual contributors. But the overall collective contribution of "the others" can be very valuable business information. One example can be (more...)
A few days ago, I was reviewing my prior post and something unusual caught my attention.
How come those densely populated suburbs in Sydney are not covered by the thematic view for postal areas??? In order to further confirm the issue, I moved the map around to another state and I found some thematic views are put on Tasman sea (see below)!!! I've got an alignment issue.
This is a critical issue for a BI Mapview as Business Intelligence are not accurately aligned with the real location on map. A few centimeters shifting of map theme (geometries that represents regions) (more...)
This article shows a method to improve the performance of the pivot view of OBIEE.
Assumption: We are working with the Oracle 11G rdbms system
Drawback: We will have to create one opaque view per pivot table. It is a bad practice to change repository for something related (more...)
Seems that Oracle is using there own standard for the Date Time format in the BIP quartz scheduler. They are not using standard ticks (starting on 1-jan-0001) but a milliseconds count starting on 1-jan-1970. So 1-Jan-2012 = 1325376000000. IE: a whole day is 86400000 ticks.
Till Next Time
In my last post, we discussed how OBIEE enables geospatial analysis on digital map. Now it’s time to get hands dirty and learn more from practice.
Out of the box, the deployment of OBIEE includes Oracle Mapviewer. However, no geospatial data or map tiles are provided with the product installation. Those can be acquired separately from NAVTEQ. A package of free sample NAVTEQ data with relevant deployment instructions can be downloaded from the URL: http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html
The free sample NAVTEQ data contains two components: geospatial data (coordinates, boundaries, etc) and map tiles (background images for different zoom level) (more...)
A client asked me if I could create an auto suggest prompt for him. (ie: Google Style Prompt). Basically he wanted an edit box prompt which would fill an suggestion box which he could tab trough to make the right selection.
1. Download the jQuery UI package here. Install it in your b_mozilla directory’s (or other webserver dirs you use).
2. Download (more...)
The script can be downloaded here: download COBIEEJS.
Copy the file to your b_mozilla directory’s (or other webserver dirs you use)
How to use it?
1. Add an edit box style prompt to your dashboard:
2. Add a textbox with:
<script src="res/b_mozilla/cobieejs. (more...)
One of the new feature of 11g is the AGGREGATE AT function. It uses the hierarchical level to pin the the aggregate. Problem is you can’t select a hierarchy level in the formula editor, so you have to some old school typing:
Only month 1 to 6 are selected.
Just like the BY statement you can do multiple levels from different Hierarchies:
Till Next Time
First of al the original inspiration for these “Golden Rules” Series are based on the “20 GOLDEN RULES FOR REPOSITORY DESIGN” from the people at Peak Indicators. Kudos to them.
The series contains:
The “rules” is this article are somewhat in random order
This is always a “work in progress” and please feel free to make any suggestions!
- use a transport folder.
Don’t allow all developers to place everything in all shared folders. Have them place it first in “transport” folder. Assign (more...)