| # This software is subject to the terms of the Eclipse Public License 2.0 |
| # Agreement, available at the following URL: |
| # https://www.eclipse.org/legal/epl-2.0/. |
| #. |
| # SPDX-License-Identifier: EPL-2.0. |
| # You must accept the terms of that agreement to use this software. |
| # |
| # Copyright (C) 2001-2005 Julian Hyde |
| # Copyright (C) 2005-2017 Hitachi Vantara and others |
| # All Rights Reserved. |
| |
| ############################################################################### |
| # String property that is the AggRule element's tag value. |
| # |
| # Normally, this property is not set by a user. |
| # |
| #mondrian.rolap.aggregates.rule.tag=default |
| |
| ############################################################################### |
| # String property containing the name of the file which defines the |
| # rules for recognizing an aggregate table. Can be either a resource in |
| # the Mondrian jar or a URL. |
| # |
| # The default value is "/DefaultRules.xml", which is in the |
| # mondrian.rolap.aggmatcher package in Mondrian.jar. |
| # |
| # Normally, this property is not set by a user. |
| # |
| #mondrian.rolap.aggregates.rules=/DefaultRules.xml |
| |
| ############################################################################### |
| # Alerting action to take in case native evaluation of a function is |
| # enabled but not supported for that function's usage in a particular |
| # query. (No alert is ever raised in cases where native evaluation would |
| # definitely have been wasted effort.) |
| # |
| # Recognized actions: |
| # |
| # |
| # * OFF: do nothing (default action, also used if |
| # unrecognized action is specified) |
| # * WARN: log a warning to RolapUtil logger |
| # * ERROR: throw an instance of |
| # NativeEvaluationUnsupportedException |
| # |
| #mondrian.native.unsupported.alert=OFF |
| |
| ############################################################################### |
| # Boolean property that controls whether the MDX parser resolves uses |
| # case-sensitive matching when looking up identifiers. The default is |
| # false. |
| # |
| #mondrian.olap.case.sensitive=false |
| |
| ############################################################################### |
| # Property that contains the URL of the catalog to be used by |
| # mondrian.tui.CmdRunner and XML/A Test. |
| # |
| #mondrian.catalogURL= |
| |
| ############################################################################### |
| # Integer property that, if set to a value greater than zero, sets a hard limit on the |
| # number of cells that are batched together when building segments. |
| # |
| #mondrian.rolap.cellBatchSize=-1 |
| |
| ############################################################################### |
| # Positive integer property that determines loop iterations number between checks for whether the current mdx query has been cancelled or timeout was exceeded. |
| # Setting the interval too small may result in a performance degradation when reading large result sets; |
| # setting it too high can cause a big delay between the query being marked as cancelled or timeout was exceeded and system resources associated to it being released. |
| # |
| #mondrian.util.checkCancelOrTimeoutInterval=1000 |
| |
| ############################################################################### |
| # Boolean property that controls whether aggregate tables |
| # are ordered by their volume or row count. |
| # |
| # If true, Mondrian uses the aggregate table with the smallest volume |
| # (number of rows multiplied by number of columns); if false, Mondrian |
| # uses the aggregate table with the fewest rows. |
| # |
| #mondrian.rolap.aggregates.ChooseByVolume=false |
| |
| ############################################################################### |
| # Boolean property that controls whether sibling members are |
| # compared according to order key value fetched from their ordinal |
| # expression. The default is false (only database ORDER BY is used). |
| # |
| #mondrian.rolap.compareSiblingsByOrderKey=false |
| |
| ############################################################################### |
| # Property that defines |
| # when to apply the crossjoin optimization algorithm. |
| # |
| # If a crossjoin input list's size is larger than this property's |
| # value and the axis has the "NON EMPTY" qualifier, then |
| # the crossjoin non-empty optimizer is applied. |
| # Setting this value to '0' means that for all crossjoin |
| # input lists in non-empty axes will have the optimizer applied. |
| # On the other hand, if the value is set larger than any possible |
| # list, say Integer.MAX_VALUE, then the optimizer |
| # will never be applied. |
| # |
| #mondrian.olap.fun.crossjoin.optimizer.size=0 |
| |
| ############################################################################### |
| # Property that defines |
| # the name of the plugin class that resolves data source names to |
| # javax.sql.DataSource objects. The class must implement the |
| # mondrian.spi.DataSourceResolver interface. If not specified, |
| # the default implementation uses JNDI to perform resolution. |
| # |
| # Example: |
| # mondrian.spi.dataSourceResolverClass=mondrian.spi.impl.JndiDataSourceResolver |
| # |
| #mondrian.spi.dataSourceResolverClass= |
| |
| ############################################################################### |
| # Boolean property that controls whether a RolapStar's |
| # aggregate data cache is cleared after each query. |
| # If true, no RolapStar will cache aggregate data from one |
| # query to the next (the cache is cleared after each query). |
| # |
| #mondrian.rolap.star.disableCaching=false |
| |
| ############################################################################### |
| # Boolean property that controls whether the data from segments |
| # is cached locally. To create custom caches, look for the |
| # SegmentCache SPI. |
| # |
| #mondrian.rolap.star.disableLocalSegmentCache=false |
| |
| ############################################################################### |
| # Property that controls whether aggregation cache hit / miss |
| # counters will be enabled. |
| # |
| # Note that this will affect performance due to existence of sync |
| # blocks. |
| # |
| # @deprecated This property is no longer used, and will be removed in |
| # mondrian-4.0. |
| # |
| #mondrian.rolap.agg.enableCacheHitCounters=false |
| |
| ############################################################################### |
| # If disabled, Mondrian will throw an exception if someone attempts to |
| # perform a drillthrough of any kind. |
| # |
| #mondrian.drillthrough.enable=true |
| |
| ############################################################################### |
| # Boolean property that controls whether to use a cache for frequently |
| # evaluated expressions. With the cache disabled, an expression like |
| # Rank([Product].CurrentMember, |
| # Order([Product].MEMBERS, [Measures].[Unit Sales])) would perform |
| # many redundant sorts. The default is true. |
| # |
| #mondrian.expCache.enable=true |
| |
| ############################################################################### |
| # Property that defines |
| # whether to generate SQL queries using the GROUPING SETS |
| # construct for rollup. By default it is not enabled. |
| # |
| # Ignored on databases which do not support the |
| # GROUPING SETS construct (see |
| # mondrian.spi.Dialect#supportsGroupingSets). |
| # |
| #mondrian.rolap.groupingsets.enable=false |
| |
| ############################################################################### |
| # Property which turns on or off the in-memory rollup |
| # of segment data. Defaults to true. |
| # |
| #mondrian.rolap.EnableInMemoryRollup=true |
| |
| ############################################################################### |
| # If enabled some NON EMPTY CrossJoin will be computed in SQL. |
| # |
| #mondrian.native.crossjoin.enable=true |
| |
| ############################################################################### |
| # If enabled some Filter() will be computed in SQL. |
| # |
| #mondrian.native.filter.enable=true |
| |
| ############################################################################### |
| # If enabled some NON EMPTY set operations like member.children, |
| # level.members and member descendants will be computed in SQL. |
| # |
| #mondrian.native.nonempty.enable=true |
| |
| ############################################################################### |
| # If enabled some TopCount will be computed in SQL. |
| # |
| #mondrian.native.topcount.enable=true |
| |
| ############################################################################### |
| # Boolean property that controls whether each query axis implicit has the |
| # NON EMPTY option set. The default is false. |
| # |
| #mondrian.rolap.nonempty=false |
| |
| ############################################################################### |
| # Property that determines whether to cache RolapCubeMember objects, |
| # each of which associates a member of a shared hierarchy with a |
| # particular cube in which it is being used. |
| # |
| # The default is true, that is, use a cache. If you wish to use |
| # the member cache control aspects of mondrian.olap.CacheControl, |
| # you must set this property to false. |
| # |
| # RolapCubeMember has recently become more lightweight to |
| # construct, and we may obsolete this cache and this |
| # property. |
| # |
| #mondrian.rolap.EnableRolapCubeMemberCache=true |
| |
| ############################################################################### |
| # If enabled, first row in the result of an XML/A drill-through request |
| # will be filled with the total count of rows in underlying database. |
| # |
| #mondrian.xmla.drillthroughTotalCount.enable=true |
| |
| ############################################################################### |
| # Boolean property that controls whether to notify the Mondrian system |
| # when a MondrianProperties property value changes. |
| # |
| # This allows objects dependent on Mondrian properties to react (that |
| # is, reload), when a given property changes via, say, |
| # MondrianProperties.instance().populate(null) or |
| # MondrianProperties.instance().QueryLimit.set(50). |
| # |
| #mondrian.olap.triggers.enable=true |
| |
| ############################################################################### |
| # Property that defines how many previous execution instances the |
| # Monitor keeps in its history so that it can send the events |
| # which happen after the fact. Setting this property too high will make the |
| # JVM run out of memory. Setting it too low might prevent some events from |
| # reaching the listeners of the monitor. |
| # This property is for internal use only and should not be changed |
| # unless required. Defaults to 1,000. |
| # |
| #mondrian.server.monitor.executionHistorySize=1000 |
| |
| ############################################################################### |
| # Property that defines |
| # the name of the class used to compile scalar expressions. |
| # |
| # If the value is |
| # non-null, it is used by the ExpCompiler.Factory |
| # to create the implementation. |
| # |
| # To test that for all test MDX queries that all functions can |
| # handle requests for ITERABLE, LIST and MUTABLE_LIST evaluation |
| # results, use the following: |
| # |
| # mondrian.calc.ExpCompiler.class=mondrian.olap.fun.ResultStyleCompiler |
| # |
| #mondrian.calc.ExpCompiler.class= |
| |
| ############################################################################### |
| # If this property is true, when looking for native evaluation of an |
| # expression, Mondrian will expand non-native sub-expressions into |
| # lists of members. |
| # |
| #mondrian.native.ExpandNonNative=false |
| |
| ############################################################################### |
| # Property that defines |
| # whether to generate joins to filter out members in a snowflake |
| # dimension that do not have any children. |
| # |
| # If true (the default), some queries to query members of high |
| # levels snowflake dimensions will be more expensive. If false, and if |
| # there are rows in an outer snowflake table that are not referenced by |
| # a row in an inner snowflake table, then some queries will return members |
| # that have no children. |
| # |
| # Our recommendation, for best performance, is to remove rows outer |
| # snowflake tables are not referenced by any row in an inner snowflake |
| # table, during your ETL process, and to set this property to |
| # false. |
| # |
| #mondrian.rolap.FilterChildlessSnowflakeMembers=true |
| |
| ############################################################################### |
| # Property containing the JDBC URL of the FoodMart database. |
| # The default value is to connect to an ODBC data source called |
| # "MondrianFoodMart". |
| # |
| # To run the test suite, first load the FoodMart data set into the |
| # database of your choice. Then set the driver.classpath, |
| # mondrian.foodmart.jdbcURL and mondrian.jdbcDrivers properties, by |
| # un-commenting and modifying one of the sections below. |
| # Put the JDBC driver jar into mondrian/testlib. |
| # |
| # Here are example property settings for various databases. |
| # |
| # ### Derby: needs user and password ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:derby:demo/derby/foodmart |
| # mondrian.foodmart.jdbcUser=sa |
| # mondrian.foodmart.jdbcPassword=sa |
| # mondrian.jdbcDrivers=org.apache.derby.jdbc.EmbeddedDriver |
| # driver.classpath=testlib/derby.jar |
| # |
| # ### FireBirdSQL ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:firebirdsql:localhost/3050:/mondrian/foodmart.gdb |
| # mondrian.jdbcDrivers=org.firebirdsql.jdbc.FBDriver |
| # driver.classpath=/jdbc/fb/firebirdsql-full.jar |
| # |
| # ### Greenplum (similar to Postgres) ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:postgresql://localhost/foodmart?user=gpadmin&password=xxxx |
| # mondrian.foodmart.jdbcUser=foodmart |
| # mondrian.foodmart.jdbcPassword=foodmart |
| # mondrian.jdbcDrivers=org.postgresql.Driver |
| # driver.classpath=lib/postgresql-8.2-504.jdbc3.jar |
| # |
| # ### LucidDB (see <a>instructions</a>) ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:luciddb:http://localhost |
| # mondrian.foodmart.jdbcUser=foodmart |
| # mondrian.jdbcDrivers=org.luciddb.jdbc.LucidDbClientDriver |
| # driver.classpath=/path/to/luciddb/plugin/LucidDbClient.jar |
| # |
| # ### Oracle (needs user and password) ### |
| # |
| # oracle.home=G:/oracle/product/10.1.0/Db_1 |
| # mondrian.foodmart.jdbcURL.oracle=jdbc:oracle:thin:@//host:port/service_name |
| # mondrian.foodmart.jdbcURL=jdbc:oracle:thin:foodmart/foodmart@//stilton:1521/orcl |
| # mondrian.foodmart.jdbcURL=jdbc:oracle:oci8:foodmart/foodmart@orcl |
| # mondrian.foodmart.jdbcUser=FOODMART |
| # mondrian.foodmart.jdbcPassword=oracle |
| # mondrian.jdbcDrivers=oracle.jdbc.OracleDriver |
| # driver.classpath=/home/jhyde/open/mondrian/lib/ojdbc14.jar |
| # |
| # ### ODBC (Microsoft Access) ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:odbc:MondrianFoodMart |
| # mondrian.jdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver |
| # driver.classpath= |
| # |
| # ### Hypersonic ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:hsqldb:demo/hsql/FoodMart |
| # mondrian.jdbcDrivers=org.hsqldb.jdbcDriver |
| # driver.classpath=xx |
| # |
| # ### MySQL: can have user and password set in JDBC URL ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart |
| # mondrian.foodmart.jdbcURL=jdbc:mysql://localhost/foodmart |
| # mondrian.foodmart.jdbcUser=foodmart |
| # mondrian.foodmart.jdbcPassword=foodmart |
| # mondrian.jdbcDrivers=com.mysql.jdbc.Driver |
| # driver.classpath=D:/mysql-connector-3.1.12 |
| # |
| # mariadb: needs user and password set in JDBC URL |
| # mondrian.foodmart.jdbcURL=jdbc:mariadb://localhost:3307/foodmart3?user=root&password=mypassword |
| # mondrian.jdbcDrivers=org.mariadb.jdbc.Driver |
| #driver.classpath=D:/mariadb-java-client-1.4.6.jar |
| # |
| # ### NuoDB ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:com.nuodb://localhost/foodmart?schema=mondrian |
| # mondrian.foodmart.jdbcUser=foodmart |
| # mondrian.foodmart.jdbcPassword=foodmart |
| # mondrian.jdbcDrivers=com.nuodb.jdbc.Driver |
| # mondrian.foodmart.jdbcSchema=mondrian |
| # driver.classpath=/opt/nuodb/jar/nuodbjdbc.jar |
| # |
| # ### Infobright ### |
| # As MySQL. (Infobright uses a MySQL driver, version 5.1 and later.) |
| # |
| # ### Ingres ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:ingres://192.168.200.129:II7/MondrianFoodMart;LOOP=on;AUTO=multi;UID=ingres;PWD=sergni |
| # mondrian.jdbcDrivers=com.ingres.jdbc.IngresDriver |
| # driver.classpath=c:/ingres2006/ingres/lib/iijdbc.jar |
| # |
| # ### Postgres: needs user and password ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:postgresql://localhost/FM3 |
| # mondrian.foodmart.jdbcUser=postgres |
| # mondrian.foodmart.jdbcPassword=pgAdmin |
| # mondrian.jdbcDrivers=org.postgresql.Driver |
| # |
| # ### Neoview ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:hpt4jdbc://localhost:18650/:schema=PENTAHO;serverDataSource=PENTAHO_DataSource |
| # mondrian.foodmart.jdbcUser=user |
| # mondrian.foodmart.jdbcPassword=password |
| # mondrian.jdbcDrivers=com.hp.t4jdbc.HPT4Driver |
| # driver.classpath=/some/path/hpt4jdbc.jar |
| # |
| # ### Netezza: mimics Postgres ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:netezza://127.0.1.10/foodmart |
| # mondrian.foodmart.jdbcUser=user |
| # mondrian.foodmart.jdbcPassword=password |
| # mondrian.jdbcDrivers=org.netezza.Driver |
| # driver.classpath=/some/path/nzjdbc.jar |
| # |
| # ### Sybase ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:jtds:sybase://xxx.xxx.xxx.xxx:port/dbName |
| # mondrian.foodmart.jdbcUser=user |
| # mondrian.foodmart.jdbcPassword=password |
| # mondrian.jdbcDrivers=net.sourceforge.jtds.jdbc.Driver |
| # driver.classpath=/some/path/jtds-1.2.jar |
| # |
| # ### Teradata ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:teradata://DatabaseServerName/DATABASE=FoodMart |
| # mondrian.foodmart.jdbcUser=user |
| # mondrian.foodmart.jdbcPassword=password |
| # mondrian.jdbcDrivers=com.ncr.teradata.TeraDriver |
| # driver.classpath=/some/path/terajdbc/classes/terajdbc4.jar |
| # |
| # ### Vertica ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:vertica://xxx.xxx.xxx.xxx:port/dbName |
| # mondrian.foodmart.jdbcUser=user |
| # mondrian.foodmart.jdbcPassword=password |
| # mondrian.jdbcDrivers=com.vertica.Driver |
| # driver.classpath=/some/path/vertica.jar |
| # |
| # ### Vectorwise ### |
| # |
| # mondrian.foodmart.jdbcURL=jdbc:ingres://xxx.xxx.xxx.xxxport/dbName |
| # mondrian.foodmart.jdbcUser=user |
| # mondrian.foodmart.jdbcPassword=password |
| # mondrian.jdbcDrivers=com.ingres.jdbc.IngresDriver |
| # driver.classpath=/some/path/iijdbc.jar |
| # |
| #mondrian.foodmart.jdbcURL=jdbc:odbc:MondrianFoodMart |
| |
| ############################################################################### |
| # Boolean property that controls whether to print the SQL code |
| # generated for aggregate tables. |
| # |
| # If set, then as each aggregate request is processed, both the lost |
| # and collapsed dimension create and insert sql code is printed. |
| # This is for use in the CmdRunner allowing one to create aggregate table |
| # generation sql. |
| # |
| mondrian.rolap.aggregates.generateSql=true |
| |
| ############################################################################### |
| # Boolean property that controls pretty-print mode. |
| # |
| # If true, the all SqlQuery SQL strings will be generated in |
| # pretty-print mode, formatted for ease of reading. |
| # |
| mondrian.rolap.generate.formatted.sql=true |
| |
| ############################################################################### |
| # Property that establishes the amount of chunks for querying cells |
| # involving high-cardinality dimensions. |
| # Should prime with #ResultLimit mondrian.result.limit. |
| # |
| #mondrian.result.highCardChunkSize=1 |
| |
| ############################################################################### |
| # Property that defines whether non-existent member errors should be |
| # ignored during schema load. If so, the non-existent member is treated |
| # as a null member. |
| # |
| #mondrian.rolap.ignoreInvalidMembers=false |
| |
| ############################################################################### |
| # Property that defines whether non-existent member errors should be |
| # ignored during query validation. If so, the non-existent member is |
| # treated as a null member. |
| # |
| #mondrian.rolap.ignoreInvalidMembersDuringQuery=false |
| |
| ############################################################################### |
| # Property that defines whether to ignore measure when non joining |
| # dimension is in the tuple during aggregation. |
| # |
| # If there are unrelated dimensions to a measure in context during |
| # aggregation, the measure is ignored in the evaluation context. This |
| # behaviour kicks in only if the CubeUsage for this measure has |
| # IgnoreUnrelatedDimensions attribute set to false. |
| # |
| # For example, Gender doesn't join with [Warehouse Sales] measure. |
| # |
| # With mondrian.olap.agg.IgnoreMeasureForNonJoiningDimension=true |
| # Warehouse Sales gets eliminated and is ignored in the aggregate |
| # value. |
| # |
| # [Store Sales] + [Warehouse Sales] |
| # SUM({Product.members * Gender.members}) 7,913,333.82 |
| # |
| # With mondrian.olap.agg.IgnoreMeasureForNonJoiningDimension=false |
| # Warehouse Sales with Gender All level member contributes to the aggregate |
| # value. |
| # |
| # [Store Sales] + [Warehouse Sales] |
| # SUM({Product.members * Gender.members}) 9,290,730.03 |
| # |
| # On a report where Gender M, F and All members exist a user will see a |
| # large aggregated value compared to the aggregated value that can be |
| # arrived at by summing up values against Gender M and F. This can be |
| # confusing to the user. This feature can be used to eliminate such a |
| # situation. |
| # |
| #mondrian.olap.agg.IgnoreMeasureForNonJoiningDimension=false |
| |
| ############################################################################### |
| # Integer property indicating the maximum number of iterations |
| # allowed when iterating over members to compute aggregates. A value of |
| # 0 (the default) indicates no limit. |
| # |
| #mondrian.rolap.iterationLimit=0 |
| |
| ############################################################################### |
| # Not documented. |
| # |
| #mondrian.test.Iterations=1 |
| |
| ############################################################################### |
| # Property containing a list of JDBC drivers to load automatically. |
| # Must be a comma-separated list of class names, and the classes must be |
| # on the class path. |
| # |
| #mondrian.jdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver,org.hsqldb.jdbcDriver,oracle.jdbc.OracleDriver,com.mysql.jdbc.Driver |
| |
| ############################################################################### |
| # Property that defines the JdbcSchema factory class which |
| # determines the list of tables and columns of a specific datasource. |
| # |
| # @see mondrian.rolap.aggmatcher.JdbcSchema |
| # |
| #mondrian.rolap.aggregates.jdbcFactoryClass= |
| |
| ############################################################################### |
| # Property which governs whether child members or members of a level are precached |
| # when child or level members are requested within a |
| # query expression. For example, |
| # if an expression references two child members in the store dimension, |
| # like { [Store].[USA].[CA], [Store].[USA].[OR] }, precaching will |
| # load *all* children under [USA] rather than just the 2 requested. |
| # The threshold value is |
| # compared against the cardinality of the level to determine |
| # whether or not precaching should be performed. If cardinality is |
| # lower than the threshold value Mondrian will precache. Setting |
| # this property to 0 effectively disables precaching. |
| # |
| #mondrian.rolap.precache.threshold=300 |
| |
| ############################################################################### |
| # String property that holds the |
| # name of the class whose resource bundle is to be used to for this |
| # schema. For example, if the class is com.acme.MyResource, |
| # mondrian will look for a resource bundle called |
| # com/acme/MyResource_locale.properties on the class path. |
| # (This property has a confusing name because in a previous release it |
| # actually held a file name.) |
| # |
| # Used for the mondrian.i18n.LocalizingDynamicSchemaProcessor; |
| # see <a>Internationalization</a> |
| # for more details. |
| # |
| # Default value is null. |
| # |
| #mondrian.rolap.localePropFile= |
| |
| ############################################################################### |
| # Set mondrian logging information if not provided by containing application. |
| # |
| # Examples: |
| # |
| # |
| # log4j.configuration=file://full/path/log4j.xml |
| # log4j.configuration=file:log4j.properties |
| # |
| #log4j.configuration= |
| |
| ############################################################################### |
| # Max number of constraints in a single 'IN' SQL clause. |
| # |
| # This value may be variant among database products and their runtime |
| # settings. Oracle, for example, gives the error "ORA-01795: maximum |
| # number of expressions in a list is 1000". |
| # |
| # Recommended values: |
| # |
| # * Oracle: 1,000 |
| # * DB2: 2,500 |
| # * Other: 10,000 |
| # |
| #mondrian.rolap.maxConstraints=1000 |
| |
| ############################################################################### |
| # Boolean property that defines the maximum number of passes |
| # allowable while evaluating an MDX expression. |
| # |
| # If evaluation exceeds this depth (for example, while evaluating a |
| # very complex calculated member), Mondrian will throw an error. |
| # |
| #mondrian.rolap.evaluate.MaxEvalDepth=10 |
| |
| ############################################################################### |
| # Property that defines |
| # limit on the number of rows returned by XML/A drill through request. |
| # |
| #mondrian.xmla.drillthroughMaxRows=1000 |
| |
| ############################################################################### |
| # Property that defines whether the MemoryMonitor should |
| # be enabled. By default it is disabled; memory monitor is not available |
| # before Java version 1.5. |
| # |
| #mondrian.util.memoryMonitor.enable=false |
| |
| ############################################################################### |
| # Property that defines |
| # the name of the class used as a memory monitor. |
| # |
| # If the value is |
| # non-null, it is used by the MemoryMonitorFactory |
| # to create the implementation. |
| # |
| #mondrian.util.MemoryMonitor.class= |
| |
| ############################################################################### |
| # Property that defines the default MemoryMonitor |
| # percentage threshold. If enabled, when Java's memory monitor detects |
| # that post-garbage collection is above this value, notifications are |
| # generated. |
| # |
| #mondrian.util.memoryMonitor.percentage.threshold=90 |
| |
| ############################################################################### |
| # Property that controls the maximum number of results contained in a |
| # NativizeSet result set. |
| # |
| # If the number of tuples contained in the result set exceeds this |
| # value Mondrian throws a LimitExceededDuringCrossjoin error. |
| # |
| #mondrian.native.NativizeMaxResults=150000 |
| |
| ############################################################################### |
| # Property that controls minimum expected cardinality required in |
| # order for NativizeSet to natively evaluate a query. |
| # |
| # If the expected cardinality falls below this level the query is |
| # executed non-natively. |
| # |
| # It is possible for the actual cardinality to fall below this |
| # threshold even though the expected cardinality falls above this |
| # threshold. In this case the query will be natively evaluated. |
| # |
| #mondrian.native.NativizeMinThreshold=100000 |
| |
| ############################################################################### |
| # Property determines if elements of dimension (levels, hierarchies, |
| # members) need to be prefixed with dimension name in MDX query. |
| # |
| # For example when the property is true, the following queries |
| # will error out. The same queries will work when this property |
| # is set to false. |
| # |
| # select {[M]} on 0 from sales |
| # select {[USA]} on 0 from sales |
| # select {[USA].[CA].[Santa Monica]} on 0 from sales |
| # |
| # When the property is set to true, any query where elements are |
| # prefixed with dimension name as below will work |
| # |
| # select {[Gender].[F]} on 0 from sales |
| # select {[Customers].[Santa Monica]} on 0 from sales |
| # |
| # Please note that this property does not govern the behaviour |
| # wherein |
| # |
| # [Gender].[M] |
| # |
| # is resolved into a fully qualified |
| # |
| # [Gender].[M] |
| # |
| # In a scenario where the schema is very large and dimensions have |
| # large number of members a MDX query that has a invalid member in it will |
| # cause mondrian to to go through all the dimensions, levels, hierarchies, |
| # members and properties trying to resolve the element name. This behavior |
| # consumes considerable time and resources on the server. Setting this |
| # property to true will make it fail fast in a scenario where it is |
| # desirable. |
| # |
| #mondrian.olap.elements.NeedDimensionPrefix=false |
| |
| ############################################################################### |
| # Property that defines |
| # the behavior of division if the denominator evaluates to zero. |
| # |
| # If false (the default), if a division has a non-null numerator and |
| # a null denominator, it evaluates to "Infinity", which conforms to SSAS |
| # behavior. |
| # |
| # If true, the result is null if the denominator is null. Setting to |
| # true enables the old semantics of evaluating this to null; this does |
| # not conform to SSAS, but is useful in some applications. |
| # |
| #mondrian.olap.NullDenominatorProducesNull=false |
| |
| ############################################################################### |
| # Property that determines how a null member value is represented in the |
| # result output. |
| # AS 2000 shows this as empty value |
| # AS 2005 shows this as "(null)" value |
| # |
| #mondrian.olap.NullMemberRepresentation=#null |
| |
| ############################################################################### |
| # Boolean property that determines whether Mondrian optimizes predicates. |
| # |
| # If true, Mondrian may retrieve a little more data than specified in |
| # MDX query and cache it for future use. For example, if you ask for |
| # data on 48 states of the United States for 3 quarters of 2011, |
| # Mondrian will round out to all 50 states and all 4 quarters. If |
| # false, Mondrian still optimizes queries that involve all members of a |
| # dimension. |
| # |
| #mondrian.rolap.aggregates.optimizePredicates=true |
| |
| ############################################################################### |
| # Property that defines the name of the factory class used |
| # to create maps of member properties to their respective values. |
| # |
| # If the value is |
| # non-null, it is used by the PropertyValueFactory |
| # to create the implementation. If unset, |
| # mondrian.rolap.RolapMemberBase.DefaultPropertyValueMapFactory |
| # will be used. |
| # |
| #mondrian.rolap.RolapMember.PropertyValueMapFactory.class= |
| |
| ############################################################################### |
| # Property defining |
| # where the test XML files are. |
| # |
| #mondrian.test.QueryFileDirectory= |
| |
| ############################################################################### |
| # Property that defines |
| # a pattern for which test XML files to run. Pattern has to |
| # match a file name of the form: |
| # querywhatever.xml in the directory. |
| # |
| # Example: |
| # |
| # |
| # mondrian.test.QueryFilePattern=queryTest_fec[A-Za-z0-9_]*.xml |
| # |
| #mondrian.test.QueryFilePattern= |
| |
| ############################################################################### |
| # Maximum number of simultaneous queries the system will allow. |
| # |
| # Oracle fails if you try to run more than the 'processes' parameter in |
| # init.ora, typically 150. The throughput of Oracle and other databases |
| # will probably reduce long before you get to their limit. |
| # |
| #mondrian.query.limit=40 |
| |
| ############################################################################### |
| # Property that defines the timeout value (in seconds) for queries. A |
| # value of 0 (the default) indicates no timeout. |
| # |
| #mondrian.rolap.queryTimeout=0 |
| |
| ############################################################################### |
| # Boolean property that determines whether Mondrian should read |
| # aggregate tables. |
| # |
| # If set to true, then Mondrian scans the database for aggregate tables. |
| # Unless mondrian.rolap.aggregates.Use is set to true, the aggregates |
| # found will not be used. |
| # |
| #mondrian.rolap.aggregates.Read=false |
| |
| ############################################################################### |
| # Integer property that, if set to a value greater than zero, limits the |
| # maximum size of a result set. |
| # |
| #mondrian.result.limit=0 |
| |
| ############################################################################### |
| # Maximum number of MDX query threads per Mondrian server instance. |
| # Defaults to 20. |
| # |
| #mondrian.rolap.maxQueryThreads=20 |
| |
| ############################################################################### |
| # Property that defines the interval value between |
| # polling operations performed by the RolapConnection shepherd thread. |
| # This controls query timeouts and cancellation, so a small value |
| # (a few milliseconds) is best. Setting this to a value higher than |
| # mondrian.rolap.queryTimeout will result the timeout not being enforced |
| # as expected. |
| # |
| # Default value is "1000ms". Default time unit is "ms". |
| # |
| #mondrian.rolap.shepherdThreadPollingInterval=1000ms |
| |
| ############################################################################### |
| # Property which defines which SegmentCache implementation to use. |
| # Specify the value as a fully qualified class name, such as |
| # org.example.SegmentCacheImpl where SegmentCacheImpl |
| # is an implementation of mondrian.spi.SegmentCache. |
| # |
| #mondrian.rolap.SegmentCache= |
| |
| ############################################################################### |
| # Maximum number of threads per Mondrian server instance that |
| # are used to run perform operations on the external caches. |
| # Defaults to 100. |
| # |
| #mondrian.rolap.maxCacheThreads=100 |
| |
| ############################################################################### |
| # Maximum number of threads per Mondrian server instance that |
| # are used to run SQL queries when populating segments. |
| # Defaults to 100. |
| # |
| #mondrian.rolap.maxSqlThreads=100 |
| |
| ############################################################################### |
| # Property that controls the behavior of |
| # Property#SOLVE_ORDER solve order of calculated members and sets. |
| # |
| # Valid values are "scoped" and "absolute" (the default). See |
| # mondrian.olap.SolveOrderMode for details. |
| # |
| #mondrian.rolap.SolveOrderMode=ABSOLUTE |
| |
| ############################################################################### |
| # Property that, with #SparseSegmentDensityThreshold, determines |
| # whether to choose a sparse or dense representation when storing |
| # collections of cell values in memory. |
| # |
| # When storing collections of cell values, Mondrian has to choose |
| # between a sparse and a dense representation, based upon the |
| # possible and actual number of values. |
| # The density is actual / possible. |
| # |
| # We use a sparse representation if |
| # (possible - |
| # #SparseSegmentCountThreshold countThreshold) * |
| # #SparseSegmentDensityThreshold densityThreshold > |
| # actual |
| # |
| # For example, at the default values |
| # (#SparseSegmentCountThreshold countThreshold = 1000, |
| # #SparseSegmentDensityThreshold = 0.5), |
| # we use a dense representation for |
| # |
| # |
| # * (1000 possible, 0 actual), or |
| # * (2000 possible, 500 actual), or |
| # * (3000 possible, 1000 actual). |
| # |
| # |
| # Any fewer actual values, or any more |
| # possible values, and Mondrian will use a sparse representation. |
| # |
| #mondrian.rolap.SparseSegmentValueThreshold=1000 |
| |
| ############################################################################### |
| # Property that, with #SparseSegmentCountThreshold, |
| # determines whether to choose a sparse or dense representation when |
| # storing collections of cell values in memory. |
| # |
| #mondrian.rolap.SparseSegmentDensityThreshold=0.5 |
| |
| ############################################################################### |
| # Property that defines the name of the class used in SqlMemberSource |
| # to pool common values. |
| # |
| # If the value is non-null, it is used by the |
| # SqlMemberSource.ValueMapFactory |
| # to create the implementation. If it is not set, then |
| # mondrian.rolap.SqlMemberSource.NullValuePoolFactory |
| # will be used, meaning common values will not be pooled. |
| # |
| #mondrian.rolap.SqlMemberSource.ValuePoolFactory.class= |
| |
| ############################################################################### |
| # Property that defines |
| # whether to enable new naming behavior. |
| # |
| # If true, hierarchies are named [Dimension].[Hierarchy]; if false, |
| # [Dimension.Hierarchy]. |
| # |
| #mondrian.olap.SsasCompatibleNaming=false |
| |
| ############################################################################### |
| # Comma-separated list of classes to be used to get statistics about the |
| # number of rows in a table, or the number of distinct values in a column. |
| # |
| # If there is a value for mondrian.statistics.providers.DATABASE, where |
| # DAtABASE is the current database name (e.g. MYSQL or ORACLE), then that |
| # property overrides. |
| # |
| # Example: |
| # |
| # |
| # mondrian.statistics.providers=mondrian.spi.impl.JdbcStatisticsProvider |
| # mondrian.statistics.providers.MYSQL=mondrian.spi.impl.JdbcStatisticsProvider,mondrian.spi.impl.JdbcStatisticsProvider |
| # |
| # This would use JDBC's statistics (via the |
| # java.sql.DatabaseMetaData.getIndexInfo method) for most |
| # databases, but for connections to a MySQL database, would use |
| # external statistics first, and fall back to JDBC statistics |
| # only if external statistics were not available. |
| # |
| #mondrian.statistics.providers= |
| |
| ############################################################################### |
| # String property that determines which test class to run. |
| # |
| # This is the name of the class. It must either implement |
| # junit.framework.Test or have a method |
| # public [static] junit.framework.Test suite(). |
| # |
| # Example: |
| # |
| # mondrian.test.Class=mondrian.test.FoodMartTestCase |
| # |
| # @see #TestName |
| # |
| #mondrian.test.Class= |
| |
| ############################################################################### |
| # Property containing the connect string which regression tests should |
| # use to connect to the database. |
| # |
| # Format is specified in Util#parseConnectString(String). |
| # |
| #mondrian.test.connectString= |
| |
| ############################################################################### |
| # Integer property that controls whether to test operators' |
| # dependencies, and how much time to spend doing it. |
| # |
| # If this property is positive, Mondrian's test framework allocates an |
| # expression evaluator which evaluates each expression several times, and |
| # makes sure that the results of the expression are independent of |
| # dimensions which the expression claims to be independent of. |
| # |
| # The default is 0. |
| # |
| #mondrian.test.ExpDependencies=0 |
| |
| ############################################################################### |
| # Property containing a list of dimensions in the Sales cube that should |
| # be treated as high-cardinality dimensions by the testing infrastructure. |
| # This allows us to run the full suite of tests with high-cardinality |
| # functionality enabled. |
| # |
| #mondrian.test.highCardDimensions= |
| |
| ############################################################################### |
| # Property containing the JDBC password of a test database. |
| # The default value is null, to cope with DBMSs that don't need this. |
| # |
| #mondrian.foodmart.jdbcPassword= |
| |
| ############################################################################### |
| # Property containing the JDBC user of a test database. |
| # The default value is null, to cope with DBMSs that don't need this. |
| # |
| #mondrian.foodmart.jdbcUser= |
| |
| ############################################################################### |
| # String property that determines which tests are run. |
| # |
| # This is a regular expression as defined by |
| # java.util.regex.Pattern. |
| # If this property is specified, only tests whose names match the pattern |
| # in its entirety will be run. |
| # |
| # @see #TestClass |
| # |
| #mondrian.test.Name= |
| |
| ############################################################################### |
| # Seed for random number generator used by some of the tests. |
| # |
| # Any value besides 0 or -1 gives deterministic behavior. |
| # The default value is 1234: most users should use this. |
| # Setting the seed to a different value can increase coverage, and |
| # therefore may uncover new bugs. |
| # |
| # If you set the value to 0, the system will generate its own |
| # pseudo-random seed. |
| # |
| # If you set the value to -1, Mondrian uses the next seed from an |
| # internal random-number generator. This is a little more deterministic |
| # than setting the value to 0. |
| # |
| #mondrian.test.random.seed=1234 |
| |
| ############################################################################### |
| # Property that returns the time limit for the test run in seconds. |
| # If the test is running after that time, it is terminated. |
| # |
| #mondrian.test.TimeLimit=0 |
| |
| ############################################################################### |
| # Boolean property that controls whether Mondrian uses aggregate |
| # tables. |
| # |
| # If true, then Mondrian uses aggregate tables. This property is |
| # queried prior to each aggregate query so that changing the value of this |
| # property dynamically (not just at startup) is meaningful. |
| # |
| # Aggregates can be read from the database using the |
| # #ReadAggregates property but will not be used unless this |
| # property is set to true. |
| # |
| #mondrian.rolap.aggregates.Use=false |
| |
| ############################################################################### |
| # Not documented. |
| # |
| #mondrian.test.VUsers=1 |
| |
| ############################################################################### |
| # Property that indicates whether this is a "warmup test". |
| # |
| #mondrian.test.Warmup=false |
| |
| ############################################################################### |
| # Property that controls whether warning messages should be printed if a SQL |
| # comparison test does not contain expected SQL statements for the specified |
| # dialect. The tests are skipped if no expected SQL statements are |
| # found for the current dialect. |
| # |
| # Possible values are the following: |
| # |
| # |
| # * "NONE": no warning (default) |
| # * "ANY": any dialect |
| # * "ACCESS" |
| # * "DERBY" |
| # * "LUCIDDB" |
| # * "MYSQL" |
| # * ... and any Dialect enum in SqlPattern.Dialect |
| # |
| # |
| # Specific tests can overwrite the default setting. The priority is: |
| # * Settings besides "ANY" in mondrian.properties file |
| # * < Any setting in the test |
| # * < "ANY" |
| # |
| #mondrian.test.WarnIfNoPatternForDialect=NONE |
| |
| ############################################################################### |
| # Connect string for the webapp. (Used by the webapp only.) |
| # |
| # To achieve access control, append say ;Role='California |
| # manager' to the connect string. |
| # |
| #mondrian.webapp.connectString=Provider=mondrian;Jdbc=jdbc:odbc:MondrianFoodMart;Catalog=/WEB-INF/queries/FoodMart.xml;JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver |
| |
| ############################################################################### |
| # Where mondrian.war will be deployed to. (Used by mondrian's build.xml ant file only.) |
| # |
| # Example: mondrian.webapp.deploy=C:/jboss-4.0.2/server/default/deploy |
| # |
| #mondrian.webapp.deploy= |
| |
| ############################################################################### |
| # Interval at which to refresh the |
| # list of XML/A catalogs. (Usually known as the |
| # datasources.xml file.) |
| # |
| # It is not an active process; no threads will be created. It only |
| # serves as a rate limiter. The refresh process is triggered by requests |
| # to the doPost() servlet method. |
| # |
| # Values may have time unit suffixes such as 's' (second) or 'ms' |
| # (milliseconds). Default value is 3000 milliseconds (3 seconds). |
| # Default time unit is milliseconds. |
| # |
| # See also |
| # mondrian.xmla.impl.DynamicDatasourceXmlaServlet. |
| # |
| #mondrian.xmla.SchemaRefreshInterval=3000ms |
| |
| # End mondrian.properties |
