Configuration Settings

Some limits prevents slow response and rendering in older browsers. All default values could be changed to raise limit values.

Maximum allowed members (Items) on each axis in the OLAP analysis grid.
<add key="MaxAxisMembers" value="4000"/>

Maximum allowed number of cells returned by the OLAP analysis analysis.
<add key="MaxReturnedCells" value="50000"/>

Maximum allowed number of rows returned by the OLAP drillthrough.
<add key="MaxRowsDrillthrough" value="1000"/>

Maximum allowed number of members while searching for members.
<add key="MaxMembersSearch" value="10000"/>

Assign user credentials for user that is used for Active Directory users and groups search within Kyubit Business Intelligence application. These values could be set in Kyubit Business Intelligence setup process, but when user credentials need to be changed, edit values in web.config file.

<add key="ActiveDirectorySearchUserName" value="kyubit\userX"/>

<add key="ActiveDirectorySearchUserPassword" value="xxxxxxx"/>

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.

Examples...
<add key="FolderAnalaysisSorting" value="ORDER BY Title"/>
<add key="FolderAnalaysisSorting" value="ORDER BY AnalysisID Desc"/>
<add key="FolderAnalaysisSorting" value="ORDER BY DataSourceName Desc, CreatedBy, Title"/>

To configure Kyubit Business Intelligence to work with local machine users and groups, instead of Active Directory, set following value to web.config value:

<add key="ADMachineSearchContext" value="LOCALMACHINENAME"/>

To configure Kyubit Business Intelligence to work in “Windows Explicit Authentication” mode, set following value to web.config value:

<add key="LoginForm" value="1"/>

To configure Kyubit BI not to display filters while exporting Dashboard to PDF file, set following value to web.config value:

<add key="HideDashboardPDFFilters" value="1" />

To configure Kyubit BI application sections could be used only by, set “1” value to web.config values:

Only administrator can manage with data sources:
<add key="OnlyAdminCubes" value="0" />

Only administrator can manage subscriptions:
<add key="OnlyAdminSubscriptions" value="0" />

Only administrator can manage OLAP Shared Items:
<add key="OnlyAdminSharedItems" value="0" />

Only administrator can manage KPIs:
<add key="OnlyAdminKPI" value="0" />

Only administrator can manage queries:
<add key="OnlyAdminQueries" value="0" />

Only administrator can create new folders:
<add key="OnlyAdminCreateFolder" value="0" />

Only administrator can create analysis: <add key="OnlyAdminCreateAnalysis" value="0" />

Only administrator can create dashboard:
<add key="OnlyAdminCreateDashboard" value="0" />

Only administrator can create subscription without impersonation:
<add key="OnlyAdminSubscriptionWithoutImpersonation" value="0" />