Table

Table manifests describe tables bound to datasets. They control formatting, grouping, scenarios, and optional drilldown views.

Spec outline

apiVersion: bino.bi/v1alpha1
kind: Table
metadata:
  name: revenue_table
spec:
  dataset: revenue_by_customer
  tableTitle: "Top customers"
  filter: "region = 'DE'"
  order: ac1                         # category | categoryindex | rowgroup | rowgroupindex | ac1-4 | fc1-4 | pp1-4 | pl1-4
  orderDirection: desc
  measureScale: M
  measureType: currency              # volume | currency
  measureUnit: "EUR"
  internationalisation: "_system"
  internationalisationMode: "default"
  componentStatus: "ok"
  translation: "table.revenue.by_customer"
  categoryWidth: w25                 # w5 | w10 | w15 | w20 | w25 | w50 | inf
  dataFormat: decimal                # percent | decimal
  dataFormatDigitsDecimal: 1
  dataFormatDigitsPercent: 1
  grouped: true
  showGroupTitle: true
  showMeasureScale: true
  limit: 10
  type: list                         # list | sum | opt | sumnototal | optnototal
  scenarios: ["ac1", "py1"]
  variances: ["dpy1_ac1_pos"]
  barColumns: []                     # columns to render as inline bar charts
  unitScaling: 0.01                  # pixels per unit for absolute variance bars
  percentageScaling: 0.5             # pixels per percentage for relative variance pins
  thereof: []
  partof: []
  columnthereof: null
  scenariosDataFormat: "default"

Fields

• dataset – required dataset reference.
• tableTitle – optional human-readable title.
• filter, order, orderDirection – restrict and sort rows; using scenario names in order requires them to appear in scenarios.
• measureScale, measureType, measureUnit – control how measures are interpreted and displayed.
• categoryWidth – width of the category column (w5..w50, inf).
• dataFormat, dataFormatDigitsDecimal, dataFormatDigitsPercent – number formatting.
• grouped, showGroupTitle – group rows by rowgroup and optionally show group headers.
• showMeasureScale – toggle measure unit in table header.
• limit – maximum rows per group; extra rows are cumulated as REST.
• type – table type (list, sum, opt, sumnototal, optnototal).
• scenarios, variances – scenario measures and variances, similar to charts.
• barColumns – list of column names to render as inline IBCS-compliant bar charts instead of numbers.
• unitScaling – pixels per unit for absolute variance bars (d_ prefix columns). Default: 0.01.
• percentageScaling – pixels per percentage point for relative variance pins (dr_ prefix columns). Default: 0.5.
• thereof, partof, columnthereof – drilldown configuration.

Example: Grouped table with drilldown

---
apiVersion: bino.bi/v1alpha1
kind: Table
metadata:
  name: revenue_grouped_table
spec:
  dataset: revenue_detail
  tableTitle: "Revenue by segment and product"
  measureScale: M
  measureType: currency
  measureUnit: "EUR"
  grouped: true
  showGroupTitle: true
  categoryWidth: w25
  type: list
  limit: 5
  scenarios: ["ac1", "py1"]
  variances: ["dpy1_ac1_pos"]
  thereof:
    - rowGroup: "Revenue"
      category: "Applications"
      subCategory: "Applications-A"
  partof:
    - rowGroup: "Revenue"
      category: "Applications"
  columnthereof:
    - scenario: "ac1"
      name: "DE"
      subGroups: ["Berlin", "Hamburg"]

Inline bar chart columns

Render variance and scenario columns as inline IBCS-compliant bar charts using barColumns:

---
apiVersion: bino.bi/v1alpha1
kind: Table
metadata:
  name: revenue_with_bars
spec:
  dataset: revenue_by_segment
  tableTitle: "Revenue variance analysis"
  measureScale: M
  measureUnit: "EUR"
  scenarios: ["ac1", "pp1"]
  variances: ["dac1_pp1_pos", "drac1_pp1_pos"]
  barColumns: ["dac1_pp1_pos", "drac1_pp1_pos"]
  unitScaling: 0.02
  percentageScaling: 1

Bar chart types

Column prefix	Visualization	Description
d_ (absolute variance)	Horizontal bar	Bar extends left (negative) or right (positive) from center axis. Green for positive-good, red for negative-bad.
dr_ (relative variance)	Pin/dot chart	Thin colored line from axis with dot at end. Arrow for extreme values (>100%). Italic percentage label.
ac, pp, fc, pl (scenarios)	IBCS grayscale bars	AC: dark gray solid, PP: light gray solid, FC: dark gray hatched, PL: dark gray outlined.

Example: Scenario columns as bar charts

---
apiVersion: bino.bi/v1alpha1
kind: Table
metadata:
  name: scenario_bars
spec:
  dataset: quarterly_data
  tableTitle: "Quarterly comparison"
  scenarios: ["ac1", "pp1", "fc1"]
  barColumns: ["ac1", "pp1", "fc1"]