- 1 Minute to read
- Print
- DarkLight
- PDF
Dynamic Reports_Managing Precedence
- 1 Minute to read
- Print
- DarkLight
- PDF
Use Precedence in Report Sets to control which definitions (line types, data formats, formulas, calculations) win at the cell intersection of Row and Column sets in Dynamic Reports. By default, Row precedence applies when a report uses Report Sets.
Set Column and Row Precedence
Go to Reports.
Open a Dynamic Report that uses Report Sets.
Double‑click the Column Set (or Row Set) used in the report to edit.
On the line you want to affect, set Precedence to Column to override row settings (or set to Row to keep row precedence).
Save the Report Set.
Run the Dynamic Report to see the changes.
Control What Your Formatting Applies To
Go to Reports and open your Report‑set‑based Dynamic Report.
Double‑click the Row Set or Column Set to edit.
On the target line, set Apply On to one of:
Header – format headers only
Data – format data only
Header + Data – same format for both
Separate Header & Data – different formats for header vs. data
Format in the right place:
Use the Line tab for header formatting.
Use the Data tab for data formatting.
Save the Report Set.
Run the report.
Troubleshooting Checklist
Percentages show incorrectly
On the line with the percentage formula, set Precedence (column N) to the desired option (Row or Column).
Formatting doesn’t appear as expected
On that line, adjust Precedence (column N).
Also check Apply On (column M) and set to Header or Data to match your intent.
How Precedence Resolves in Reports
When both Row and Column define something for the same cell, the “Result” below is applied:
Row Set | Column Set | Result |
---|---|---|
Row | Row | Row |
Column | Column | Column |
Row | Column | Column |
Column | Row | Row |
Row | Hierarchy (dimension) Member | Row |
Column | Hierarchy Member | Default (no formatting) |
Hierarchy Member | Row | Default |
Hierarchy Member | Column | Column |
Hierarchy Member | Hierarchy Member | Default |
Tip: A “Hierarchy Member” line refers to a member‑level formatting rule in a Row or Column set.
Precedence with Other Report Features
Conditional Formatting (column R)
Rule: Conditional formats are applied on Column Sets and take precedence over Rows.
Practical outcomes:
If only the Column Set has conditional formatting, it applies.
If both Row and Column Sets have conditional formatting, the Column’s conditional format wins.
Page Breaks (column O)
If configured on Row or Column, the page break applies to that artifact.
If configured on both, the page break applies to both.
Excel Formulas & Formula Exceptions (in Report Sets)
If formulas/formula exceptions exist on both Row and Column, Column takes precedence at the intersection.
Mixed Definitions (MDX lines, Excel formulas, formula exceptions)
In combinations of Row‑vs‑Column definitions (e.g., Row MDX vs Column Excel formula), Column takes precedence.