2026 年 3 月 5 日：防止语义视图指标按特定维度聚合¶

如果某个指标不应按特定维度进行聚合，您现在可以在 CREATE SEMANTIC VIEW 命令的 NON ADDITIVE BY 子句中指定这些维度。

例如，要防止指标按某些日期维度进行聚合，请执行以下操作：

CREATE OR REPLACE SEMANTIC VIEW bank_accounts_sv
  TABLES (
    bank_accounts
  )
  DIMENSIONS (
    bank_accounts.customer_id_dim AS bank_accounts.customer_id,
    bank_accounts.account_type_dim AS bank_accounts.account_type,
    bank_accounts.year_dim AS bank_accounts.year,
    bank_accounts.month_dim AS bank_accounts.month,
    bank_accounts.day_dim AS bank_accounts.day
  )
  METRICS (
    bank_accounts.m_account_balance
      NON ADDITIVE BY (year_dim, month_dim, day_dim)
      AS SUM(balance)
  );

有关更多信息，请参阅 Identifying the dimensions that should be non-additive for a metric。