图表中的编辑获取XML

Question

  <fetchcollection>
    <fetch mapping="logical" aggregate="true">
      <entity name="contact">
        <attribute groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" name="hpcrm_currentsegmentid" />
        <order alias ="new_rank" descending="false"/>
        <attribute alias="_CRMAutoGen_aggregate_column_Num_0" name="hpcrm_revenue" aggregate="sum" />
        <attribute alias="_CRMAutoGen_aggregate_column_Num_13" name="hpcrm_aum" aggregate="sum" />
        <attribute alias="_CRMAutoGen_aggregate_column_Num_14" name="hpcrm_revenuelastyear" aggregate="sum" />
        <link-entity name="hpcrm_businesstier" from="hpcrm_businesstierid" to="hpcrm_currentsegmentid" alias="aa" > 
        </link-entity>
      </entity>
    </fetch>
  </fetchcollection>
  <categorycollection>
    <category alias="_CRMAutoGen_groupby_column_Num_0">
      <measurecollection>
        <measure alias="_CRMAutoGen_aggregate_column_Num_0" />
      </measurecollection>
      <measurecollection>
        <measure alias="_CRMAutoGen_aggregate_column_Num_13" />
      </measurecollection>
      <measurecollection>
        <measure alias="_CRMAutoGen_aggregate_column_Num_14" />
      </measurecollection>
      <measurecollection>
        <measure alias="new_rank" />
      </measurecollection>
    </category>
  </categorycollection>

我正在生成图表，但要通过属性应用订单，该属性存在于该实体具有n:1关系的另一个实体中。这里new_rank属性存在于businesstier实体中。

<link-entity name="hpcrm_businesstier" from="hpcrm_businesstierid" 
  to="hpcrm_currentsegmentid" alias="aa" >

在这里，我加入了联系实体的业务层。

，但是当我尝试导入XML时，我会遇到无效的XML错误。

指定的XML文件" Revenue_aum当前segment.xml"是 无效XML或不符合图表模式

Answer 1

将您的订单语句移入链接实体的内部。不是您的查询，而是类似的内容：

<fetch mapping="logical" count="50" version="1.0">
    <entity name="account">
        <attribute name="accountnumber" />
        <link-entity name="account" from="accountid" to="parentaccountid">
            <attribute name="accountnumber" />
            <order attribute="accountnumber" />
        </link-entity>
    </entity>
</fetch>