OBI flashcards
OBI · Build recall with a focused review session.
32 cards. Read the term and the definition here. The deck at the top of this page is optional.
- BI Server
- Central Oracle BI component that parses logical SQL, generates and executes physical queries against data sources, and returns result sets to clients.
- Presentation Services
- Web tier component that renders dashboards and analyses, stores catalog objects, and communicates with the BI Server over ODBC.
- RPD repository file
- Binary file containing the Physical, Business Model and Mapping, and Presentation layers; edited with the Administration Tool.
- BI Scheduler
- Service that runs scheduled agents and jobs, storing job metadata in the Scheduler schema and delivering results via email or FTP.
- JavaHost process
- Process that handles charting, graphing, and some BI Publisher rendering; called by Presentation Services for graph generation.
- Logical SQL
- Query language used by clients to communicate with the BI Server; it references presentation columns and is translated into physical SQL.
- Physical layer
- Repository layer containing physical tables, columns, joins, keys, and connection pools that map to source databases.
- Business Model and Mapping
- Repository layer containing logical tables, columns, joins, measures, and business logic such as aggregation rules and calculations.
- Logical table sources
- Multiple sources for a logical table with priority and fragmentation rules; the BI Server selects the cheapest source for a query.
- Aggregation rule
- Property on a logical column (SUM, COUNT, AVG, MIN, MAX) that tells the BI Server how to roll up measures across dimensions.
- Session variable
- Variable populated at login by an init block; referenced in queries as VALUEOF(NQ_SESSION.varname) and used for row-level security.
- Time dimension
- Logical dimension with levels such as Year, Quarter, and Month that enables to-date and period-ago calculations.
- Subject area
- Presentation layer object that groups columns into folders and appears as a queryable area in Analyses and dashboards.
- Presentation column
- Column exposed to users; it can be renamed independently of the BMM and has display formatting and sort order settings.
- Implicit fact column
- Presentation layer setting that defines a default fact column when a query includes only dimension columns.
- Repository merge
- Administration Tool utility that combines two RPDs into one, resolving conflicts per object and preserving both sets of changes.
- Analysis
- Query built from a subject area in Answers; contains columns, filters, views, and formatting, and can be saved to the catalog.
- Dashboard prompt
- UI control on a dashboard that sets presentation variables, which analyses reference as @{varname} to filter results.
- Agent (ibot)
- Scheduled job that runs an analysis and delivers results via email, FTP, or the catalog under the Scheduler service.
- View selector
- Dashboard object that lets users switch between multiple views of the same analysis without leaving the dashboard.
- Conditional formatting
- Analysis feature that applies color, icons, or other formatting to a column based on a condition evaluated per row.
- Application role
- Role defined in the RPD and WebLogic console that controls access to Presentation Services features and privileges.
- Data filter
- Row-level security predicate attached to a logical table; it restricts rows a user or group can see in queries.
- Init block
- Repository object that runs SQL at login to populate session variables, often used for user-specific row-level security.
- Manage Privileges
- Presentation Services page that controls which users and application roles can perform actions such as creating dashboards or agents.
- LDAP authentication
- Authentication option configured in the Administration Tool that validates user credentials against an LDAP directory server.
- Query cache
- BI Server cache of result sets stored in memory and on disk, keyed by logical SQL and session context to speed repeated queries.
- Cache seeding
- Process of pre-populating the query cache using cache seed or event polling so that common queries return quickly.
- Aggregate navigation
- BI Server behavior that rewrites a query to use a pre-aggregated logical table source instead of the detailed fact table.
- Fragmentation
- Logical table source setting that splits a large table by date or region so the server queries only relevant partitions.
- Connection pool
- Physical layer object that manages a set of connections to a data source, with minimum and maximum connection limits.
- BI Publisher integration
- Configuration that registers BI Publisher as a server in the RPD, enabling its reports to appear in dashboards.