In OBIEE 11g on Win 2008 R2 64 bit, running 32 bit OBIEE client (downloaded via OTN – Oracle Business Intelligence Developer Client Tools Installer (11.1.1.3.0)). The ‘Open’ Button to open a RPD in online mode is disabled. Even after giving exact login credentials, ‘open’ button but is disabled. However, opening the RPD in offline… [Continue Reading]
Five ways Oracle Exalytics is “different” from SAP HANA
ASCENTT Sessions at Oracle Open World 2011

ASCENTT is honored to be speaking at two Open World sessions featuring innovative Business Intelligence and Analytics solutions on Tuesday October 4th. Real Time Business Intelligence and Analytics using Oracle GoldenGate for CRM and ERP Applications SESSION 30260 | TUESDAY, OCTOBER 4TH | 10:15AM | MOSCONE WEST 2002/2004 Does your business work in a real… [Continue Reading]
Repeating Numeric Values in Pivot View Chart

Sometimes Vertical Axis in OBIEE 11g Pivot View Chart Displays Repeating Numeric Values. When running OBIEE 11g (11.1.1.3) with a pivot view and vertical axis chart, the data labels and tick marks on the vertical scale are showing repeating values. For example, when 0, 1, 2, 3, 4 are expected, it may show 0, 1,… [Continue Reading]
External Authentication that Worked in OBIEE 10g Fails in OBIEE 11g
When logging on to OBIEE 11g using external table authorization, you are not able to see any of your privileges and do not receive access to any dashboards. However, you are able to log on. Any users created directly in Weblogic/FMW/BI can see dashboards. In OBIEE 10g, those users authenticated using external table authorization were… [Continue Reading]
Increasing Slider Value Limit
Today let’s work on How to increase slider value limit of 50 to 100 in OBIEE 11.1.1.5? 1. You need to manually modify the instanceconfig.xml in (example) <OBIEE11G>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 2. Please make a backup copy of this file before making any changes as you may risk not being able to start BI service 3. Add the… [Continue Reading]
Generating Metadata dictionary in OBIEE 11g

The following steps explain on how to generate a metadata dictionary in OBIEE 11g (11.1.1.3): 1) Open the RPD using OBIEE Admin tool in offline mode. Navigate to Tools > Utilities > Generate Metadata Dictionary > Execute (Execute button will be enabled only when Generate Metadata Dictionary is hightlighted). Specify a directory name with no… [Continue Reading]
Dealing with ‘log’ files
This is the blog about ’How to review the information in the log files for Oracle Business Intelligence (OBIEE) 1.1.1.3.0 version.’ You can check the different log files in OBIEE using the Enterprise Manager (EM) Console page but you can also review directly the files in the hard disk. a) EM Console. Log in to… [Continue Reading]
Modifying the Colors Available in a Chart
In OBIEE 10g it was possible to set the color attributes for a chart by modifying palette.cxml file.How can you do this in OBIEE 11g? Edit following file <Oracle_BI1>\bifoundation\web\msgdb\s_blafp\viewui\chart\dvt-graph-skin.xml Add lines after </SliceLabel> to specify the colours. Here is an example giving a range of colours: <SeriesItems> <Series id=”0″ color=”#4a9cd9″ borderColor=”#4a9cd9″/> <Series id=”1″ color=”#f68e55″ borderColor=”#f68e55″/> <Series… [Continue Reading]