axmo: "1.0"
name: Dimension from data
description: >-
  Recipe — a dimension whose elements come from the data. The model declares only the dimension's layers and
  its root; a dimension generator reads the customer list, places each customer under its segment, and the
  sales loader then fills the series. A new customer in the table appears in the model at the next update.
dimensions:
  Customers:
    type: categorical
    layers: [Top_Customers, Segment, Customer]
    tree:
      All_Customers: null
  Time:
    type: sequential
    sequentialType: axmo_time
    parameters:
      selected_levels: [month, quarter]
      start: "2027-01"
      end_mode: end_point
      end: "2027-03"
series:
  Sales:
    type: input
    description: Sales by customer and month, EUR.
    dimensions: [Customers, Time]
dataSources:
  Customer list:
    sourceType: excel-range
    rangeRef: Inputs!A1:B6
    hasHeaders: true
    shape: table
  Sales data:
    sourceType: excel-range
    rangeRef: Inputs!D1:F9
    hasHeaders: true
    shape: table
dataLoaders:
  Segments:
    type: dimensionGenerator
    source: Customer list
    target: Customers
    sourceColumn: Segment
    parentElement: All_Customers
  Customers:
    type: dimensionGenerator
    source: Customer list
    target: Customers
    sourceColumn: Customer
    parentColumn: Segment
  Load sales:
    type: seriesLoader
    source: Sales data
    target: Sales
    loadMode: table
    valueColumn: Sales
    duplicateHandling: BLOCK
    dimensionMappings:
      Customers: { column: Customer }
      Time: { column: Month }
outputRanges:
  Sales by customer:
    cell: Report!A1
    rowDef:
      blocks:
        - dimension: Customers/Customer
        - dimension: Customers/Segment
        - dimension: Customers/Top_Customers
    colDef:
      blocks:
        - dimension: Time/Month
        - dimension: Time/Quarter
        - series: Sales
          format: "#,##0"
          newLine: true
data:
  Inputs!A1:B6:
    values:
      - [Customer, Segment]
      - [Rossi Casa, Retail]
      - [Bianchi Store, Retail]
      - [Hotel Adige, Hospitality]
      - [Trattoria Arena, Hospitality]
      - [Verona Catering, Hospitality]
  Inputs!D1:F9:
    values:
      - [Customer, Month, Sales]
      - [Rossi Casa, "2027-01", 4200]
      - [Rossi Casa, "2027-02", 3900]
      - [Bianchi Store, "2027-01", 2800]
      - [Hotel Adige, "2027-01", 6100]
      - [Hotel Adige, "2027-03", 5800]
      - [Trattoria Arena, "2027-02", 1900]
      - [Verona Catering, "2027-03", 3300]
      - [Bianchi Store, "2027-03", 3100]