Upgrade From OBIEE To OBIEE Features and changes 11G12c[13026] Error in getting roles from BI Security Service (nQSError: 12002, 12010)NQSError:15019 - Table @1%ls is functionally dependent upon level @2%ls[39008] Logical dimension table does not join to any fact source[39059] Logical dimension table has a source at level that joins to a higher level fact sourceAct as (Proxy user) FunctionalityActionAction Framework - How to create and invoke a Java Method (EJB)Administrator AccountAdministration Tool (admintool)Repository Admintool Object Copy/PasteHow to configure BI Server against the LDAP of ADSI ?(Weblogic|OBIEE 11G) - Active Directory (ADSI) Configuration(Ibot|Agent)Aggregate At Function"Aggregate By" FunctionAggregate (Navigation|Table|Content)Aggregate Persistence (Script)Aggregate Persistence Wizard (aka Data Mart Automation)Repository Aggregation rules based on dimension (dimension-specific aggregate)Aggregation RulePeriod to period comparison with the AGO Function Alias (synonyms)Answer/AnalyticsGrand Total Formatting in a Pivot viewApex IntegrationOracle BI Fusion Middleware ArchitectureAt Sign (@)(Presentation column|Attribute Columns)Authentication (ATN)AuthenticationAuthorizationBaseline columnBi-init.cmd (or on UNIX)BI Domain - The complete OBI SystemBI Server (Obis) (Architecture|Overview)Bi Server metrics functionsHome page (bieehome)BIP report integrationBIPlatform SchemaBiserverxmlcliBiserverxmlexec (RPD creation and patching)BiserverxmlgenBISQLProviderBISystemUserBlob data typeThe Business Model and Mapping (BMM)BottomN functionBriefing BookAll the cachesCache ManagerCalculated ItemCalculationCapacity planning / SizingCase When StatementCast as date - Which date format to use ?Cast(NULL as INTEGER)Catalog GroupCatalog ManagerCentral configuration through Fusion Middleware Control(Browser|Database|Third party product) CertificationChoose FunctionBI Server Clients (ODBC, JDBC)Client ToolsCluster (High Availability)Complex (Join|Operator) (Physical and Logical)ConditionsConditional FormattingConnectionConnection PoolConnection ScriptCopy Request Xml to ClipboardCosmetic Formatting (Style, Css)Count (and sometimes Sum)Criteria TabCurrencyDashboardEnable column sorting in DashboardsThe (dashboard|column) promptDashboard parameter prompt - The WHEN 1=0 or ifnull solutionHow to constraint the values of a dashboard prompt based on the selection of an other ?Dashboard Prompt with data level securityHow to create a prompt to handle a parameter ?Dashboard (Url|Link)Data FormatDatabase ObjectDatabase Features ParametersDatatypeHow to mix String and Number data type in one column and obtain a sum ?Date Datatype and FunctionsDbGateway (DB_GATEWAY_THREAD_RANGE)OBIEE / Weblogic 11G - (Create|Recreate) a default authentication provider (with administrator, ...)DeliversAdvanced Publication with Delivers (In Java)What means "Data is dense" ?Densification / Dimensions Preservation PossibilitiesDensification with the fact-based fragmentation capabilitiesLog Files (Oracle Diagnostic Logging - ODL)Dimension (Logical Table)Dimension fragmentation design to add an automatic filter with the choice of a columnIdentifying a Dimension TableHow to create a measure from data that is stored in a dimension tableDirect Database RequestTable Function/Stored Procedure in Direct Database Request(Display Function|Derived Measures) (Rank, TopN, Median, ...)Basic Discrete Distribution ReportDMS Metrics(Universe|Domain)Double column (Descriptor Id)Drilling (Down and Through)Driving TableDXE ExecutionEBS IntegrationEqualizing ObjectsEqualizerpds utilityEssbaseEvaluate - Embedded DB FunctionsEvent Pooling table (Event Table) to purge the cache after ETL processMicrosoft ExcelHow to create an HTML view (Narrative, Static Text) to get a good Excel formatting ?EXECUTE PHYSICAL CONNECTION POOL StatementOracle BI Server Execution EngineExtractprojects utilityFact table (of logical fact table)Defining a Non-Aggregated Measure (Baseline column) of a Fact TableIdentifying a Fact TableDefining the Logical Key of a Fact TableFederated Query / Multi-Database or Cross-Database JoinFilterConditional Filtering based on Presentation Service VariableHow to force a user to filter on a column A every time column B is in the requestPivot Measures (The Filter Function)Filter on current timeThe relative path fmapForeign Key or Physical Join (Fragment|ation) (Partitioning)Fragmentation Content, value-based, horizontal partitioningFact-based vertical partitioning/fragmentationAggregate Navigation with level-based fragmentationFull outer JoinFunctionsTime Series Conversion Functions : AGO and TODATEFunnel ViewGauge ViewGetting Started / TutorialThe Go URLGrain - Level of (summarization|aggregation)(Chart|Graph) View(Group|Security Role|Application Role)Aggregation rules in Logical SQL with the GROUP BY and BY clauseGUIDGuided NavigationHadoop HiveSAP HanaHardenXSS - Specifying Whether to Allow HTML Input in OBIPS FieldsDimension Hierarchy (logical dimensions)Level-based HierarchyHintHistoryHtml Content CachingHTML MarkupIbotVoid (Id)Repository Object IdentifierIframeIIS BI Presentation Service Plugin (OC4J listener)Where and how to call an image / picture ?ImpersonateImplicit Fact ColumnImport WizardHow to retrieve data from BI Server in Excel ?IndexCol Function - Handle hierarchy Level securityInitialization BlockInstallation / ConfigurationOracle Business Intelligence 11.1 Simple installation steps on Windows and OEL Linux 32 bitInstanceInstanceconfig.xml (Configuration Presentation Services)Integer DatatypeOracle BI Open Intelligence Interface (ODBC and JDBC) client connectivityMobile Application, Mobile DeviceIssue SQL (the IssueRawSQl Url)Java HostJavascriptJdbcOracle BI JDBC DriverJob ManagerJoinHow to model a bridge table (Many-to-Many relationship) with the joins property of a Logical Table ?Joins definitions in the repository (complex, foreign, logical table source)KPIPeriod to period comparison (YAGO, MAGO) with the analytical function Lag/LeadLast/First functionThe drop targets of a layout (view|pane)LDAP over SSL with Global Security Kit (GSKit)Left outer joinLogical levelConfigure Level Number of Elements in Dimensional HierarchiesLinux OEL 5 x86 Installation version system session variableLocalizationCommon Enterprise Information Model (CEIM) - The Logical Business Model (the three-layer metadata model)Logical ColumnLogical JoinLogical Request (before navigation)Logical SqlLogical TableLoginSetting a Query Logging LevelLookup FunctionLogical Table Source (LTS) (Physical and Logical Column Mappings)How to see the Physical SQL generated by a request in Presentation Service ?(Manage|Configure) Map DataBI Management PackMap ViewMapviewerOracle Marketing SegmentationMaster Detail(MDS|Metadata Service) (XML|XUDML)Measures (Columns|Attributes)Level-Based Measure CalculationsNested aggregate measureMerge RepositoryCustom MessagesGenerating and Deploying a Metadata DictionaryOracle BI DMS MetricsMonitoring - (Performance|Perfmon) (Metrics|Counter)Redirect to MonitoringReporting on Multiple Subject Area (Advanced Logical SQL)MultiUser Development Environment (MUDE - Projects)Narrative viewHow to set up a navigate interaction ?(Invoke|Navigate) to an URL (Web Page|HTTP Request)Data Navigation (Drill Down, Through, Link, ...)No Result ViewNQClient.exeNqcmd.exe ODBC Client ToolNqgenoldverrpd (Repository Downgrade)The nQuireID ( Authentication nqid )The Log Viewer (nQLogViewer)Nqquery.log (Query logging)Connection Pool Password ChangeNQSConfig.iniNQsError: 35008 - An error occurred while trying to check outNQServer.logAuthentication Web Service with SAWSessionService (nQSessionService)Nqudmlgen.exeHow to find the value, the data type of a Server variable ?How to define OBIEE to leverage SQL OLAP Query ?Oracle Warehouse Builder IntegrationThe answer PromptHow to customize the background color of a graphBackupHow to define a Many-to-Many relationship with a Bridge table ?How to connect remotely to the servers (BI, Presentation) ?Complement SoftwareFederated Query with Excel SheetHow to limit the number of records fetchHow to define a One to Many RelationshipNullArchitectureRss FeedScript to start Oracle BI Servers and Cluster ControllersOC4JOracle Call Interface (OCI) configurationODBCODBC ClientOracle BI ODBC driverHow to create an Analytics ODBC Data Source (System DSN ODBC connexion)BI Server (JDBC|ODBC) Driver FunctionsMicrosoft Office Server and (Add-in|Plug-In)Opaque ViewORA-00937 - Not a single-group group functionOuter JoinParameters (parameterized query)PasswordPatchIn-Place Upgrade - Patch Set Installation from version to version Upgrade - Moving from to Server PatchHow to redeploy the BI Presentation Service Plug-in (after a patch Installation, Don't forget to redeploy the WAR/EAR file)PDFPERF_PREFER_INTERNAL_STITCH_JOIN database featurePerformance Monitor (Perfmon)Repository PermissionPersist connection poolPhysical Alias Physical LayerPhysical SQLCross conditional formatting on a pivotHow to sort on a measure column of a pivot view ?How to sort on the column grand total value of a pivot view ?How to suppress detail rows of a master group in a pivot view ?How to pivot a character column ?Pivot ViewPlus ComponentsPopulate StatementPorts(Presentation Hierarchy|Hierarchical Column)Presentation LayerBI Presentation Service (SAW/OBIPS)Presentation Services ArchitecturePresentation Service (Query|Result|Cursor) CacheHow to install an other instance of Presentation Services on one Application Server (OC4J)Presentation Service Plug-inPresentation VariablesDatatype of a presentation variableDate Format in presentation variable, dashboard prompt and logical SQLHow to set a presentation variable ?Presentation Variable System (reserved variable)Where can I use a presentation variable ?Privilege packagePrivilegesProjects Release (Promotion|Migration) - From Dev, Test to ProductionPromptFully Qualified Name Object Identifier (Object Path)BI Server (Logical Query|Result) CacheLogical Query Result Cache ParametersPurging / Disabling the Query CacheWhy a Query is Not Added to the Query Cache ?Query CompilerQuery PlanQuery ProcessingRankRegular Expression (Regexp) and how to filter on string pattern ?How to model the different relationships ?Report-based TotalRepository (RPD file)Repository DesignObjects Import from another repositoryRequestRequest variableRight outer join(Row-wise|List of Values) server variableOracle BI Server XML API (XUDML)Running Sum (RSum)How to produce and show a total section on **each line** (Running total)?Usage Tracking S_NQ_ACCT TableS_NQ_INSTANCE tableS_NQ_SUMMARY_ADVISOR tableSA System subject areaSametaexport utility (Metadata Exchange)Installation Sample Application version 825Sample App V107SAP BWSASchInvoke (command line Triggering of Oracle BI Scheduler Jobs)Saw Url - Symbolic URL Parameters AppletHow to set a request/session variable using the Saw Url (Go/Dashboard)Presentation Services log (sawlog.log)ScalingBI SchedulerBI Scheduler Configuration (for Delivers)How to configure the Mail server of Scheduler/DeliversScorecards (and Strategy Management)SecuritySecuritySecurity (Level|Type)How to define the BI server security to add automatically a filter when a column is added to an answer (row security level)The Security ManagerSELECT_PHYSICAL statementsSelection Steps"Server Complex Aggregate" ruleInstalling Oracle BI Components on Different MachinesServer ThreadBI Server Variables (session and repository)How to set and use a server variable (system/repository) of type date ?Where can I use a BI Server variable (session/repository) ?SessionSession ManagerHow to set a server variable with the session type via a dashboard prompt (with a request variable) ?How and where can I set a Request variable (SET VARIABLE) ?How to define one different database credential for each user (the shared logon) ?Single table model.Look and feel Customizing (Style and Skin)OBIEE 11G ( - How to configure a new SkinOBIEE 10G/ - How to create a New Style and Skin ?Quick Skin and Style customizationData Source (Oracle Analytics Adapter)Special CharactersStarting Oracle Business Intelligence on WindowsHow to Start and Stop the services ?How to start and stop OBIEE automatically with a Bat file ?Static Text ViewStaticports.iniStitch Join (Intern Join Operations)Subject Area / Presentation catalogExalytics Summary Advisor(Error Correction) SupportSystem (Configuration) Management (Mbean)System session variables (reserved variables)How to perform a pivot in a table viewTable viewTemps filesHow to set up the time dimension (for time series functions Ago, Todate, ...) ?Time zoneTitle ViewTopNUDML(Upgrade|Refresh|Recover) GUIDUpgrade from the Sample App SampleSales 10gUpgrade ID (UID)Base URLPassing Filters through the Go and Dashboard URL(Usage Tracking|UT) (Query Log)Which Usage Tracking time measure should be used to gauge the performance of SQL retrieval time ?UserBI Server UtilitiesAll type of variablesVariable ManagerThe variable promptOBI VersionVersioningHow to control the use of the WITH CLAUSE and of STITCH Join ?ViewsVirtual Private DatabaseWeb Services API (SOAP,WSDL)The (Web|Presentation) Catalog (Webcat)Translate the WebCat (Dashboard, page and report names)WEBLANGUAGE system session variableHow to add a wiki to OBIEE (installation of a wiki on OC4J standalone)Windows Installation Version Services as Windows Services InstallationSSO Authentication with Windows Native Authentication (WNA)Writeback Capabilities (Table of Pivot)XMLHow to retrieve a result set with the XMLViewService WebService and the logical SQL ?


OBIEE 10g - Windows Installation Version


Steps on how to install OBIEE on Windows.



What Which permissions
Network Network Administrator
Windows System administrator
Database DBMS Administrator



Oracle Business Intelligence Enterprise Edition Version,, Rev. J requires Java 2 Platform Standard Edition 1.5.x. On IBM AIX, the version of JDK must be J2RE 1.5.0 IBM AIX build pap32devifx-20060310 (SR1) or higher.

Java 1.6 is not 100% backwards compatible with Java 1.5, and Replication uses functionality that’s in Java 1.5 and does not work the same way in Java 1.6. So running 1.6 will likely break charts, PDF and Webcat Replication.

Database connectivity software

For example, If the Oracle BI Server is to access an Oracle Database, install the Oracle 10g client. If the Oracle BI Server is to access MS SQL Server database, install Microsoft Data Access Components (MDAC).

Data Execution Prevention

Under Windows 2003 and Windows XP operating systems, DEP (Data Execution Prevention) is turned on by default for all Windows programs and services. Before you run the Oracle BI Infrastructure installer, turn off the Data Execution Prevention setting for all programs. To change the Data Execution Prevention setting (Windows 2003 and XP only) :

  • Depending on your operating system settings, use one of the following methods:
    • Windows XP menu: Go to Start > Control Panel > System > Advanced > Performance (Settings) > Data Execution Prevention.
    • Windows Classic menu: Go to Start > Settings > Control Panel > System > Advanced > Performance > Data Execution Prevention.
  • Switch DEP to Turn on DEP for essential windows programs and services only.
  • Reboot the machine.

Installation Steps

If you plan to install the Oracle BI Server and Oracle BI Presentation Services on two separate machines, read this article before selecting the component that you want : Installing Oracle BI Components on Different Machines

Run the installer on

Windows 7

When running the installer, you will get this message:

Oracle Business Intelligence is not supported on this Windows version. Oracle Business Intelligence is only
 supported on Windows XP x86, Windows 2003 x86, Windows 2003 AMD64, Windows 2003 EM64T, Windows Vista x86,
 Windows Vista AMD64, Windows Vista EM64T, and Windows 2000 x86.

OBIEE is then not supported and you have no other choice that to cancel the installation.

To be able to start the installer, you have to use the compatibility functionality of Windows 7. And even when you use this possibility, you can get this error:

The installer is unable to run in graphical mode. Try running the installer 
with the -console or -silent flag

Below is the procedure that I follow and which works for me:

  • Access the installation files.
  • right click on the setup.exe file and select the “troubleshoot compatibility” option.

  • Select the option 2 “Troubleshoot program”
  • Program Compatibility: Select the problem
    • The program worked in earlier version of Windows …
    • The program requires additional permisssions
  • Program Compatibility: Version; Select the version Windows Server 2003
  • Click the button “Start the program” and the first installer screen must appears.

Others windows version

  • Access the installation files.
  • To run the installer in graphics mode, run the program setup.exe.

Next Steps

The InstallShield window appears and prompts you through each screen.

  • The meanings and default for each screen and prompt for complete Oracle BI EE Infrastructure installation in graphics mode are listed in this Table

The instructions for a console mode installation are in the topic : Prompts for a Complete Oracle BI Installation (Windows) in Console Mode.

  • Provide the requested input for each screen.
  • To continue to the next screen, click Next. To return to a previous screen, click Back.

To view the help page for each screen, click Help.

  • At the end of the installation, restart your computer

Post Installation Tasks

Documentation / Reference

  • Bookmark "OBIEE 10g - Windows Installation Version" at
  • Bookmark "OBIEE 10g - Windows Installation Version" at Digg
  • Bookmark "OBIEE 10g - Windows Installation Version" at Ask
  • Bookmark "OBIEE 10g - Windows Installation Version" at Google
  • Bookmark "OBIEE 10g - Windows Installation Version" at StumbleUpon
  • Bookmark "OBIEE 10g - Windows Installation Version" at Technorati
  • Bookmark "OBIEE 10g - Windows Installation Version" at Live Bookmarks
  • Bookmark "OBIEE 10g - Windows Installation Version" at Yahoo! Myweb
  • Bookmark "OBIEE 10g - Windows Installation Version" at Facebook
  • Bookmark "OBIEE 10g - Windows Installation Version" at Yahoo! Bookmarks
  • Bookmark "OBIEE 10g - Windows Installation Version" at Twitter
  • Bookmark "OBIEE 10g - Windows Installation Version" at myAOL
dat/obiee/windows_installation.txt · Last modified: 2014/07/23 14:41 by gerardnico