Configuration File : icCube.xml

The file $install/bin/icCube.xml contains the configuration properties of the icCube server.

The default file shipped with the installation describes all the possible configuration settings (please refer to your actual installation file to get an up-to-date version of its content). Note that configuring icCube behind the Apache Web Server is explained here.

MDX Request Result Cache

The following properties are configuring the MDX request result cache:

        <resultCacheConfiguration>

            <!--
                Activates the MDX request result cache (case sensitive):

                MEMORY : the cache is activated and is memory based (faster).

                FILE   : the cache is activated and is file based.

                OFF    : the cache is not activated.
            -->
            <mode>MEMORY</mode>

            <!--
                MDX request result cache size (MB).
            -->
            <size>16</size>

            <!--
                Whether or not the MDX requests via GVI (i.e., Web Reporting) protocol are cached.
            -->
            <gvi>true</gvi>

            <!--
                Whether or not the MDX requests via XMLA protocol are cached.
            -->
            <xmla>true</xmla>

            <!--
                The policy that determines if a MDX request can be cached.
            -->
            <cachingPolicy>

                <!--
                    The name of a class (IOlapResultCachePolicy) that determines if a MDX request can be cached.
                -->
                <!--<classname>crazydev.iccube.olap.eval.cache.result.cache.OlapResultCacheImmediatePolicy</classname>-->

                <!--
                    MDX request that are executed twice are cached.
                -->
                <classname>crazydev.iccube.olap.eval.cache.result.cache.OlapResultCacheBufferedPolicy</classname>

                <!--
                    Number of MDX request being kept to determine if executed twice.
                -->
                <param>
                <name>bufferedRequestCount</name>
                <value>1024</value>
                </param>

            </cachingPolicy>

        </resultCacheConfiguration>
    

MDX FORMAT_STRING Syntax

The following property is configuring the MDX FORMAT_STRING syntax:

        <!--
            MDX cell property FORMAT_STRING syntax (either JAVA or EXCEL).

            The JAVA string format syntax is assumed when this icCube property is not defined.

            Note that using a prefix within the FORMAT_STRING will enforce a given syntax
            whatever the actual definition of this icCube property:

                FORMAT_STRING = "e: ... " : enforce EXCEL format.
                FORMAT_STRING = "j: ... " : enforce JAVA format.
        -->
        <icCube.defaultFormatStringSyntax value="EXCEL"/>        
    

Next chapter : icCube.json configuration file.