Customize Kyubit BI web application behaviour related to various aspects of application usage to meet your environment requests.
In order to change configurable details, open web.config file located in Kyubit Business Intelligence installation path
(Typically, C:\Program Files\Kyubit\BusinessIntelligence) and change one of the configuration settings which exists in the
||Maximum allowed members (Items) on
each axis in the OLAP analysis grid. (Default value, 20000)
||Maximum allowed number of cells returned by the OLAP analysis. (Default value, 50000)
||Maximum allowed number of rows returned by the OLAP drillthrough. (Default value, 250000)
||Maximum allowed number of members while searching for members. (Default value, 10000)
||Managed from setup.exe. Start setup.exe and in upper right corner select ‘wheel’ button to configure new value.
||Managed from setup.exe. Start setup.exe and in upper right corner select ‘wheel’ button to configure new value
||Default sorting in Kyubit Business Intelligence folders could be applied to 4 columns (AnalysisID, Title, DataSourceName and CreatedBy). Any combination of four columns is allowed, separated with comma. Descending sort order is defined with keyword "Desc" after column name. For example… “ORDER BY DataSourceName Desc, CreatedBy, Title”
||To configure Kyubit Business Intelligence to work with local machine users and groups, instead of Active Directory, set your local machine name in the setting.
||Configuring authentication modes. Please read section 1.4 of Administration manual for more details.
||To configure Kyubit BI not to display filters while exporting Dashboard to PDF file, set value to “1”.
||To allow that only administrator can manage data sources, set value to “1”.
||To allow that only administrator can manage subscriptions, set value to “1”.
||To allow that only administrator can manage OLAP Shared Items section, set value to “1”.
||To allow that only administrator can manage KPI section, set value to “1”.
||To allow that only administrator can manage Queries section, set value to “1”.
||To allow that only administrator can create new folders, set value to “1”.
||To allow that only administrator can create new analysis, set value to “1”.
||To allow that only administrator can create new dashboard, set value to “1”.
||Set delimiter character which will be applied when exporting analysis to CSV file. (Default value is “,”)
||When creating a data source in Kyubit application, all data source connectivity details are encrypted for security reasons using following configuration. To disable encryptions set value to „0“. (Default value is “1”)
||Default aggregate function in OLAP analysis, applied only if user did not select his preference in 'User Settings' form. Possible values: None=0, Sum=1, Min=2, Max=3, Count=4, Avg=5, [All]=6. (Default value is “1”)
||To set more detailed logging of application errors, related to export of dashboard to PDF.
||To disable dashboard 'Commenting' features completely, set value to „1“.
||To avoid application tracking of user actions in the application, set value to „1“.
||To disable dashboard features completely, set value to „1“.
||To disable user settings form, set value to „1“.
||Default OLAP filter member selection method/Tab ( 0 = Browse, 1 = Search).
||If user did not select his default data translation language, this value will be used. This setting is applicable if OLAP cube is built with different data translation language options. (For example. None=0, French=1036, Russian=1049, etc.)
||Automatic Windows User activation. First time user connects to application, will be automatically added to application users. (Default value is „1“). If this setting is set to „0“, each new user needs to me manually added to application in Administration -> Users & Admin form.
Note, that even if user will automatically become application user, he will not get authorization to any created application object. Authorization to particular application object (Analysis, Dashboard, etc.) needs to be manually assign by the person with permissions Read/Write on particular object.
||Set Kyubit application to work in Multitenant mode. Requires „LoginForm“ setting to be „2“ (Multitenant mode works only with 'Kyubit Users and Groups Authentication'). For more details read about 'Multitenant' section of the Administration user manual.
||By default, all subscriptions (to send analysis or dashboard on email) are executed in the context of the user who created subscription.
Setting this value to “1” will disregard credentials of the subscription creators and subscriptions will be send in the context of the Windows account running Kyubit Subscription service.
||While exporting dashboard to ‘Simple PDF’, set this value to “1” to minimize ‘Table charts’ on the dashboard. Displaying only ten rows and two columns at most.
|TopMargin, RightMargin, BottomMargin, LeftMargin
||Sets margins defaults when exporting dashboard to PDF file. Default values are TopMargin=20, RightMargin=30, BottomMargin=20 and LeftMargin=40.
||Sets default 'Font Size' defaults when exporting dashboard to PDF file.
||While analyzing in Grid/Chart view, OLAP connection is kept alive for performance reasons. To reset connection after each MDX query, set this value to „1“.
||By default, all OLAP cube structure is retrieved in Grid analysis. To retrieve OLAP cube structure partially, as individual measures/dimensions are selected, set this value to „1“. Could have significant performance gains when using OLAP cubes with many measures and dimensions.
||Administrators are managed in application sections ‘Administration’, but here is
additional option to configure additional administrator by his login
name, without entering application