p_age20emp_data.xaction 1.46 KB
Newer Older
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
<?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>Sample data values for dial chart</description>  
    <help/> 
  </documentation>

  <inputs/>

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

  <resources> 
    <catalog> 
      <solution-file> 
        <location>myHR.xml</location>  
        <mime-type>text/plain</mime-type> 
      </solution-file> 
    </catalog> 
  </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"/> 
      </action-resources>
      <action-outputs> 
        <query-results type="result-set" mapping="query_result"/> 
      </action-outputs>
      <component-definition> 
        <jndi>myhr</jndi>  
        <location>mondrian</location>  
        <query><![CDATA[
	
select {[gender.gender].[all gender]} ON COLUMNS,
  {[Measures].[age1Percentage]} ON ROWS
from [EmployeeAge]


]]></query> 

      </component-definition> 
    </action-definition>
 
  </actions> 
</action-sequence>