MDX_report.xaction

<action-sequence>

	<name>MDX_report.xaction</name>
	<version>1</version>
	<title>%title</title>
	<logging-level>debug</logging-level>
	<documentation>
		<author>William Seyler</author>
		<description>%description</description>
		<help></help>
		<result-type>rule</result-type>
		<icon>MDX_Datasource.png</icon>
	</documentation>

	<inputs>
		<output-type type="string">
			<default-value>html</default-value>
			<sources>
				<request>type</request> 
			</sources>
		</output-type>
	</inputs>

	<outputs>
	</outputs>

	<resources>
		<catalog>
			<solution-file>
				<location>SampleData.xml</location>
				<mime-type>text/xml</mime-type>
			</solution-file>
		</catalog>
		<report-definition>
			<solution-file>
				<location>JFreeMondrianQuadrant.xml</location>
				<mime-type>text/xml</mime-type>
			</solution-file>
		</report-definition>
	</resources>
  
  <actions>
      <action-definition>
        
        <action-inputs>
          <output-type type="string"/>
        </action-inputs>
        
		<component-name>JFreeReportComponent</component-name>
        <action-type>report</action-type>
      	<component-definition>
      	  <source>mdx</source>
          <jndi>SampleData</jndi>
          <location>mondrian</location>
          <query><![CDATA[with member [Measures].[Variance Percent] as '([Measures].[Variance] / [Measures].[Budget])', format_string = IIf(((([Measures].[Variance] / [Measures].[Budget]) * 100.0) > 2.0), "|#.00%|style='green'", IIf(((([Measures].[Variance] / [Measures].[Budget]) * 100.0) < 0.0), "|#.00%|style='red'", "#.00%"))
select Crossjoin({[Region].[All Regions].[Central], [Region].[All Regions].[Eastern], [Region].[All Regions].[Southern], [Region].[All Regions].[Western]}, {[Measures].[Actual], [Measures].[Budget]}) ON columns,
  Hierarchize(Union({[Department].[All Departments]}, [Department].[All Departments].Children)) ON rows
from [Quadrant Analysis]
]]></query>    
        </component-definition>
        
        
      </action-definition>
        
  </actions>
</action-sequence>