ipreparedcomponent_mdx_preparelater.xaction 2.69 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 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
<?xml version="1.0" encoding="UTF-8"?>
<action-sequence> 
  <title>Test MDX IPreparedComponent PreparedLater</title>
  <version>1</version>
  <logging-level>ERROR</logging-level>
  <documentation> 
    <author/>  
    <description>Test MDX IPreparedComponent interface, PREPAREDLATER: functionality</description>  
    <help/>  
  </documentation>

  <inputs> 
    <territory type="string"> 
      <sources> 
        <request>territory</request> 
      </sources>  
      <default-value>EMEA</default-value>
    </territory>  
  </inputs>

  <outputs> 
    <prepared_component type="prepared_component"/> 
    <second_prepared_component type="prepared_component"/>
  </outputs>

  <resources> 
    <catalog> 
      <url> 
        <location>samples/steel-wheels/analysis/steelwheels.mondrian.xml</location>  
        <mime-type>text/plain</mime-type> 
      </url> 
    </catalog>  
  </resources>
  
    <actions> 

      <action-definition>
        <component-name>MDXLookupRule</component-name>
        <action-type>Qry Selected Territory and Selected Productline</action-type>
        <action-inputs/>
        <action-resources>
          <catalog type="resource"/>
        </action-resources>
        <action-outputs>
          <prepared_component/>
        </action-outputs>
        <component-definition>
          <jndi>SampleData</jndi>
          <query><![CDATA[select NON EMPTY {[Measures].[Sales]} ON COLUMNS, NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales]) ON ROWS from [SteelWheelsSales] where ([Product].[All Products].[Classic Cars], [Markets].[All Markets].[EMEA] )]]></query>
          <location>mondrian</location>
          <user-id>sa</user-id>
        </component-definition>
      </action-definition>

      <action-definition> 
        <component-name>MDXLookupRule</component-name>
        <action-type>Qry Selected Territory and Selected Productline</action-type>
        <action-inputs>
           <territory/>
        </action-inputs>
        <action-resources> 
          <catalog type="resource"/> 
        </action-resources>
        <action-outputs> 
          <prepared_component mapping="second_prepared_component"/>
        </action-outputs>
        <component-definition> 
          <jndi>SampleData</jndi>
          <query><![CDATA[select NON EMPTY {[Measures].[Sales]} ON COLUMNS, NON EMPTY TopCount([Customers].[All Customers].Children, 10.0, [Measures].[Sales]) ON ROWS from [SteelWheelsSales] where ([Product].[All Products].[{PREPARELATER:productline}], [Markets].[All Markets].[{territory}] )]]></query>  
          <location>mondrian</location>  
          <user-id>sa</user-id> 
        </component-definition> 
      </action-definition>
    </actions>

</action-sequence>