<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
  <name>analysis_default.xaction</name>
  <title>Analisis Berita</title>
  <version>1</version>
  <logging-level>DEBUG</logging-level>
  <documentation>
    <author>Muhammad Ichsan</author>
    <help>The following fields need to be set: General Tab Title field is the name that will display when navigating with the Pentaho Solution Browser. (mandatory) Description field is the name that will display in the Pentaho Solution Browser. (mandatory) Visible checkbox set whether this will display in the Pentaho Solution Browser. (optional) Define Process Tab Data Model is the filename of the mondrian schema. This must be named *.mondrian.xml. (mandatory) Data Source is the JNDI connection (server connection contains server, database and userid/password) that the model will use. (mandatory)</help>
    <result-type>report</result-type>
    <description>This is a template to quickly create an Analysis View in the Pentaho solution repository. All that needs to be set is the data model (mondran schema, *.mondrian.xml) and the JNDI connection that the model will use. For more information, please see the Help field on the General Tab.</description>
    <icon>analysis_default.png</icon>
  </documentation>

  <inputs>
    <mode type="string">
      <default-value/>
      <sources>
        <request>mode</request>
      </sources>
    </mode>
    <tahunKejadian type="string">
      <sources>
        <request>tahunKejadian</request>
      </sources>
      <default-value/>
    </tahunKejadian>
    <nipPenulis type="string">
      <sources>
        <request>nipPenulis</request>
      </sources>
      <default-value/>
    </nipPenulis>
    <topik type="string">
      <sources>
        <request>topik</request>
      </sources>
      <default-value/>
    </topik>
    <kota type="string">
      <sources>
        <request>kota</request>
      </sources>
      <default-value/>
    </kota>
    <mdx type="string">
      <sources>
        <request>MDX</request>
      </sources>
    </mdx>
  </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>
  </outputs>

  <resources/>

  <actions>
    <action-definition>
      <component-name>JavascriptRule</component-name>
      <action-type>JavaScript</action-type>
      <action-inputs>
        <tahunKejadian type="string"/>
        <nipPenulis type="string"/>
        <topik type="string"/>
        <kota type="string"/>
      </action-inputs>
      <action-outputs>
        <tahunKejadianSelects type="string"/>
        <nipPenulisSelects type="string"/>
        <topikSelects type="string"/>
        <kotaSelects type="string"/>
      </action-outputs>
      <component-definition>
        <script><![CDATA[function getSelects( baseStr, values ) {
    rtnStr = baseStr;
    if ( values == null ) {
        // Do nothing and the baseStr will be returned
    }
    else if ( typeof( values ) == "string" ) {
        rtnStr += values;
    }
    else {
        rtnStr = baseStr;
        if ( (values != null) && (values.length >= 1) ) {
            rtnStr += values[0];
            for ( i = 1; i < values.length; ++i ) {
                rtnStr += ", " + baseStr + values[i];
            }
        }
    }
java.lang.System.out.println( rtnStr );
    return( rtnStr );
}

tahunKejadianSelects = getSelects( "[Waktu].[Tahun].members", tahunKejadian );
nipPenulisSelects = getSelects( "[Penulis].[Seluruh Penulis]", nipPenulis );
topikSelects = getSelects( "[Topik].[Seluruh Topik]", topik );
kotaSelects = getSelects( "[Lokasi].[Seluruh Lokasi]", kota );]]></script>
      </component-definition>
    </action-definition>

    <action-definition>
      <component-name>PivotViewComponent</component-name>
      <action-type/>
      <action-inputs>
        <mode type="string"/>
        <nipPenulisSelects type="string"/>
        <kotaSelects type="string"/>
        <topikSelects type="string"/>
        <tahunKejadianSelects type="string"/>
      </action-inputs>
      <action-outputs>
        <options type="list"/>
        <model type="string"/>
        <connection type="string"/>
        <mdx type="string"/>
        <title type="string"/>
        <url type="string"/>
      </action-outputs>
      <component-definition>
        <model><![CDATA[samples/analysis/Berita2kurank.xml]]></model>
        <jndi><![CDATA[SampleData]]></jndi>
        <viewer><![CDATA[Pivot]]></viewer>
        <query><![CDATA[select
  NON EMPTY {[Measures].[Jumlah]} ON COLUMNS,
  NON EMPTY Crossjoin(
        { {tahunKejadianSelects} },
        Crossjoin(
          { {nipPenulisSelects} },
            Crossjoin(
              { {topikSelects} }, { {kotaSelects} }
            )
        )
  ) ON ROWS

from [Analisis Berita]]]></query>
      </component-definition>
    </action-definition>

  </actions>
</action-sequence>