Wednesday Feb 06, 2013

Identify Hierarchy level and value in OBIEE hierarchical Columns

This way we can navigate to the right target report based on the level we are at in the hierarchy.

This option would normally work for a balanced hierarchy.

[Read More]

Saturday May 12, 2012

Hide Refresh link for no results view for OBIEE 11g

Use the following workaround to remove the refresh link when the report has no data.Reports with results returned do not display the refresh links by default. The change will impact on all the reports; you cannot make changes only for a particular set of reports/dashboards.This is the solution for 11g

Do the following if you are not concerned with multiple languages (All messages will default to l_en if a language-specific version is not found)

  1. Navigate to $ORACLE_BI_HOME\Oracle_BI1\bifoundation\web\msgdb\l_en\messages
  2. Copy and rename viewmessages.xml to viewmessages.orig
  3. Edit the viewmessages.xml Locate: Refresh : <WebMessage name="kmsgEVCLinkRefresh"><HTML>Refresh</HTML></WebMessage>
  4. Remove the HTML section, so it'll read: <WebMessage name="kmsgEVCLinkRefresh"></WebMessage>
  5. Restart the OBIEE services

Tuesday Feb 21, 2012

Merging Geometry boundaries using Oracle spatial

Some times there is a requirement to merge two or more boundaries/borders into one, such as a custom region/territory. For eg. you may need to merge California, Oregon and Washington which are the states that comprise the Western US region. 

In  order to achieve this, I assume that you already have the state boundaries for California, Oregon and Washington. If not, you can get it easily on otn, that includes the standard boundaries. in the world_sample schema. Once you have this information you can use the Oracle Spatial function SDO_AGGR_UNION. Hence, you can combine several standard boundaries into a new region.

Below is an way how you would merge the states mentioned above into a new custom Western US region.

INSERT INTO custom_area SELECT 'Western US', SDO_AGGR_UNION(SDOAGGRTYPE(o.geometry, 0.5)) FROM wom_area WHERE iso_country_code = 'USA' and feature_type = 909996 and name in ('CALIFORNIA', 'OREGON', 'WASHINGTON');

Here, the SDOAGGRTYPE is an object that specifies the geometry column from the spatial table wom_area and the dimensional array.

Create the Geometry columns in Oracle Database

This spatial column that has been created can then be used in Mapviewer tool to plot the stores on the maps, which can then be used in OBIEE analysis.[Read More]
About

This Blog is a platform for discussing the various Oracle BI solutions and how they help the Enterprises to make better decisions.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today