hi guys,even after hitting google for long time i could not find solution for this can any help me
i have written a mdx query to give colour to calculated measure in schema.this query is working fine in mdx query execution console but getting error in the dashbord as

Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug: Starting execute of shopping/newcustomer/pro.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)
--------------------------------

please check it out and this is my xaction file
--------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
<name>pro.xaction</name>
<title>%cool Report</title>
<version>1</version>
<logging-level>debug</logging-level>
<documentation>
<author>Adil</author>
<help></help>
<result-type>report</result-type>
<description>%description</description>
<icon></icon>
</documentation>
<inputs>
<mdx type="string">
<default-value/>
<sources>
<request>MDX</request>
</sources>
</mdx>
<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>
<chartaxistickfontsize type="string"/>
<chartslicerfontsize type="string"/>
<chartlegendfontfamily type="string"/>
<showgrid type="string"/>
<actionreference type="string"/>
<chartaxislabelfontsize type="string"/>
<chartslicerlocation type="string"/>
<chartaxistickfontfamily type="string"/>
<chartheight type="string"/>
<chartslicerfontfamily type="string"/>
<chartvertaxislabel type="string"/>
<chartaxislabelfontstyle type="string"/>
<chartdrillthroughenabled type="string"/>
<chartbackgroundb type="string"/>
<chartwidth type="string"/>
<role type="string"/>
<chartaxistickfontstyle type="string"/>
<charttitlefontsize type="string"/>
<chartbackgroundg type="string"/>
<chartlegendfontstyle type="string"/>
<chartshowslicer type="string"/>
<charttitlefontstyle type="string"/>
<chartlegendlocation type="string"/>
<chartlocation type="string"/>
<chartbackgroundr type="string"/>
<charttype type="string"/>
<chartaxislabelfontfamily type="string"/>
<chartlegendfontsize type="string"/>
<chartshowlegend type="string"/>
<chartaxisticklabelrotation type="string"/>
<charthorizaxislabel type="string"/>
<charttitle type="string"/>
<chartsliceralignment type="string"/>
<chartslicerfontstyle type="string"/>
<charttitlefontfamily type="string"/>
</outputs>
<resources/>

<actions>

<action-definition>
<component-name>PivotViewComponent</component-name>
<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"/>
<chartaxistickfontsize type="string"/>
<chartslicerfontsize type="string"/>
<chartlegendfontfamily type="string"/>
<showgrid type="string"/>
<actionreference type="string"/>
<chartaxislabelfontsize type="string"/>
<chartslicerlocation type="string"/>
<chartaxistickfontfamily type="string"/>
<chartheight type="string"/>
<chartslicerfontfamily type="string"/>
<chartvertaxislabel type="string"/>
<chartaxislabelfontstyle type="string"/>
<chartdrillthroughenabled type="string"/>
<chartbackgroundb type="string"/>
<chartwidth type="string"/>
<role type="string"/>
<chartaxistickfontstyle type="string"/>
<charttitlefontsize type="string"/>
<chartbackgroundg type="string"/>
<chartlegendfontstyle type="string"/>
<chartshowslicer type="string"/>
<charttitlefontstyle type="string"/>
<chartlegendlocation type="string"/>
<chartlocation type="string"/>
<chartbackgroundr type="string"/>
<charttype type="string"/>
<chartaxislabelfontfamily type="string"/>
<chartlegendfontsize type="string"/>
<chartshowlegend type="string"/>
<chartaxisticklabelrotation type="string"/>
<charthorizaxislabel type="string"/>
<charttitle type="string"/>
<chartsliceralignment type="string"/>
<chartslicerfontstyle type="string"/>
<charttitlefontfamily type="string"/>
</action-outputs>
<component-definition>
<title>offer Analysis</title>
<viewer>Pivot</viewer>
<model><![CDATA[solution:shopping/newcustomer/pro.xml]]></model>
<!--connection>jdbc/shopping</connection-->
<jndi>shopping</jndi>
<query>with member [Measures].[Profit] as '([Measures].[SalesPrice] - [Measures].[CostPrice])',
format_string = IIf((([Measures].[SalesPrice] - [Measures].[CostPrice]) > 0),
"|#|style='green'", IIf((([Measures].[SalesPrice] - [Measures].[CostPrice]) < 0),
"|#|style='red'", "#")) select non empty {[Measures].[SalesPrice],[Measures].[CostPrice],[Measures].[profit]}
on columns,non empty {[product.product]} on rows from [ProductProfit] </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>
<chartaxistickfontsize>12</chartaxistickfontsize>
<chartslicerfontsize>12</chartslicerfontsize>
<chartlegendfontfamily>SansSerif</chartlegendfontfamily>
<showgrid>true</showgrid>
<actionreference>shopping/newcustomer/pro.xaction</actionreference>
<chartaxislabelfontsize>12</chartaxislabelfontsize>
<chartslicerlocation>1</chartslicerlocation>
<chartaxistickfontfamily>SansSerif</chartaxistickfontfamily>
<chartheight>300</chartheight>
<chartslicerfontfamily>SansSerif</chartslicerfontfamily>
<chartvertaxislabel/>
<chartaxislabelfontstyle>0</chartaxislabelfontstyle>
<chartdrillthroughenabled>false</chartdrillthroughenabled>
<chartbackgroundb>255</chartbackgroundb>
<chartwidth>500</chartwidth>
<role/>
<chartaxistickfontstyle>0</chartaxistickfontstyle>
<charttitlefontsize>18</charttitlefontsize>
<chartbackgroundg>255</chartbackgroundg>
<mdx>with member [Measures].[Profit] as '([Measures].[SalesPrice] - [Measures].[CostPrice])',
format_string = IIf((([Measures].[SalesPrice] - [Measures].[CostPrice]) > 0),
"|#|style='green'", IIf((([Measures].[SalesPrice] - [Measures].[CostPrice]) < 0),
"|#|style='red'", "#")) select non empty {[Measures].[SalesPrice],[Measures].[CostPrice],[Measures].[profit]}
on columns,non empty {[product.product]} on rows from [ProductProfit]</mdx>
<chartlegendfontstyle>0</chartlegendfontstyle>
<chartshowslicer>true</chartshowslicer>
<charttitlefontstyle>1</charttitlefontstyle>
<connection/>
<chartlegendlocation>3</chartlegendlocation>
<chartlocation>none</chartlocation>
<chartbackgroundr>255</chartbackgroundr>
<charttype>1</charttype>
<chartaxislabelfontfamily>SansSerif</chartaxislabelfontfamily>
<chartlegendfontsize>10</chartlegendfontsize>
<chartshowlegend>true</chartshowlegend>
<chartaxisticklabelrotation>30</chartaxisticklabelrotation>
<charthorizaxislabel/>
<charttitle/>
<chartsliceralignment>3</chartsliceralignment>
<chartslicerfontstyle>0</chartslicerfontstyle>
<charttitlefontfamily>SansSerif</charttitlefontfamily>
</component-definition>
<action-name>Pivot View</action-name>
<logging-level>DEBUG</logging-level>
</action-definition>

</actions>
</action-sequence>