Altering the Banner Description Text and image in OBIEE 11g

Altering the Banner Description Text and image in OBIEE 11g:

Change the OBIEE11g Common portal header name open <MW_HOME>\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\productmessages.xml
Search for webmessage name=kmsgHeaderBIBrandName and change the text in <TEXT> </TEXT> tag.

To Alter the banner image, replace the oracle_logo.png image in the below directories:
./biapps/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/_WL_user/FMW Welcome Page Application_11.

OBIEE 11g – Gauge Chart – Number instead of Percentage






OBIEE 11g – Currency Prompt Issues

Issues Faced:

  1. The Currency Prompt did not appear when creating a new dashboard prompt
  2. The pre – built currency prompts were blank
  3. All the reports show “INVALID_CURRENCY” for the Amount Columns Used in the Graphs


Root Cause:

Connection Pool for  the database “Oracle BI Application Configuration”     (BIACM Repository Data)  is wrong.

– a) Oracle BI Application Configuration Connection Pool and b) Catalog



Update the DSN and the User / Passwords for the CM_DSN and CM_USER. (Repository Variables)



2014 in review

The stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 14,000 times in 2014. If it were a concert at Sydney Opera House, it would take about 5 sold-out performances for that many people to see it.

Click here to see the complete report.

OBIEE Get all users and roles from RPD

This sid how to get the users from the RPD. Taking that as a starting point it’s a small step to get users and the roles they have and put the export in an XLS:


‘Get all the users from a repository
‘1: Make an UDML export of the PRD using nqgenudml.exe
‘2: Change the filename/location in this script
‘3: Run the script from the command line cscript Read_Usergroups.VBS > users.txt
‘4: Put the export in a XLS Pivot table

Set objFSO = CreateObject(“Scripting.FileSystemObject”)
‘point this to your UDML EXPORT
Set objFile = objFSO.OpenTextFile(“E:\usergroup.txt”, ForReading)
Const ForReading = 1
Dim arrFileLines()
dim strRLine
dim strTemp1
dim strTemp2
dim strTemp3
dim intRoles
intRoles = 0
i = 0
Do Until objFile.AtEndOfStream
strRline = objFile.ReadLine
if left(strRline,12) = “DECLARE USER” then Redim Preserve arrFileLines(i)
strTemp1 = MID(strRLine ,15 , 50)
strTemp1 = MID(strTemp1 ,1 , instr(strTemp1, “”””)-1)
IF instr(strRline,”}” ) >0 THEN
strTemp2 = MID(strRLine , instr(strRline,”{“)+ 1, (instr(strRline,”}”) – (instr(strRline,”{“)+ 1)))
strTemp2 = “”
arrFileLines(i) = strTemp1 &”;” & strtemp2
intRoles = 1
i = i + 1
end if
if intRoles >= 1 then
if instr(strRline,”HAS ROLES (” ) >0 then
intRoles =2
end if
if intRoles =2 and instr(strRline,”HAS ROLES (” ) =0 then
strTemp3 = MID(strRline,instr(strRline, “”””)+1,50)
strTemp3 = MID(strTemp3,1,instr(strTemp3, “”””)-1)
WScript.Echo arrFileLines(i-1) &”;” & strTemp3 &”;1″
end if
if intRoles =2 and instr(strRline,”)” ) >0 then intRoles = 0
end if
end ifLoop



New Visualization options in Oracle BIEE 11g

New Visualization tools in Oracle Business Intelligence 11g:

Most of you must have used the new visualization tools available as part of Oracle BI foundation suite. However, I placed the content  here for the new bies :

Contribution Wheel: The Contribution Wheel is a new visualization available with the Oracle Scorecard and Strategy Management product, a part of the Oracle Business Intelligence Foundation Suite. It is a variation of the Scorecard Strategy Tree document type, and is an example of a space-constrained, hierarchical visualization. One of its unique advantages is that it makes it possible to view the relative weights assigned to a KPI or objective. At a glance, it is possible to see not only how much weight a particular KPI or objective contributes within its siblings at the same level, but also how much the specific KPI or objective contributes to the overall performance. This view is available as a rich, interactive visualization on desktop browsers as well as on mobile devices, where it supports touch and multi-touch gestural interactions.
Trellis views, also known as multi-panel visualizations, or grid-of-charts, are ideal for visualizing large datasets as well as multivariate data. Each cell in the grid can bevisualized as a microchart. A wide choice of visualizations is available to be used as these embedded visualizations. Both microcharts as well as traditional visualizations can be used. To make it easier for users to create these Trellis views, a choice of Simple and Advanced Trellis views is offered. These Trellis views are first-class views within the product, and therefore can participate in the full life-cycle of other views, and be published to Dashboards, and support drills, master-detail eventing, Actions, filters, scheduling, and more. And like other views, Trellis views are available as interactive views on the new Oracle BI Mobile app.

Micro Charts: A critical component of Trellis views in Oracle BI are the microcharts available. The types of microcharts available in Trellis views are SparkLine, SparkBar, and SparkArea. Microcharts are highly condensed graphics, and are very useful in visualizing the trend of a particular metric over time, across one or more dimensions. Trellis view microcharts support the ability to highlight the start, end, minimum, and maximum values. Trellis view microcharts support formatting and setting the size of the microchart, the color of the line or bar or area, etc… An intuitive layout editor facilitates quick customization of the
views via drag-and-drop actions

Original Document:

Line & Route Geo-Spatial Visualizations: Geo-spatial visualizations as first-class views in the BI suite. Apart from visualizing and formatting shapes and points, map views now support visualizing line also. Typical examples of line geometries include airline routes, rail traffic, highways usage, or even hurricane paths. These line geometries can be formatted using a point-and-click interface in Map Views, and a rich palette of colors is available for users to segment their data on. Users can combine shapes, points, and lines on the same map. For example, a color-fill can be used to display data at the state level, color-coded lines to format highway traffic for different state highways, while points can be used to format the toll collection at different toll booths across the highways. As with other views, users can click to get rich tooltips, drill, invoke master events, and Action Links on map view formats.

Additional Info via Feature Themes: Map views, as geo-spatial visualizations in Oracle BI are called, now support displaying non-BI information. It is very useful at times to bring in and display additional information on a map; information Not all information is available in a data warehouse that a BI system reports on. Sometimes additional context is useful to have. 

For example, when looking at retail store sales on a map, it would be useful to include a heatmap of income or demographics on the same map. Any number of such “feature” themes, can be included in map views, using a point-and-click interface. End-users can show or hide these layers with a click

Optimized and Available on Tablets: All these visualizations, like other views in Oracle BI, are also available on the Oracle BI Mobile app, without requiring any rewrite. These visualizations are optimized for interactions via touch and multi-touch gestures.

What Is the Recommended Visualizations Feature?

Oracle BI gives recommendation feature when the view are being created. When the create new view is being donw, a list of recommended view types are provided.

The recommended visualizations feature works by gathering information on your inputs for a view, such as number of dimensions, number of members, and so on. It then determines the optimal layout for each possible view.

This is an interesting and more useful features for the analysts and developers who are not sure which view would be best for the data set. Way to go !

Gartner Business Intelligence Summit 2014



The impact of analytics on business, society and our own personal lifestyles has been greater than anyone could have imagined. Transparent organizations have strengthened business relationships and created new revenue opportunities by making information available to customers, partners and suppliers. Advances in cognitive computing and predictive analytics have made information systems more decisive, enabling businesses to optimize millions of daily decisions. And the next phase is upon us, where personal analytics start to challenge existing business models by collecting precise data using social media monitoring and real-time sensors to personalize every customer experience. But as capabilities are stretched, how far is too far? When are targeted offers too personal? When do we need more human involvement in the algorithms making our decisions? How will you seize the opportunity, while mitigating the risks?


The markets for BI platforms, advanced analytics, DBMS for data warehousing, and BI and analytics service providers are highly dynamic with significant complexity for buyers. Gartner Magic Quadrants are a culmination of research in a specific market, giving you a wide-angle view of the relative positions of the market’s competitors. This is your chance to hear Gartner analysts at their best — unbiased, unscripted and unfiltered. It is also your chance to ask the questions that will help you with your investments.

Visit and Register to attend the event at

2013 in review

The stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 22,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 8 sold-out performances for that many people to see it.

Click here to see the complete report.

Start a DAC service only if it is down

For some reasons DAC service was going down. So we wanted a script that checks if the DAC service is down and start. When I simply started the DAC service and scheduled that batch file it was stopping the DAC service sometimes and then starting.

The below batch file can be used.

netstat -an | find “”
if ERRORLEVEL 1 goto stopped
if ERRORLEVEL 0 goto started
goto end
call “D:\orahome\10gR3_1\bifoundation\dac\startserver.bat”
goto end
goto end