Forum Discussion

saustermiller's avatar
saustermiller
New Contributor
1 day ago

BI Viewer drill down without hidden data items

I'm trying to create a drill down in a BI Viewer dashboard using only a data set return.  I can add a column (in this case "category") to both the Dimensions and Measures area.  I then enable the drill down under Data > Drill Down, however, once the drill down is active, the Category column is hidden on the output and won't show until you drill into a row.  I want to ability to drill into a row, but a user needs to see the Category column first before drilling. Is there a way for me to drill into a dataset without using "hidden" dimensions and measures for a column? 

Also - what is the difference between "Dimension" and "Measure"?  Thanks! 

 

BI Viewer
Reports

1 Reply

  • saustermiller's avatar
    saustermiller
    New Contributor
    1 day ago

    Answered my own question for Dimension vs Measure...

    In OneStream BI Viewer, dimensions are qualitative, descriptive data points (e.g., Entity, Account, Time, Scenario) used for grouping, filtering, and defining the structure (rows/columns) of a report. measures are quantitative, numerical data points (e.g., Sales, Amount) that are aggregated, summed, or calculated, forming the cell data in a grid or chart.

    Key Differences:

    • Function: Dimensions provide context (labels), while Measures provide values (metrics).
    • Behavior: Dimensions group data without summarizing. Measures perform summary calculations like Sum, Average, or Count.
    • Usage: In a Grid component, dimensions are typically assigned to row/column headers, while measures populate the cells.
    • Data Type: Dimensions are often strings or dates. Measures are numeric.

    For instance, in a sales dashboard, "Product Category" is a dimension, and "Total Revenue" is a measure.