clear mondrian cache for a date

clear mondrian cache for a date

<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
    <title>Prime Mondrian Cache</title>
    <version>1</version>
    <logging-level>DEBUG</logging-level>
    <documentation>
        <author />
        <description>An example of priming Mondrian Cache</description>
        <help />
        <result-type />
        <icon />
    </documentation>
    <inputs />
    <outputs />
    <resources>
        <catalog>
            <url>
                <location>solution:/Affiliate_Tracking/schema.xml</location>
                <mime-type>text/xml</mime-type>
            </url>
        </catalog>
    </resources>
    <actions>
        <action-definition>
            <component-name>MDXLookupRule</component-name>
            <action-type>OLAP Connection</action-type>
            <action-resources>
                <catalog type="resource" />
            </action-resources>
            <action-outputs>
                <prepared_component type="mdx-connection" mapping="shared_olap_connection" />
            </action-outputs>
            <component-definition>
                <jndi><![CDATA[SampleData]]></jndi>
                <location><![CDATA[mondrian]]></location>
            </component-definition>
        </action-definition>
        <action-definition>
            <component-name>JavascriptRule</component-name>
            <action-type>JavaScript To Clear portions of the cache</action-type>
            <action-inputs />
            <action-outputs />
            <component-definition>
                <script><![CDATA[function cacheControlImpl() {
                          var conn           = shared_olap_connection.shareConnection().getConnection();
                          var schema         = conn.getSchema();
                          var cube           = schema.lookupCube("INTERNAL_REPORT", true);
                          var schemaReader   = cube.getSchemaReader(null);
                          var cacheControl   = conn.getCacheControl(null);
                          var member         = schemaReader.getMemberByUniqueName(Packages.mondrian.olap.Id.Segment.toList("DATE_PERIODS", "DAY_OF_MONTH", "2013-10-18"), true);

                          var memberRegion     = cacheControl.createMemberRegion(member, true);
                          var measuresRegion   = cacheControl.createMeasuresRegion(cube);
                          var joinRegion       = cacheControl.createCrossjoinRegion(measuresRegion, memberRegion);

                          cacheControl.flush(joinRegion);
                        }
                        cacheControlImpl();]]></script>
            </component-definition>
        </action-definition>
    </actions>
</action-sequence>

Response :

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
 <SOAP-ENV:Body>
<SOAP-ENV:Fault>
<SOAP-ENV:faultcode>
 <SOAP-ENV:Subcode>
<SOAP-ENV:Value><![CDATA[Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)]]></SOAP-ENV:Value>
 </SOAP-ENV:Subcode>
 </SOAP-ENV:faultcode><SOAP-ENV:faultactor>SOAP-ENV:Server</SOAP-ENV:faultactor>
<SOAP-ENV:faultstring><SOAP-ENV:Text xml:lang="en_US"><![CDATA[Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)]]></SOAP-ENV:Text>
 </SOAP-ENV:faultstring>
<SOAP-ENV:Detail><message name="trace"><![CDATA[Debug: Starting execute of admin//clear_activity_cache.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)]]></message>
<message name="trace"><![CDATA[Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)]]></message>
<message name="trace"><![CDATA[Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)]]></message>
<message name="trace"><![CDATA[Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)]]></message>
</SOAP-ENV:Detail></SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>