Oracle BI EE 11g – Managing Host Name Changes

http://www.rittmanmead.com/2010/12/oracle-bi-ee-11g-managing-host-name-changes/

Oracle BI EE 11g – Managing Host Name Changes

December 7th, 2010 by Venkatakrishnan J

One common requirement when it comes to any software is in properly handling the network, ip and host name related changes. For example, moving servers from one domain to another, or cloning instances can all trigger these network related changes. BI EE 10g can quite easily handle the host-name related changes. But in the case of BI EE 11g as there are a lot of components involved, making a change to the host name requires more effort. In today’s blog post, lets look at how we can go about getting BI EE 11g to work when the Host Name of the machine changes post install & configuration.
BI EE 11g has a lot of inter-dependent components. Each component interacts with the other over the network i.e. using host names. Listed below are the components at a high level in 11g, which require changes whenever the host name changes.

1. Admin Server
2. Managed Server
3. Node Manager
4. RCU Schemas Connections
5. System Components
6. Hardcoded Host name entries in Repository, JDBC Connections etc
7. RCU Database Listener

mod_rewrite example

http://www.seocentro.com/articles/apache/mod_rewrite-seo-put-together.html

Options +FollowSymLinks -MultiViews
RewriteEngine On

#+---------------------------------
#+ Administrative redirection of specific non-problematic urls, 'standard' redirects
#+ should be placed here.
#+---------------------------------

# Redirect non-www and IP addresses to www.
RewriteCond %{HTTP_HOST} !^www.example.com$ [NC]
RewriteRule (.*) http://www.example.com/$1 [R=301,L]

# Redirect relocated urls to new direction.
RewriteRule ^oldpage\.html$ http://www.example.com/newpage.html [R=301,L]
RewriteRule ^directory/oldpage\.html$ http://www.example.com/directory/newpage.html [R=301,L]

# Redirect relocated directories to new directories.
RewriteRule ^olddir/(.*) http://www.example.com/newdir/$1 [R=301,L]

# Change dynamic urls to static urls.
RewriteRule ^widgets/(.*)/page(.*)\.php /widgets.php?cat=$1&page=$2 [L]

#+---------------------------------
#+ - BEGIN: URL fixup redirect routine
#+---------------------------------

# Get the requested URI, query string and hostname.
RewriteCond %{REQUEST_URI} ^(/[^?]*)([?].*)?$
RewriteRule . - [E=myUri:%1,E=myQuery:%2]

# Replace hmtl, htlm, and thml file extensions with html extension.
RewriteCond %{ENV:myUri} ^(.*)[.,](hmtl|htlm|thml)$ [NC]
RewriteRule . - [E=myRedirect:yes,E=myUri:%1.html]

# Replace comma(s) or multiple filetype delimiter periods in the url
# with a single period.
RewriteCond %{ENV:myUri} ^(.*)([,.]{2,}|,)((s?html?|php[1-9]?|aspx?|pdf|xls).*)$ [NC]
RewriteRule . - [E=myRedirect:yes,E=myUri:%1.%3]

# Remove invalid trailing characters
RewriteCond %{ENV:myUri} ^([/0-9a-z._\-]*)[^/0-9a-z._\-] [NC]
RewriteRule . - [E=myRedirect:yes,E=myUri:%1]

# Remove trailing punctutation
RewriteCond %{ENV:myUri} ^(.*)[._\-]+$
RewriteRule . - [E=myRedirect:yes,E=myUri:%1]

# Redirect direct client requests for anything/index.html to anything/.
RewriteCond %{ENV:myUri} ^(.*)/index\.html$ [NC]
RewriteRule . - [E=myRedirect:yes,E=myUri:%1/]

# Do the external 301 redirect only if needed and the resource exists
# at the corrected URI.
RewriteCond %{ENV:myRedirect} ^yes$ [NC]
RewriteCond %{DOCUMENT_ROOT}%{ENV:myUri} -f [OR]
RewriteCond %{DOCUMENT_ROOT}%{ENV:myUri} -d
RewriteRule . http://www.example.com%{ENV:myUri}%{ENV:myQuery} [R=301,L]

#+---------------------------------
#+ - END: URL fixup redirect routine
#+---------------------------------

mod_rewrite generator

http://www.generateit.net/mod-rewrite/

mod_rewrite checker

http://htaccess.madewithlove.be/

OBIEE Error 39008

OBIEE Error 39008

OBIEE Error 39008: Logical dimension table X has a source that does not join to any fact source.

I am using Oracle Business Intelligence 11.1.1.3.0 version to create a new repository. My usual procedure is to create a repository in iterative manner, developing a simple repository using some of the tables and finish a simple model and repository without adding too much of details. I keep adding more details with each subsequent iteration.  

I just finished my first iteration of repository development and it looks like this

OBIEE Reports and Dashboards Best Practices

http://obieesagar.blogspot.com/2013/01/obiee-reports-and-dashboards-best.html

 Dashboard - Performance

Practice Reasoning Avoid designing dashboards that return too much data Dashboards should show summary data with ability to drill into or link to detailed information with more reports. Avoid designing requests that use overly complex queries Derived metrics should be in the data source layer first, the metadata layer second, and report layer last. Use guided navigation to link to smaller dashboards Guided navigation can be set at the dashboard or at the report level. Ensure global filters have a default value Setting value to nothing or all will return all the data and impact performance. Setting a default values creates a smaller data set enhancing readability. All embedded reports on a dashboard issue their queries at dashboard load time Take this into consideration when choosing to embed large reports or link to them. Use multiple dashboard pages to separate large reports from each other when performance becomes an issue.

Migrate Enterprise Manager Application Roles and Weblogic Users and Groups between environments

http://adventuresinobiee.blogspot.com/2013/02/migrate-enterprise-manager-application.html

Managing users across environments, when using the built-in Weblogic LDAP was a tedious process. What I have found to work well is create the users once, and then have a script which caries them across to the rest of the environments. This has been very useful in our Development and Test environments when getting the users seeded.

The Enterprise Manager (EM) migration script utilizes a very cool java program that ArtofBI developed and posted to Github. I've tweaked the code a bit for my needs, so attached to this post also includes the modified javasource and complied JAR.

Continue after the break for links to the files, and example scripts for both Enterprise Manager and Weblogic.