Oracle 1z0-591 Exam Practice Questions (P. 4)
- Full Access (120 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #17
A user's BI Home page provides one-click access to which three options?
- ACreate new content
- BOracle BI online documentation
- CCatalog search functionality
- DDashboard layout editor
- EBusiness model metadata
Correct Answer:
ABC
See BI Home Page screenshot below:
Note: The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content.
From the BI home page users can browse and view the entire BI content. The BI catalog folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users.
Following content will be available under the BI catalog structure:
BI Publisher Reports (regardless of data source)
OTBI reports & dashboards -
OBIA dashboards & scorecards -
Financial Reporting -
Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard.
New reports created can be saved in BI catalog and added as embedded content within Fusion applications screens or links added to reporting pane. This enables users to extend the prebuilt embedded analytics within Fusion Applications.
ABC
See BI Home Page screenshot below:
Note: The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content.
From the BI home page users can browse and view the entire BI content. The BI catalog folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users.
Following content will be available under the BI catalog structure:
BI Publisher Reports (regardless of data source)
OTBI reports & dashboards -
OBIA dashboards & scorecards -
Financial Reporting -
Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard.
New reports created can be saved in BI catalog and added as embedded content within Fusion applications screens or links added to reporting pane. This enables users to extend the prebuilt embedded analytics within Fusion Applications.
Question #18
A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
- ABy creating a derived measure by using the Logical Columns available
- BBy creating a derived measure in the Column Mapping dialog box by using the physical table columns.
- CBy creating a derived measure by using Logic Columns available and changing the aggregation type
- DBy creating a derived metric by using the Expression Builder
- EBy creating a derived metric by using the Calculation Wizard
Correct Answer:
B
Note 1: OBIEE offers two calculation types for measure in the repository: logical physical
You can define calculations in either of the following ways:
* Before the aggregation, in the logical table source.
* After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)
Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.
B
Note 1: OBIEE offers two calculation types for measure in the repository: logical physical
You can define calculations in either of the following ways:
* Before the aggregation, in the logical table source.
* After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)
Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.
All Pages