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 - Subject Area / Presentation catalog


A subject area in Presentation Service is equivalent to a presentation catalog in BI Server.

In 10g, a difference was made between:

From 11g, no difference in the name is made and this two appellations are regrouped under subject area.

It's also the catalog/metadata that the client tools such as Presentation Service see when they made a connection.

Even though the Logical SQL requests from Answers and other clients query the presentation tables and columns, the real logic for entities, relationships, joins, and so on is in the Business Model and Mapping layer.

The primary function of the Presentation layer is to provide custom names, dictionary entries, organization, and security for different groups of users.

A subject area contains:

By default, it's created from one logical fact table and it's related dimension.

Multiple subject areas from one business model

Although each subject area must be populated with contents from a single business model, you can create multiple subject areas for one business model. For very large business models, you may want to do this to help users work with the content.

One important reason to use a custom Presentation layer is to make the schema as easy to use and understand as possible. Therefore, users should not be able to view columns that have no meaning to them. The following columns are examples of columns that you might want to remove from the Presentation layer:

  • Key columns that have no business meaning
  • Columns that users do not need to view (for example, codes, when text descriptions exist)
  • Columns that users are not authorized to see

Only for 11gUsers in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model.

Create Subject Area Function

In the BMM from the version 11g, you can now create automatically the subject area.

In a data warehousing environment

In a data warehousing environment, a subject area is a classification system that represents or distinguishes parts of an organization or areas of knowledge. A data mart is often developed to support a subject area such as sales, marketing, or geography.


A consideration to take when designing a subject area is to pay attention at the final user.

Do you design for a user:

  • that will use answer to perform ad hoc queries
  • or who will interact with the metadata via logical sql, dashboard and prompts.

Best Practices

  • Separate each level of a hierarchy in one presentation table
  • No more than 11 columns in a presentation table
  • Always two identifiers in the name of a column
  • Measures by type (Aggregation, Level Based, Time series)
  • Only columns that are used logically in the reports
  • Only one fact table (one combination of dimension values ie domain)
  • Set the Implicit Fact Column (to enable constraints in a dashboard prompt and may be limited choice in the filter wizard).



Each subject area have a privilege


Each subject area have a permission

  • Bookmark "OBIEE - Subject Area / Presentation catalog" at
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Digg
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Ask
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Google
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at StumbleUpon
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Technorati
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Live Bookmarks
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Yahoo! Myweb
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Facebook
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Yahoo! Bookmarks
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at Twitter
  • Bookmark "OBIEE - Subject Area / Presentation catalog" at myAOL
dat/obiee/subject_area.txt · Last modified: 2015/08/27 10:26 by gerardnico