2123452351388140
<pack class='dataengine' dbname='Data/Datasources/Sample - Superstore Sales Multi-language (Extract).tde' ec-abstract-query='&lt;aq-cache-key are-all-local-sorts-supported=&apos;true&apos; has-agg-measure-filters=&apos;false&apos; has-lod-calcs=&apos;false&apos; has-user-reference=&apos;false&apos; ind-join-semantics=&apos;false&apos; start-of-week=&apos;sunday&apos; version=&apos;10.0&apos;&gt;&#10;  &lt;query aggregation=&apos;true&apos; caching=&apos;normal&apos; hierarchize-rows=&apos;false&apos; include-empty=&apos;false&apos;&gt;&#10;    &lt;fields&gt;&#10;      &lt;field column=&apos;[Sample - Superstore - English (Extract)].[Continent]&apos; /&gt;&#10;      &lt;field column=&apos;[Sample - Superstore - English (Extract)].[Product Category]&apos; /&gt;&#10;      &lt;output column=&apos;[Sample - Superstore - English (Extract)].[Continent]&apos; /&gt;&#10;      &lt;output column=&apos;[Sample - Superstore - English (Extract)].[Product Category]&apos; /&gt;&#10;      &lt;output column=&apos;[Sample - Superstore - English (Extract)].[sum:Profit:ok]&apos; /&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[Sample - Superstore - English (Extract)].[yr:Order Date:ok]&apos;&gt;&#10;        &lt;groupfilter from=&apos;2011&apos; function=&apos;range&apos; level=&apos;[yr:Order Date:ok]&apos; to=&apos;2013&apos; user:ui-domain=&apos;relevant&apos; user:ui-enumeration=&apos;inclusive&apos; user:ui-marker=&apos;enumerate&apos; /&gt;&#10;      &lt;/filter&gt;&#10;    &lt;/fields&gt;&#10;  &lt;/query&gt;&#10;  &lt;relation-xml&gt;&amp;lt;relation connection=&amp;apos;Sample - Superstore - English (Extract)leaf&amp;apos; name=&amp;apos;Extract&amp;apos; table=&amp;apos;[Extract].[Extract]&amp;apos; type=&amp;apos;table&amp;apos; /&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10;  &lt;relation-names&gt;&#10;    &lt;relation-name key=&apos;[Bestellpriorität]&apos; value=&apos;[Extract].[Bestellpriorität]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Categoria do produto]&apos; value=&apos;[Extract].[Categoria do produto]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Categoría de producto]&apos; value=&apos;[Extract].[Categoría de producto]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Catégorie de produit]&apos; value=&apos;[Extract].[Catégorie de produit]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[City]&apos; value=&apos;[Extract].[City]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Contenedor de productos]&apos; value=&apos;[Extract].[Contenedor de productos]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Continent]&apos; value=&apos;[Extract].[Continent]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Country]&apos; value=&apos;[Extract].[Country]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Customer ID]&apos; value=&apos;[Extract].[Customer ID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Customer Name]&apos; value=&apos;[Extract].[Customer Name]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Customer Segment]&apos; value=&apos;[Extract].[Customer Segment]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Discount]&apos; value=&apos;[Extract].[Discount]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Embalagem do produto]&apos; value=&apos;[Extract].[Embalagem do produto]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Emballage du produit]&apos; value=&apos;[Extract].[Emballage du produit]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Kundensegment]&apos; value=&apos;[Extract].[Kundensegment]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Mode d&amp;apos;expédition]&apos; value=&apos;[Extract].[Mode d&amp;apos;expédition]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Modo de envio]&apos; value=&apos;[Extract].[Modo de envio]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Modo de envío]&apos; value=&apos;[Extract].[Modo de envío]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Number of Records]&apos; value=&apos;[Extract].[Number of Records]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Ordenar prioridad]&apos; value=&apos;[Extract].[Ordenar prioridad]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Order Date]&apos; value=&apos;[Extract].[Order Date]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Order ID]&apos; value=&apos;[Extract].[Order ID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Order Priority]&apos; value=&apos;[Extract].[Order Priority]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Postal Code]&apos; value=&apos;[Extract].[Postal Code]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Prioridade do pedido]&apos; value=&apos;[Extract].[Prioridade do pedido]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Priorité de commande]&apos; value=&apos;[Extract].[Priorité de commande]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Base Margin]&apos; value=&apos;[Extract].[Product Base Margin]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Category]&apos; value=&apos;[Extract].[Product Category]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Container]&apos; value=&apos;[Extract].[Product Container]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Name]&apos; value=&apos;[Extract].[Product Name]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Product Sub-Category]&apos; value=&apos;[Extract].[Product Sub-Category]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Produkt-Subkategorie]&apos; value=&apos;[Extract].[Produkt-Subkategorie]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Produktkategorie]&apos; value=&apos;[Extract].[Produktkategorie]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Produktverpackung]&apos; value=&apos;[Extract].[Produktverpackung]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Profit]&apos; value=&apos;[Extract].[Profit]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Quantity ordered new]&apos; value=&apos;[Extract].[Quantity ordered new]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Region]&apos; value=&apos;[Extract].[Region]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Row ID]&apos; value=&apos;[Extract].[Row ID]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Sales]&apos; value=&apos;[Extract].[Sales]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Segment client]&apos; value=&apos;[Extract].[Segment client]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Segmento de cliente]&apos; value=&apos;[Extract].[Segmento de cliente]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Segmento do cliente]&apos; value=&apos;[Extract].[Segmento do cliente]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Ship Date]&apos; value=&apos;[Extract].[Ship Date]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Ship Mode]&apos; value=&apos;[Extract].[Ship Mode]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Shipping Cost]&apos; value=&apos;[Extract].[Shipping Cost]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Sous-catégorie de produit]&apos; value=&apos;[Extract].[Sous-catégorie de produit]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[State or Province]&apos; value=&apos;[Extract].[State or Province]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Subcategoria do produto]&apos; value=&apos;[Extract].[Subcategoria do produto]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Subcategoría de producto]&apos; value=&apos;[Extract].[Subcategoría de producto]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Unique cust loc]&apos; value=&apos;[Extract].[Unique cust loc]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Unit Price]&apos; value=&apos;[Extract].[Unit Price]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Versandart]&apos; value=&apos;[Extract].[Versandart]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[产品子类别]&apos; value=&apos;[Extract].[产品子类别]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[产品容器]&apos; value=&apos;[Extract].[产品容器]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[产品类别]&apos; value=&apos;[Extract].[产品类别]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[出荷モード]&apos; value=&apos;[Extract].[出荷モード]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[客户细分]&apos; value=&apos;[Extract].[客户细分]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[注文の優先度]&apos; value=&apos;[Extract].[注文の優先度]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[装运模式]&apos; value=&apos;[Extract].[装运模式]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[製品カテゴリー]&apos; value=&apos;[Extract].[製品カテゴリー]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[製品コンテナー]&apos; value=&apos;[Extract].[製品コンテナー]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[製品サブカテゴリー]&apos; value=&apos;[Extract].[製品サブカテゴリー]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[订单优先级]&apos; value=&apos;[Extract].[订单优先级]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[顧客区分]&apos; value=&apos;[Extract].[顧客区分]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[고객 세그먼트]&apos; value=&apos;[Extract].[고객 세그먼트]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[선적 모드]&apos; value=&apos;[Extract].[선적 모드]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[제품 범주]&apos; value=&apos;[Extract].[제품 범주]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[제품 컨테이너]&apos; value=&apos;[Extract].[제품 컨테이너]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[제품 하위 범주]&apos; value=&apos;[Extract].[제품 하위 범주]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[주문 우선 순위]&apos; value=&apos;[Extract].[주문 우선 순위]&apos; /&gt;&#10;  &lt;/relation-names&gt;&#10;  &lt;bindings&gt;&#10;    &lt;binding key=&apos;[Continent]&apos; value=&apos;Continent&apos; /&gt;&#10;    &lt;binding key=&apos;[Product Category]&apos; value=&apos;Product Category&apos; /&gt;&#10;    &lt;binding key=&apos;[sum:Profit:ok]&apos; value=&apos;sum:Profit:ok&apos; /&gt;&#10;  &lt;/bindings&gt;&#10;  &lt;lod&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[Continent]&lt;/column&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[Product Category]&lt;/column&gt;&#10;  &lt;/lod&gt;&#10;  &lt;measure-filter-lod&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[Continent]&lt;/column&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[Product Category]&lt;/column&gt;&#10;  &lt;/measure-filter-lod&gt;&#10;  &lt;output&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[Continent]&lt;/column&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[Product Category]&lt;/column&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[sum:Profit:ok]&lt;/column&gt;&#10;  &lt;/output&gt;&#10;  &lt;aggregates /&gt;&#10;  &lt;slicers&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[yr:Order Date:ok]&lt;/column&gt;&#10;  &lt;/slicers&gt;&#10;  &lt;filtered /&gt;&#10;  &lt;local-filters&gt;&#10;    &lt;column&gt;[Sample - Superstore - English (Extract)].[yr:Order Date:ok]&lt;/column&gt;&#10;  &lt;/local-filters&gt;&#10;  &lt;unnamed-calcs /&gt;&#10;  &lt;calculations&gt;&#10;    &lt;calculation column=&apos;[Sample - Superstore - English (Extract)].[Continent]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[Sample - Superstore - English (Extract)].[Order Date]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[Sample - Superstore - English (Extract)].[Product Category]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[Sample - Superstore - English (Extract)].[Profit]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[Sample - Superstore - English (Extract)].[sum:Profit:ok]&apos; formula=&apos;SUM([Profit])&apos; /&gt;&#10;    &lt;calculation column=&apos;[Sample - Superstore - English (Extract)].[yr:Order Date:ok]&apos; formula=&apos;DATEPART(&amp;apos;year&amp;apos;, [Order Date])&apos; /&gt;&#10;  &lt;/calculations&gt;&#10;  &lt;agg-types&gt;&#10;    &lt;agg-type column=&apos;[Sample - Superstore - English (Extract)].[Continent]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[Sample - Superstore - English (Extract)].[Product Category]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[Sample - Superstore - English (Extract)].[sum:Profit:ok]&apos; type=&apos;Sum&apos; /&gt;&#10;  &lt;/agg-types&gt;&#10;  &lt;data-types&gt;&#10;    &lt;data-type column=&apos;[Sample - Superstore - English (Extract)].[Continent]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[Sample - Superstore - English (Extract)].[Order Date]&apos; type=&apos;date&apos; /&gt;&#10;    &lt;data-type column=&apos;[Sample - Superstore - English (Extract)].[Product Category]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[Sample - Superstore - English (Extract)].[Profit]&apos; type=&apos;real&apos; /&gt;&#10;    &lt;data-type column=&apos;[Sample - Superstore - English (Extract)].[sum:Profit:ok]&apos; type=&apos;real&apos; /&gt;&#10;    &lt;data-type column=&apos;[Sample - Superstore - English (Extract)].[yr:Order Date:ok]&apos; type=&apos;integer&apos; /&gt;&#10;  &lt;/data-types&gt;&#10;  &lt;current-user display-name=&apos;&apos; name=&apos;&apos; short-domain-qualified-name=&apos;&apos; type=&apos;user&apos; /&gt;&#10;&lt;/aq-cache-key&gt;&#10;' ec-data-ts='2123452301710000' schema='Extract' tablename='Extract'>
</pack>
