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.