Oracle Governed Analytics Professional with Oracle Analytics Cloud 1z0-1177-26 Question # 10 Topic 2 Discussion
1z0-1177-26 Exam Topic 2 Question 10 Discussion:
Question #: 10
Topic #: 2
A report designer needs to create interactive prompts in an Oracle Analytics Publisher (OAP) report to allow users to filter by sales region and a specific date. Which two parameter types would be most suitable?
A List of Values (LOV) mechanism and a Date parameter provide the appropriate controls for this requirement. For sales region, users should select from a predefined, controlled collection of valid business values rather than entering arbitrary text. In Publisher, this is normally implemented using a Menu parameter associated with an LOV . The LOV can contain fixed values or be populated dynamically through a SQL query, thereby ensuring that the regions presented to users correspond to valid source-data values.
For the specific-date requirement, Publisher provides the Date parameter type. A Date parameter exposes an appropriate date-selection interface and passes a date value to the underlying data set using the configured date datatype and Java date format.
Boolean parameters are intended for true/false-style conditions rather than selecting geographical members. Expression and XML are not the appropriate interactive parameter controls for these requirements. Technically, Oracle terminology treats the LOV as the value source associated with a Menu parameter; therefore, option C represents the intended region-selection mechanism in this question.
Reference Topic: Exploring and Creating Reports and Data Models in Oracle Analytics Publisher — Parameters and Lists of Values
===============
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit