Basic Configurations

The file insight.properties is located in the directory conf. This section details some configurations in the property file. After modifying configurations, you should restart the system to apply the changes.

1. Common configuration
2. Semantic Service module configuration
3. MDX module configuration

1. Common configuration

Properties	Description
insight.kylin.host	This parameter specifies the IP address or Hostname of the Kylin server to be connected,such as `127.0.0.1`.The default is`localhost`
insight.kylin.port	This parameter specifies the port of the Kylin server that needs to be connected, default is`7070`
insight.semantic.context-path	This parameter specifies the context-path in MDX for Kylin, default is`/`
insight.kylin.ssl	MDX for Kylin access Kylin is https enabled, default is`false`
insight.database.type	MDX for Kylin metadata database type, default is`mysql`
insight.database.useSSL	Does MDX for Kylin Metabase use SSL connection, default is`false`
insight.database.ip	The IP address or Hostname of the Metabase that MDX for Kylin needs to connect to, default is`localhost`
insight.database.port	The port of MDX for Kylin Metabase that MDX for Kylin needs to connect to, default is`3306`
insight.database.name	MDX for Kylin needs to connect to Metabase name, default is`insight`
insight.database.username	MDX for Kylin needs to connect to the user name of the metabase, default is`root`
insight.database.password	This configuration is used to generate diagnostic packets. This configuration item requires you to fill in the IP and Port information of all nodes in the MDX for Kylin cluster. If you configure multiple nodes, separate them with commas, such as `insight.mdx.cluster.nodes=IP_1:Port_1,IP_2:Port_2`

2. Semantic Service module configuration

Properties	Description
insight.semantic.datasource-version	This parameter specifies the version number of Kylin connected to the semantic service in MDX for Kylin. Only support `2`
insight.semantic.port	This parameter specifies the port of the semantic service in MDX for Kylin, default is`7080`
insight.semantic.meta.sync.project-page-size	This parameter specifies the maximum number of projects that can be obtained in a single page when the semantic service in MDX for Kylin synchronizes projects , default is`1000`
insight.dataset.verify.interval.count	This parameter specifies the time interval for the semantic service in MDX for Kylin to verify the data set, unit: 20 seconds, for example: 2 means 2 * 20 = 40 seconds. It takes effect only when `insight.dataset.verify.enable` is configured as true, default is`15`, which is 5 minutes
insight.dataset.verify.enable	This parameter specifies whether the semantic service in MDX for Kylin enables the data set synchronization verification function, default is`true`
insight.semantic.model.version.verify	This parameter specifies whether the semantic service in MDX for Kylin enables metadata model version checking, default is`false`
insight.semantic.startup.sync.enable	This parameter specifies whether the semantic service in MDX for Kylin starts the synchronization task when the startup service is enabled, default is`true`
insight.semantic.segment.sync.enable	This parameter specifies whether the semantic service in MDX for Kylin is enabled. Check Kylin's Segment changes, and clear MDX for Kylin cache according to Segment changes, default is`true`
insight.semantic.meta.sync.user-page-size	This parameter specifies the size of each page when the semantic service in MDX for Kylin synchronizes user information from Kylin, default is`100000`
insight.semantic.cookie-age	This parameter specifies the lifetime of the user cookie when accessing the semantic service Web UI in MDX for Kylin, default is`86400`, which is 86400 seconds
insight.semantic.checkout.dataset.connect	This parameter specifies whether to check the connection when MDX for Kylin data set is saved, default is`true`
insight.semantic.connect.timeout	The connection timeout time of MDX for Kylin to Kylin, in milliseconds, default is`5000`
insight.semantic.socket.timeout	MDX for Kylin connection socket timeout time for Kylin connection, unit is milliseconds, default is`10000`
insight.semantic.connection.request.timeout	The connection request timeout time of MDX for Kylin to Kylin, the unit is milliseconds, default is`8000`
insight.semantic.max-http-header-size	The maximum length of MDX for Kylin's http request header, the unit is kb, default is`8192`
insight.semantic.meta.keep.mdx-query.max.rows	The maximum number of mdx query history records in the system，default is `1000000`
insight.semantic.segment.sync.enable	whether to synchronize the segment information of Kylin, default is `true`
insight.kylin.only.normal.dim.enable	MDX for Kylin only fetch normal dimension from Kylin when the join condition is many-to-many, default is `false`, current kylin not support many-to-many
insight.semantic.zookeeper.enable	Whether enable to register server info to ZooKeeper, default is `false`
insight.semantic.zookeeper.address	The address of ZooKeeper, default is `localhost:2181`
insight.semantic.zookeeper.node.path	The node path in ZooKeeper, default is `/mdx`
insight.semantic.zookeeper.session.timeout	The session timeout with ZooKeeper, default is `30000`
insight.semantic.reject.enable	This parameter is used to specify whether to enable the interception strategy. After enabling, the query request that meets the interception strategy will be rejected. The default is `false`.

3. MDX module configuration

Properties	Description
insight.mdx.servlet-path	This parameter specifies the servlet path in MDX for Kylin, default is`/mdx/xmla/`
insight.mdx.gateway-path	This parameter specifies the gateway servlet path in MDX for Kylin, default is`/mdx/xmla_server/`
insight.mdx.optimize-enabled	This parameter specifies whether to enable statement optimization for mdx in MDX for Kylin, default is`true`
insight.mdx.calculate-total-need	This parameter specifies whether mdx in MDX for Kylin calculates global summaries and subtotals, default is`true`
insight.mdx.schema.create-from-dataset	This parameter specifies whether mdx in MDX for Kylin will create a schema from the dataset, default is`true`
insight.mdx.schema.refresh.disable	This parameter specifies whether to disable refresh for mdx in MDX for Kylin, default is`false`
insight.mdx.sql.orderby.enable	This parameter specifies whether to enable SQL orderby in MDX for Kylin, default is`true`
insight.mdx.sql.calcite-engine-hint.enable	This parameter specifies whether Kylin is forced to use the Calcite engine when MDX for Kylin is connected to Excel and queries containing similar to are performed. Answer, default is`false`
insight.mdx.skip-axis-nonempty-check	This parameter specifies whether to skip the null value check when calculating the axis in MDX for Kylin, default is`true`
insight.mdx.mondrian.olap.case.sensitive	This parameter specifies whether the mdx statement in MDX for Kylin is case sensitive, default is`true`
insight.mdx.mondrian.rolap.maxQueryThreads	This parameter specifies the maximum number of query threads for mdx in MDX for Kylin, default is`50`
insight.mdx.mondrian.query.sql.page.size	This parameter specifies the maximum number of records obtained in a single page during mdx paging operation in MDX for Kylin, default is`10000`
insight.mdx.mondrian.rolap.generate.formatted.sql	This parameter specifies whether mdx in MDX for Kylin should format the output sql statement, default is`false`
insight.mdx.mondrian.rolap.star.disableCaching	This parameter specifies whether to disable caching for mdx in MDX for Kylin, default is`false`
insight.mdx.mondrian.rolap.ignoreInvalidMembers	This parameter specifies whether mdx in MDX for Kylin ignores invalid members, default is`true`
insight.mdx.mondrian.rolap.ignoreInvalidMembersDuringQuery	This parameter specifies whether mdx in MDX for Kylin ignores invalid members in queries, default is`true`
insight.mdx.mondrian.cache.expire-minute	This parameter specifies that the mdx cache expiration time in MDX for Kylin is several minutes, default is`720`
insight.mdx.mondrian.olap.pure-axes-calculate.source.type	This parameter specifies the dimensional data source type when calculating the mdx axis in MDX for Kylin. The optional parameters are: `SNAPSHOT`, `PARTIAL_CUBE`, `ALL_CUBE`, default is`PARTIAL_CUBE`
insight.mdx.mondrian.olap.pure-axes-calculate.cardinality-gap	This parameter specifies the maximum cardinality (exclusive) of dimension table that any SQL on a single dimension table in MDX for Kylin is forced to behavior like `insight.mdx.mondrian.olap.pure-axes-calculate.source.type=SNAPSHOT`, the special value `-1` means always forced and `0` means not forced, default is `-1`
insight.mdx.mondrian.olap.pure-axes-calculate.total-cardinality-gap	This parameter specifies the maximum cardinality (exclusive) of any total-axis SQL result that the SQL is forced to behavior like `insight.mdx.mondrian.olap.pure-axes-calculate.source.type=SNAPSHOT`, the special value `-1` means always forced and `0` means not forced, default is `0`
insight.mdx.mondrian.olap.support-non-default-all-member	This parameter specifies whether mdx in MDX for Kylin supports non-default all members, default is`false`
insight.mdx.mondrian.olap.cell.calc.join-dims	This parameter specifies whether mdx in MDX for Kylin joins other dimension tables when calculating the cell, default is`true`
insight.mdx.mondrian.rolap.return-null-when-divide-zero	This parameter specifies whether mdx in MDX for Kylin returns 0 when the divisor is 0, default is`true`
insight.mdx.mondrian.rolap.optimize-tuple-size-in-aggregate.enable	This parameter specifies whether to enable tuple size optimization during mdx aggregation in MDX for Kylin, default is`false`
insight.mdx.mondrian.rolap.calculate-cell-when-non-measure	This parameter specifies whether to aggregate cell data when mdx in MDX for Kylin has no measurement, default is`false`
insight.mdx.mondrian.sql.fetch-dim-from-snapshot	This parameter specifies whether mdx in MDX for Kylin prefers to pull dimension data from snapshots, default is`true`
insight.mdx.mondrian.sql.enableOrderBy	This parameter specifies whether to add collation when querying mdx sql in MDX for Kylin, default is`true`
insight.mdx.mondrian.jdbc.timezone	This parameter specifies the time zone of the mdx jdbc query service in MDX for Kylin, default is`GMT+8:00`
insight.mdx.mondrian.schema.init-level-group-order-by-key	This parameter specifies whether mdx in MDX for Kylin is to initialize the level by key value, default is`true`
insight.mdx.mondrian.query.filter-pushdown.enable	This parameter specifies whether mdx in MDX for Kylin is enabled for filtering pushdown, default is`true`
insight.mdx.mondrian.query.filter-pushdown.in-clause-max-size	This parameter specifies the maximum filtering pushdown number of mdx clauses in MDX for Kylin, default is`20`
insight.mdx.mondrian.query.sql.customize.enable	This parameter specifies whether to enable customization of mdx in MDX for Kylin sql, default is`true`
insight.mdx.mondrian.query.sql.customize.class	This parameter specifies the implementation class of mdx CustomizeSqlQuery in MDX for Kylin, default is`io.kylin.mdx.web.mondrian.rolap.sql.KylinSqlQuery`
insight.mdx.mondrian.query.sql.max.size	This parameter specifies the maximum number of query rows for mdx sql query in MDX for Kylin, default is`50000`
insight.mdx.mondrian.rolap.star.disableLocalSegmentCache	This parameter specifies whether to enable local cache for the segments queried by mdx in MDX for Kylin, generate specific cache and find block cache SPI, default is`false`
insight.mdx.mondrian.olap.triggers.enable	This parameter specifies whether to notify Mondrian when the configuration properties of mdx in MDX for Kylin change?`true`
insight.mdx.mondrian.rolap.nonempty	This parameter specifies whether mdx in MDX for Kylin needs non-empty setting for each query axis, default is`false`
insight.mdx.mondrian.rolap.compareSiblingsByOrderKey	This parameter specifies whether mdx in MDX for Kylin checks sibling members and pulls members from the original expression for verification, default is`false`
insight.mdx.mondrian.rolap.maxSqlThreads	This parameter specifies the maximum number of Mondrian instances that mdx supports SQL in MDX for Kylin, default is`100`
insight.mdx.mondrian.rolap.maxCacheThreads	This parameter specifies the maximum number of threads per Mondrian instance when mdx in MDX for Kylin supports caching, default is`100`
insight.mdx.mondrian.rolap.queryTimeout	Set the timeout time of MDX query, in seconds, default is`300`
insight.mdx.mondrian.olap.NullMemberRepresentation	This parameter specifies how to display the mdx in MDX for Kylin when the result is empty, default is`#null`
insight.mdx.mondrian.visualtotal.solve.order	This parameter specifies the mdx setting total order in MDX for Kylin, default is`-1`
insight.mdx.mondrian.cross-join.native.enable	This parameter specifies whether to use Cross Join natively when MDX for Kylin sends queries, default is`true`
insight.mdx.mondrian.filter.row.limit	This parameter specifies whether to add the Limit condition when MDX for Kylin is connected to Excel and perform Filter operation. The default is `0`, which means that the Limit condition is not added. If it is `10`, the SQL clause of limit 10 will be added to the query. Note: The parameters here must be written in positive integer, otherwise it will cause MDX query execution to report an error. Note: After setting this parameter, it may result in the inverse selection operation of the drop-down list in Excel Data incomplete, default is`0`
insight.mdx.mondrian.result.limit	This parameter is used to specify the number of rows returned by the check SQL and the number of cells. If the limit is exceeded, an error will be returned directly. , default is`100000`
insight.mdx.mondrian.mdprop.mdx.subqueries	This parameter is used to indicate the mdx support level for subqueries. MDX defaults to 2 and does not support subqueries. If you need MDX to support subqueries, you can set it to 31, which is a beta version.
insight.mdx.mondrian.query.sql.model-priority-hint.enable	This parameter enables whether to specify model priorities in SQL statements.If enabled, the model referenced by the dataset will be specified as the high priority model in the SQL statements. The default value is `false`. Please note that model priorities will take effect only if the querying measures are all from the same Kylin model.
insight.mdx.xmla.support-rowset-visibilities	This property is used to define whether to enable the support for `HIERARCHY_VISIBILITY` and `MEASURE_VISIBILITY` restrictions of XML/A Schema. The default value of this property is `false`. After this property has been enabled, previous Excel files with pivot tables must be fixed, otherwise Excel will not work properly with these files.
insight.mdx.mondrian.query.limit	This parameters is that maximum number of simultaneous queries the system will allow, default is 1000.

results matching ""

No results matching ""