<?xml version="1.0" encoding="UTF-8"?>
<action-sequence> 
  <title>Barchart Data</title>
  <version>1</version>
  <logging-level>debug</logging-level>
  <documentation> 
    <author>Gretchen Moran</author>  
    <description>Return the variance between headcount actual and budget for every department</description>  
    <help/> 
  </documentation>

  <inputs/>

  <outputs> 
    <query_result type="result-set"/>
  </outputs>

  <resources>
    <catalog1>
      <solution-file>
        <location>steelwheels.mondrian.xml</location>
        <mime-type>text/plain</mime-type>
      </solution-file>
    </catalog1>
  </resources>
  
  <!-- Define an input called 'REGION'. This will be passed in when the user clicks on a slice of the pie chart -->  
  <!-- Define an output called 'rule-result' -->  
  <!-- This action sequence does not require any external resources -->  
  <actions> 
    <action-definition>
      <component-name>MDXLookupRule</component-name>
      <action-type>OLAP</action-type>
      <action-resources>
        <catalog type="resource" mapping="catalog1"/>
      </action-resources>
      <action-outputs>
        <query-results type="result-set" mapping="query_result"/>
      </action-outputs>
      <component-definition>
        <jndi><![CDATA[SampleData]]></jndi>
        <location><![CDATA[mondrian]]></location>
        <query><![CDATA[select {[Product].[All Products].[Classic Cars], [Product].[All Products].[Motorcycles], [Product].[All Products].[Planes], [Product].[All Products].[Ships], [Product].[All Products].[Trains], [Product].[All Products].[Trucks and Buses], [Product].[All Products].[Vintage Cars]} ON COLUMNS,
  {[Markets].[All Markets].[APAC], [Markets].[All Markets].[EMEA], [Markets].[All Markets].[Japan], [Markets].[All Markets].[NA]} ON ROWS
from [SteelWheelsSales]
where ([Measures].[Sales], [Time].[All Years])]]></query>
      </component-definition>
    </action-definition>

  </actions> 
</action-sequence>