2123657571384690
<pack class='dataengine' dbname='Data/April-2017/Sheet1 (Crimes with Group).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.3&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;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1332221083041509378]&apos; /&gt;&#10;      &lt;field column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crime Type]&apos; /&gt;&#10;      &lt;output column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1332221083041509378]&apos; /&gt;&#10;      &lt;output column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crime Type]&apos; /&gt;&#10;      &lt;output column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[sum:Crimes:ok]&apos; /&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Action (District+State)]&apos;&gt;&#10;        &lt;groupfilter function=&apos;intersection&apos;&gt;&#10;          &lt;groupfilter function=&apos;crossjoin&apos;&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Calculation_1854075688508649472]&apos; /&gt;&#10;          &lt;/groupfilter&gt;&#10;          &lt;groupfilter function=&apos;member&apos; level=&apos;[Calculation_1854075688508649472]&apos; member=&apos;&amp;quot;Pithoragarh, Uttarakhand&amp;quot;&apos; user:ui-action-filter=&apos;[Action1]&apos; user:ui-domain=&apos;database&apos; user:ui-enumeration=&apos;inclusive&apos; user:ui-marker=&apos;enumerate&apos; /&gt;&#10;        &lt;/groupfilter&gt;&#10;      &lt;/filter&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Action (District+State,Crime Type,Year)]&apos;&gt;&#10;        &lt;groupfilter function=&apos;intersection&apos;&gt;&#10;          &lt;groupfilter function=&apos;crossjoin&apos;&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Calculation_1854075688508649472]&apos; /&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Crime Type]&apos; /&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Year]&apos; /&gt;&#10;          &lt;/groupfilter&gt;&#10;          &lt;groupfilter function=&apos;crossjoin&apos; user:ui-enumeration=&apos;all&apos; user:ui-marker=&apos;enumerate&apos;&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Calculation_1854075688508649472]&apos; /&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Crime Type]&apos; /&gt;&#10;            &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Year]&apos; /&gt;&#10;          &lt;/groupfilter&gt;&#10;        &lt;/groupfilter&gt;&#10;      &lt;/filter&gt;&#10;      &lt;filter class=&apos;quantitative&apos; column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Year]&apos; included-values=&apos;in-range&apos;&gt;&#10;        &lt;min&gt;2014&lt;/min&gt;&#10;        &lt;max&gt;2014&lt;/max&gt;&#10;      &lt;/filter&gt;&#10;    &lt;/fields&gt;&#10;  &lt;/query&gt;&#10;  &lt;context-stack&gt;&#10;    &lt;context&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[Crime Type]&apos; context=&apos;true&apos; filter-group=&apos;2&apos;&gt;&#10;        &lt;groupfilter function=&apos;except&apos; user:ui-domain=&apos;database&apos; user:ui-enumeration=&apos;exclusive&apos; user:ui-marker=&apos;enumerate&apos;&gt;&#10;          &lt;groupfilter function=&apos;level-members&apos; level=&apos;[Crime Type]&apos; /&gt;&#10;          &lt;groupfilter function=&apos;member&apos; level=&apos;[Crime Type]&apos; member=&apos;&amp;quot;2014 New Crime Groups&amp;quot;&apos; /&gt;&#10;        &lt;/groupfilter&gt;&#10;      &lt;/filter&gt;&#10;    &lt;/context&gt;&#10;  &lt;/context-stack&gt;&#10;  &lt;relation-xml&gt;&amp;lt;relation 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;[Calculation_1854075688508649472]&apos; value=&apos;[Extract].[Calculation_1854075688508649472]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Crime Type]&apos; value=&apos;[Extract].[Crime Type]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Crimes (bin)]&apos; value=&apos;[Extract].[Crimes (bin)]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Crimes]&apos; value=&apos;[Extract].[Crimes]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[District]&apos; value=&apos;[Extract].[District]&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;[State]&apos; value=&apos;[Extract].[State]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Year]&apos; value=&apos;[Extract].[Year]&apos; /&gt;&#10;  &lt;/relation-names&gt;&#10;  &lt;bindings&gt;&#10;    &lt;binding key=&apos;[Calculation_1332221083041509378]&apos; value=&apos;Calculation_1332221083041509378&apos; /&gt;&#10;    &lt;binding key=&apos;[Crime Type]&apos; value=&apos;Crime Type&apos; /&gt;&#10;    &lt;binding key=&apos;[sum:Crimes:ok]&apos; value=&apos;sum:Crimes:ok&apos; /&gt;&#10;  &lt;/bindings&gt;&#10;  &lt;lod&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1332221083041509378]&lt;/column&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crime Type]&lt;/column&gt;&#10;  &lt;/lod&gt;&#10;  &lt;measure-filter-lod&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1332221083041509378]&lt;/column&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crime Type]&lt;/column&gt;&#10;  &lt;/measure-filter-lod&gt;&#10;  &lt;output&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1332221083041509378]&lt;/column&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crime Type]&lt;/column&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[sum:Crimes:ok]&lt;/column&gt;&#10;  &lt;/output&gt;&#10;  &lt;aggregates /&gt;&#10;  &lt;slicers&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Action (District+State)]&lt;/column&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Action (District+State,Crime Type,Year)]&lt;/column&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Year]&lt;/column&gt;&#10;  &lt;/slicers&gt;&#10;  &lt;filtered /&gt;&#10;  &lt;local-filters&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Action (District+State)]&lt;/column&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Action (District+State,Crime Type,Year)]&lt;/column&gt;&#10;    &lt;column&gt;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Year]&lt;/column&gt;&#10;  &lt;/local-filters&gt;&#10;  &lt;unnamed-calcs /&gt;&#10;  &lt;calculations&gt;&#10;    &lt;calculation column=&apos;[Parameters].[Crime Type Parameter]&apos; formula=&apos;&amp;quot;All&amp;quot;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1332221083041509378]&apos; formula=&apos;IF [Parameters].[Crime Type Parameter]=&amp;quot;All&amp;quot;  OR&amp;#13;&amp;#10;[Crime Type]=[Parameters].[Crime Type Parameter] THEN &amp;quot;Yes&amp;quot; &amp;#13;&amp;#10;ELSE &amp;quot;No&amp;quot;&amp;#13;&amp;#10;END&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1854075688508649472]&apos; formula=&apos;[District] + &amp;quot;, &amp;quot; + [State]&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crime Type]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crimes]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[District]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[State]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Year]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[sum:Crimes:ok]&apos; formula=&apos;SUM([Crimes])&apos; /&gt;&#10;  &lt;/calculations&gt;&#10;  &lt;agg-types&gt;&#10;    &lt;agg-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1332221083041509378]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crime Type]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[sum:Crimes:ok]&apos; type=&apos;Sum&apos; /&gt;&#10;  &lt;/agg-types&gt;&#10;  &lt;data-types&gt;&#10;    &lt;data-type column=&apos;[Parameters].[Crime Type Parameter]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1332221083041509378]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Calculation_1854075688508649472]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crime Type]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Crimes]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[District]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[State]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[Year]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[federated.0fdtab71xhpvcq1bmp6k21pv6i80].[sum:Crimes: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='2123657416840000' schema='Extract' tablename='Extract'>
</pack>
