Oracle Business Intelligence Suite Enterprise Edition (OBIEE) Quiz

Explanation
The correct answer is "Declare, Exception". In PL-SQL, an anonymous block starts with the DECLARE keyword, which is used to declare variables, constants, and cursors. The EXCEPTION section is used to handle any exceptions that may occur during the execution of the block. The RUN section is not a valid section in PL-SQL.

Explanation
The correct answer is Physical and Presentation. In the context of a .rpd file, the Physical layer represents the physical data sources and their structures, while the Presentation layer defines the business model and the way data is presented to users. The Cubical layer mentioned in the options is not a valid layer in a .rpd file.

Explanation
NQSCONFIG.INI is the correct answer because it is the file that specifies the current .rpd (Repository) to the BI Server. This file contains the configuration settings for the BI Server, including the location of the .rpd file. By specifying the .rpd file in the NQSCONFIG.INI file, the BI Server knows which repository to use for processing queries and delivering results. INSTANCECONFIG.XML is not the correct answer because it is a different configuration file that contains settings for the BI Server instance, such as port number and log file location. "None of the Above" is not the correct answer because NQSCONFIG.INI is the file that specifically specifies the .rpd file.

Explanation
Calculation Measures can be created using logical columns and physical columns. Logical columns are derived from existing columns in a dataset and are based on logical operations or calculations. Physical columns, on the other hand, are actual columns in the dataset that can be used for calculations. By utilizing both logical and physical columns, users can create calculation measures that provide meaningful insights and analysis based on the data available.

Explanation
In the presentation layer of .rpd, it is indeed possible to alter the sequence of columns within a table. This can be done to customize the way data is presented and organized in the user interface. By rearranging the sequence of columns, users can have a more convenient and intuitive view of the data.

Explanation
When using Answers, it is possible to create a filter on a column that is not included in the criteria. This means that you can apply a filter to a column that is not being used as a condition in the query or analysis. This can be useful in situations where you want to further refine your data by applying additional filters based on other columns that are not part of the initial criteria.

Explanation
The Column Selector view allows you to see results by being able to substitute one or more of the columns at runtime with other columns chosen beforehand. This means that you can dynamically change the columns displayed in the view, giving you flexibility in analyzing and comparing different sets of data. The Row Selector and None of the Above views do not provide this functionality.

Explanation
The View Selector allows you to see results by allowing you to change the view type at runtime. This means that you can easily switch between different views, such as a grid view or a chart view, to analyze and interpret the data in different ways. By using the View Selector, you have the flexibility to customize your view and gain insights from the data in a way that suits your needs.

Explanation
By adding multiple requests to the same dashboard, you can view all of them in one place. This allows for easy organization and monitoring of the requests you have created.

Explanation
Yes, it is possible to exclude a column from a pivot table without removing it from the criteria. This can be done by simply unchecking the box next to the column name in the pivot table field list. By doing this, the column will no longer be displayed in the pivot table, but it will still be included in the criteria for calculating the values in the table.

Explanation
BI publisher report templates are indeed made using MS-Word. MS-Word provides a user-friendly and familiar interface for creating and designing report templates. The templates created in MS-Word can then be uploaded and used in BI publisher to generate reports based on the data provided.

Explanation
Conditional formatting allows users to apply formatting rules based on certain conditions or criteria. By using conditional formatting, users can highlight specific data or apply specific formatting styles to data that meet certain conditions. In Answers, it is possible to add conditional formatting to reports, which enables users to visually emphasize important information or trends based on specific criteria. Therefore, the given statement is true.

Explanation
Creating hierarchies for all dimension tables in the business layer of the .rpd is not mandatory. Hierarchies are used to organize and structure data in a dimensional model, but not all dimension tables may have hierarchies. It depends on the specific requirements and structure of the data model. Therefore, the correct answer is False.

Explanation
In the business layer of the .rpd, creating a logical column is possible. This involves defining a new column that is not present in the physical data source but is derived from existing columns using calculations or expressions. Additionally, complex joins can also be performed in the business layer. These joins involve combining multiple tables or views using various join conditions and operators. Therefore, both creating logical columns and performing complex joins are valid actions that can be done in the business layer of the .rpd.

Explanation
In the BI Administration Tool, you can set the logging level for a user. This tool allows administrators to manage and configure various settings for the BI system, including logging levels. By setting the logging level, administrators can control the amount of detail that is recorded in the system logs for a specific user. This can be useful for troubleshooting and monitoring user activity within the BI system.

Explanation
In Oracle, "Column" is a valid column name for a table because Oracle allows column names to be any valid identifier, including keywords. Therefore, "Column" can be used as a column name without any issues.

Explanation
The character used to continue a statement in SQL*Plus is the hyphen (-). This character is used to indicate that the statement is continued on the next line.

Explanation
In BI publisher, a report can have multiple templates associated with it. This allows users to generate the same report in different formats or layouts based on their requirements. Each template can have its own design and formatting options, allowing for flexibility in generating reports. Therefore, the statement "A BI publisher report can have more than one template associated with it" is true.