免费开发工具 · Apache Ossie / Dosi

Apache Ossie 转 Cube 语义模型转换器

将 Apache Ossie YAML 导出为 Cube 模型定义。检查关联、维度和度量，编辑生成文件并下载模型文件组。

无需注册 · 内置测试样例 · 离线转换检查

转换工作台

源文件1样例

Omni Sales · ANSI_SQL

omni_sales.yml

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.

# yaml-language-server: $schema=../../../../core-spec/ossie-schema.json
#
# Fixture A -- all-native round-trip (Ossie -> Omni -> Ossie).
# Star schema; every construct maps to a native Omni slot. Documented
# normalizations on the Ossie -> Omni -> Ossie trip: relationship names are
# regenerated (`<from>_to_<to>`), and unique_keys that merely restate the
# primary key are absorbed by it.

version: "0.2.0.dev0"

name: sales
description: Sales orders with customer attributes
ai_context:
  instructions: "Use this model for order analysis."
datasets:
  - name: orders            # fact: no incoming relationship -> topic base_view
    source: samples.tpch.orders
    primary_key: [o_orderkey]
    description: One row per order
    fields:
      - name: o_orderkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_orderkey
        description: Order identifier
      - name: o_custkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_custkey
      - name: o_orderdate
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_orderdate
        label: Order Date
        dimension:
          is_time: true
        ai_context:
          synonyms: [order date, date]
      - name: o_totalprice
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: o_totalprice
  - name: customer
    source: samples.tpch.customer
    primary_key: [c_custkey]
    fields:
      - name: c_custkey
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: c_custkey
      - name: c_name
        expression:
          dialects:
            - dialect: ANSI_SQL
              expression: c_name
        description: Customer name
relationships:
  - name: orders_to_customer
    from: orders
    to: customer
    from_columns: [o_custkey]
    to_columns: [c_custkey]
metrics:
  - name: total_revenue
    expression:
      dialects:
        - dialect: ANSI_SQL
          expression: SUM(orders.o_totalprice)
    description: Total order revenue
    ai_context:
      synonyms: [revenue, sales]
  - name: order_count
    expression:
      dialects:
        - dialect: ANSI_SQL
          expression: COUNT(*)
    description: Number of orders

源文件仅保留在内存中，请一并上传所有被引用的文件。查看原始样例

结果

选择目标平台并转换，在此预览临时文件。

点击转换时，当前源文件将发送至 Datus 服务器；不会连接数据仓库或执行 SQL。

此转换器的用途

由 Apache Ossie YAML 生成 Cube 模型定义。工作台默认打开导出方向、选择 Cube 目标，并加载可编辑的销售模型。

来源格式

Apache Ossie YAML，以及已部署转换器支持的 Dosi 扩展。可以先检查内置销售样例的结构，再上传自己的模型。

生成产物

供检查并集成到自己项目的 Cube 模型文件。多文件结果通过 ZIP 保留相对路径与当前编辑。

转换步骤

检查 Ossie 销售模型，或上传支持的 YAML 来源。
核对 Cube 目标，填写目录显示的必填配置。
转换后检查文件树、维度、度量和关联。
下载定义，集成到自己的 Cube 项目，并比较代表性查询结果。

使用产物前需要检查的事项

产物不会配置 Cube API 服务、缓存、数仓凭据或部署。

保留原 Ossie 模型，替换现有 Cube 定义前先阅读目标诊断。

继续探索

常见问题

Ossie 转 Cube 接受什么来源文件？

以 Apache Ossie YAML 模型为输入，可包含支持的 Dosi 扩展。预填充销售样例便于先检查输入，再上传自己的定义。实际输出选项由已部署的目标目录决定。

Cube 导出是否包含服务与缓存配置？

工具转换支持的语义定义，不会配置 Cube 服务、缓存、连接凭据或部署。请检查产物，补充自己的 Cube 项目所需环境配置，并验证代表性查询。

如何下载生成的多个 Cube 文件？

选择“下载到本地”，通过 ZIP 保留相对路径和当前编辑。替换现有 Cube 定义前，请检查诊断与目标模型。