Oracle Governed Analytics Professional with Oracle Analytics Cloud 1z0-1177-26 Question # 29 Topic 3 Discussion
1z0-1177-26 Exam Topic 3 Question 29 Discussion:
Question #: 29
Topic #: 3
An author wants to change a column heading and control whether repeated values display in the results. Which two column formatting features should the author use?
A.
Use Content Paging to fetch a maximum of 5,000 rows
B.
Set value suppression behavior in Column Format
C.
Enable custom heading changes in Column Format
D.
Use Fixed Headers so headings remain visible while scrolling
The required capabilities are both available through Column Properties → Column Format . Custom Headings allows the report author to override the default folder or column heading presented in the analysis. This affects the displayed label without modifying the underlying semantic-model column definition. Oracle also permits variables and formatting to be incorporated into custom heading values where appropriate.
Value Suppression controls how consecutive duplicate values are displayed. When the same attribute value occurs repeatedly in adjacent result rows, suppression can display the value only once instead of repeating it on every row. This improves readability in analyses containing grouped or naturally repetitive dimensional data.
Content Paging concerns result retrieval and rendering rather than headings or duplicates. Fixed Headers keeps headings visible during scrolling but does not rename them. Save as Default has a different purpose and does not directly meet either stated requirement.
Oracle's documentation explicitly associates Custom Headings and Value Suppression with the Column Format tab, directly validating B and C.
Reference Topic: Managing and Creating Analyses, Views, and Content — Column Properties and Column Formatting
===============
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