{
  "uuid" : "5c44df30-daec-486e-af90-927bf7851058",
  "name" : "ssb_cube1",
  "description" : "",
  "dimensions" : [ {
    "name" : "SSB.PART_DERIVED",
    "table" : "SSB.PART",
    "column" : null,
    "derived" : [ "P_MFGR", "P_CATEGORY", "P_BRAND" ]
  }, {
    "name" : "C_CITY",
    "table" : "SSB.CUSTOMER",
    "column" : "C_CITY",
    "derived" : null
  }, {
    "name" : "C_REGION",
    "table" : "SSB.CUSTOMER",
    "column" : "C_REGION",
    "derived" : null
  }, {
    "name" : "C_NATION",
    "table" : "SSB.CUSTOMER",
    "column" : "C_NATION",
    "derived" : null
  }, {
    "name" : "D_YEAR",
    "table" : "SSB.DATES",
    "column" : "D_YEAR",
    "derived" : null
  }, {
    "name" : "D_YEARMONTH",
    "table" : "SSB.DATES",
    "column" : "D_YEARMONTH",
    "derived" : null
  }, {
    "name" : "D_YEARMONTHNUM",
    "table" : "SSB.DATES",
    "column" : "D_YEARMONTHNUM",
    "derived" : null
  }, {
    "name" : "D_WEEKNUMINYEAR",
    "table" : "SSB.DATES",
    "column" : "D_WEEKNUMINYEAR",
    "derived" : null
  } ],
  "measures" : [ {
    "name" : "_COUNT_",
    "function" : {
      "expression" : "COUNT",
      "parameter" : {
        "type" : "constant",
        "value" : "1",
        "next_parameter" : null
      },
      "returntype" : "bigint"
    },
    "dependent_measure_ref" : null
  }, {
    "name" : "TOTAL_REVENUE",
    "function" : {
      "expression" : "SUM",
      "parameter" : {
        "type" : "column",
        "value" : "LO_REVENUE",
        "next_parameter" : null
      },
      "returntype" : "bigint"
    },
    "dependent_measure_ref" : null
  }, {
    "name" : "TOTAL_SUPPLYCOST",
    "function" : {
      "expression" : "SUM",
      "parameter" : {
        "type" : "column",
        "value" : "LO_SUPPLYCOST",
        "next_parameter" : null
      },
      "returntype" : "bigint"
    },
    "dependent_measure_ref" : null
  }, {
    "name" : "TOTAL_V_REVENUE",
    "function" : {
      "expression" : "SUM",
      "parameter" : {
        "type" : "column",
        "value" : "V_REVENUE",
        "next_parameter" : null
      },
      "returntype" : "bigint"
    },
    "dependent_measure_ref" : null
  } ],
  "rowkey" : {
    "rowkey_columns" : [ {
      "column" : "LO_PARTKEY",
      "encoding" : "dict"
    }, {
      "column" : "C_CITY",
      "encoding" : "dict"
    }, {
      "column" : "C_REGION",
      "encoding" : "dict"
    }, {
      "column" : "C_NATION",
      "encoding" : "dict"
    }, {
      "column" : "D_YEAR",
      "encoding" : "dict"
    }, {
      "column" : "D_YEARMONTH",
      "encoding" : "dict"
    }, {
      "column" : "D_YEARMONTHNUM",
      "encoding" : "dict"
    }, {
      "column" : "D_WEEKNUMINYEAR",
      "encoding" : "dict"
    } ]
  },
  "signature" : "",
  "last_modified" : 1457503036686,
  "model_name" : "ssb",
  "null_string" : null,
  "hbase_mapping" : {
    "column_family" : [ {
      "name" : "F1",
      "columns" : [ {
        "qualifier" : "M",
        "measure_refs" : [ "_COUNT_", "TOTAL_REVENUE", "TOTAL_SUPPLYCOST", "TOTAL_V_REVENUE" ]
      } ]
    } ]
  },
  "aggregation_groups" : [ {
    "includes" : [ "LO_PARTKEY", "C_CITY", "C_REGION", "C_NATION", "D_YEAR", "D_YEARMONTH", "D_YEARMONTHNUM", "D_WEEKNUMINYEAR" ],
    "select_rule" : {
      "hierarchy_dims" : [ [ "C_REGION", "C_NATION", "C_CITY" ], [ "D_YEARMONTH", "D_YEARMONTHNUM", "D_WEEKNUMINYEAR" ] ],
      "mandatory_dims" : [ "D_YEAR" ],
      "joint_dims" : [ ]
    }
  } ],
  "notify_list" : [ ],
  "status_need_notify" : [ ],
  "partition_date_start" : 694224000000,
  "partition_date_end" : 3153000000000,
  "auto_merge_time_ranges" : [ 604800000, 2419200000 ],
  "retention_range" : 0,
  "engine_type" : 2,
  "storage_type" : 2,
  "override_kylin_properties" : {
    "kylin.storage.hbase.compression-codec" : "lz4",
    "kylin.cube.aggrgroup.is-mandatory-only-valid" : "true"
  }
}