Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All topics
Print

How to create the restricted version of AnalyticsGate Excel Add-In!

Restricted version of AnalyticsGate Excel Add-In

1.What is the Restrictive Version of AnalyticsGate Excel Add-In?

The Restrictive version of AnalyticsGate can be used to restrict which applications are displayed to the user in AnalyticsGate Excel Add-In.
Applications that are not available to the user due to Qlik Sense Security Rules will still not be displayed, even if they are tagged accordingly.

 

Please create an new TAG like “AnalyticsGate-AllowedApps”

 

Enable the TAG id and copy it!

 

Copy the TAG id:

Please create a new security rule for this tag or edit the existing rule:

 

Add the new TAG “AnalyticsGate-AllowedApps” to your Apps you like:

 

This display of applications can be controlled by a “tag” or directly by specifying the App-ID. In addition, the configuration settings of the Excel Add-In can be made centrally.

2. Set Up Restrictive Version

The configuration of the Restrictive Version of AnalyticsGate Excel Add-In is realized via a configuration file (Settings.json), which is uploaded to the AnalyticsGate Content Library (https://youserver/qmc/contentlibraries).

 

Without the named file, the Restrictive version of Excel Add-In will not be able to connect to Qlik Sense applications.
The configuration file is provided in a JSON format, a base file is attached.
The following is an overview of the main attributes:

{
"AllowedAppTags": [ "AnalyticsGate-AllowedAppTags"],
"AllowedAppIds": [],
"LocalSettingsAllowed": false,
"Settings": [
{...

 

After update / upload the new  “Settings.json” file to the Qlik Sense server and new added TAG “AnalyticsGate-AllowedApps” to your Apps it will be showing only the Apps with the “TAG = AnalyticsGate-AllowedApps“:

Description:
AllowedAppTags: A list of “tags” can be specified here. Apps that have such a “tag” will be displayed in the AnalyticsGate Excel add-in.

AllowedAppIds: A list of app IDs can be specified here. The apps from this list will also be displayed in the Excel Add-In.

LocalSettingsAllowed: This property can be used to define whether settings can be made by the client, i.e. by the user himself, or not. This property applies to all settings, but can be overridden for each setting item.

Settings: Under this property all settings can be made. The structure is always identical. First an ID of the setting, as second the value (“ItemValue”) and as third a setting, which can give the user the possibility to make the setting himself. (“LocalSettingsAllowed”). If the property “LocalSettingsAllowed” is set, the global value is overwritten for this setting.

Example settings.json file you can download from here: Settings.json


{
"AllowedAppTags": ["AnalyticsGate-AllowedApps"],
"AllowedAppIds": [],
"LocalSettingsAllowed": false,
"Settings": [
{
"ID": "DocumentAutoReConnect",
"ItemValue": "true",
"AllowLocal": false
},
{
"ID": "AGLicenseEndPoint",
"ItemValue": "https://license.analyticsgate.com",
"AllowLocal": false
},
{
"ID": "DisableSelectionsWhileSelectionToolIsopen",
"ItemValue": "false",
"AllowLocal": true
},
{
"ID": "DisableSelectionsWhileListboxIsopen",
"ItemValue": "false",
"AllowLocal": true
},
{
"ID": "OpenAppInSharedSession",
"ItemValue": "false"
},
{
"ID": "ShowUserInfo",
"ItemValue": "true"
},
{
"ID": "ShowUserInfo_SenseEV",
"ItemValue": "true"
},
{
"ID": "ShowUserInfoInEnglish",
"ItemValue": "false"
},
{
"ID": "KeepSessionAlive",
"ItemValue": "true"
},
{
"ID": "TerminateExcel",
"ItemValue": "true"
},
{
"ID": "OpenHubAfterConnect",
"ItemValue": "true"
},
{
"ID": "TruncateWarning",
"ItemValue": "True"
},
{
"ID": "AutoReConnect",
"ItemValue": "true"
},
{
"ID": "MaxParallelSenseEVCalculations",
"ItemValue": "10"
},
{
"ID": "GenerateChartImagesAfterAppLoad",
"ItemValue": "true"
},
{
"ID": "OpenAppTimeout",
"ItemValue": "150000"
},
{
"ID": "OpenConnectionTimeout",
"ItemValue": "150000"
},
{
"ID": "ClosedSessionTimeout",
"ItemValue": "30000"
},
{
"ID": "TerminateExcelTimeout",
"ItemValue": "50000"
},
{
"ID": "OpenReportWhenFinished",
"ItemValue": "true"
},
{
"ID": "AGToolsPath",
"ItemValue": ""
},
{
"ID": "AGChartRenderer",
"ItemValue": "true"
},
{
"ID": "AGChartRendererForCloud",
"ItemValue": "true"
},
{
"ID": "ShowAGChartRenderer",
"ItemValue": "false"
},
{
"ID": "IgnorePersonalXLSB",
"ItemValue": "PERSONAL.XLSB"
},
{
"ID": "IgnoreXLStartFolder",
"ItemValue": "true"
},
{
"ID": "ImportLocalSettings",
"ItemValue": ""
},
{
"ID": "ExportLocalSettings",
"ItemValue": ""
},
{
"ID": "ExportServerSettings",
"ItemValue": ""
},
{
"ID": "DisableLogEnigma",
"ItemValue": "true"
}
]
}
War dieser Artikel hilfreich?
0 out Of 5 Stars
5 Sterne 0%
4 Sterne 0%
3 Sterne 0%
2 Sterne 0%
1 Sterne 0%
Wie können wir diesen Artikel verbessern?
Please submit the reason for your vote so that we can improve the article.
Zurück Terminal Server Installation
Index