<?xml version="1.0" encoding="UTF-8"?> <action-sequence> <name>analysis_customers.xaction</name> <title>%title</title> <version>1</version> <logging-level>ERROR</logging-level> <documentation> <author>Kurtis Cruzada</author> <help/> <result-type>report</result-type> <description>%description</description> <icon>analysis_customer.png</icon> </documentation> <inputs> <mode type="string"> <default-value/> <sources> <request>mode</request> </sources> </mode> </inputs> <outputs> <model type="string"/> <connection type="string"/> <mdx type="string"/> <options type="list"/> <title type="string"/> <url type="string"> <destinations> <response>redirect</response> </destinations> </url> <charttype type="string"/> <chartlocation type="string"/> <chartheight type="string"/> <chartwidth type="string"/> <showgrid type="string"/> </outputs> <resources/> <actions> <action-definition> <component-name>PivotViewComponent</component-name> <action-type>Pivot View</action-type> <action-inputs> <mode type="string"/> </action-inputs> <action-outputs> <model type="string"/> <connection type="string"/> <mdx type="string"/> <options type="list"/> <title type="string"/> <url type="string"/> <charttype type="string"/> <chartlocation type="string"/> <chartheight type="string"/> <chartwidth type="string"/> <showgrid type="string"/> </action-outputs> <component-definition> <title>Drill Down to Pivot Table</title> <viewer>Pivot</viewer> <charttype>8</charttype> <chartlocation>right</chartlocation> <chartheight>600</chartheight> <chartwidth>600</chartwidth> <showgrid>true</showgrid> <model>samples/steel-wheels/analysis/steelwheels.mondrian.xml</model> <!-- connection>jdbc/SampleData</connection --> <!-- query>default</query --> <options> <personal/> <cube-nav/> <mdx-edit/> <sort-conf/> <spacer/> <level-style/> <hide-spans/> <properties/> <non-empty/> <swap-axes/> <spacer/> <drill-member/> <drill-position/> <drill-replace/> <drill-thru/> <spacer/> <chart/> <chart-conf/> <spacer/> <print-conf/> <print-pdf/> <spacer/> <excel/> </options> <jndi>SampleData</jndi> <query><![CDATA[select {[Markets].[All Markets].[APAC], [Markets].[All Markets].[EMEA], [Markets].[All Markets].[Japan], [Markets].[All Markets].[NA]} ON COLUMNS, Crossjoin({[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]}, {[Time].[All Years].[2003], [Time].[All Years].[2004], [Time].[All Years].[2005]}) ON ROWS from [SteelWheelsSales] where ([Customers].[All Customers], [Measures].[Sales])]]></query> </component-definition> <action-name>Pivot View</action-name> <logging-level>DEBUG</logging-level> </action-definition> </actions> </action-sequence>