schema如下:
<?xml version="1.0" encoding="UTF-8"?>
<Schema name="tezz">
<Cube name="Sales">
<!-- 事实表(fact table) -->
<Table name="sale" />
<!-- 客户维 -->
<Dimension name="khxb" foreignKey="cusId">
<Hierarchy hasAll="true" allMemberName="syxb" primaryKey="cusId">
<Table name="customer"></Table>
<Level name="gender" column="gender"></Level>
</Hierarchy>
</Dimension>
<!-- 产品类别维 -->
<Dimension name="cplb" foreignKey="proId">
<Hierarchy hasAll="true" allMemberName="sycp" primaryKey="proId" primaryKeyTable="product">
<join leftKey="proTypeId" rightKey="proTypeId">
<Table name="product" />
<Table name="producttype"></Table>
</join>
<Level name="proTypeId" column="proTypeId"
nameColumn="proTypeName" uniqueMembers="true" table="producttype" />
<Level name="proId" column="proId" nameColumn="proName"
uniqueMembers="true" table="product" />
</Hierarchy>
</Dimension>
<Measure name="s1" column="number" aggregator="sum" datatype="Numeric" />
<Measure name="zxse" aggregator="sum" formatString="¥#,##0.00">
<!-- unitPrice*number所得值的列 -->
<MeasureExpression>
<SQL dialect="generic">(unitPrice*number)</SQL>
</MeasureExpression>
</Measure>
<CalculatedMember name="pjdj" dimension="Measures">
<Formula>[Measures].[zxse] / [Measures].[sl]</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="¥#,##0.00" />
</CalculatedMember>
</Cube>
</Schema>
如上,如果客户维【khxb】和产品类别维度【cplb】分别在不同的数据库中,schema应该如何定义呢?求大牛们指教。