An unhandled error has occurred.
Reload
X
UIZFORGE
Exams
Pricing
Career Paths
Resources
EN
Login
Sign Up
1
/ 5
Intermediate
A report needs to distinguish real NULL dimension values from subtotal NULL placeholders. Which related function should be considered?
Run one query per subtotal and union the results in the client.
Use ROW_NUMBER because ranking functions automatically create subtotal rows.
Use ROLLUP for hierarchy totals, CUBE for all combinations, GROUPING SETS for selected subtotal combinations, and GROUPING indicators when subtotal NULLs must be distinguished.
Use Search Optimization Service because it generates aggregates from indexed columns.
AI Tutor
Stuck? Get a hint
