REST API Keys and Values for System Settings
Each system setting has its own REST API key name. For example, the REST API key for the system setting Cache Enable is EnableDataQueryCache. You use this REST API key to identify the system setting in a REST API operation.
For example, if you want to disable the Cache Enable setting, you
specify the name of the key (
EnableDataQueryCache) with the value
false.
{
"items":[
{
"key": "EnableDataQueryCache",
"value": "false"
}
]
}| System Setting Display Name | REST API Key | Key Value (UI Label)
|
|---|---|---|
| Allow HTML/JavaScript/CSS Content | AllowHTMLJavaScriptCSSContent |
|
| Always Use DBMS_RANDOM in Oracle Data Sources | AlwaysUseDBMSRANDOMOracleDataSources |
|
| Analytics Publisher Reporting Toolbar Mode | AnalyticsPublisherReportingToolbarMode | <Number between 1 and 6>
|
| Answers Editor Start Tab | AnswersEditorStartTab |
|
| Answers Subject Area Sorting Order | AnalysisSubjectAreaSortingOrder |
|
| Auto Apply Dashboard Prompt Values | AutoApplyDashboardPromptValues |
|
| Auto Search on Prompt Value Search Dialog | EnableAnalysisAutoSearchPromptDialog |
|
| Brushing Enabled for Data Sets | EnableBrushingDatasets |
|
| Brushing Enabled for Subject Areas | EnableBrushingSubjectAreas |
|
| Cache Dashboard Listing Dropdown Menu | CacheDashboardListingDropdownMenu |
|
| Cache Enable | EnableDataQueryCache |
|
| Case Insensitive Auto Complete | AutoCompletePromptDropDownsCaseInsensitive |
|
| Connection Externalization Enabled | EnableConnectionExternalization |
|
| Currencies XML | AnalysisCurrenciesXml | <Valid XML>
|
| Custom Links XML | CustomLinksXml | <Valid XML>
|
| Data Offset for Analyses and Dashboards | DefaultDataOffsetTimeZone | <Valid offset string>
|
| Default Limit Values By for Filters | DefaultLimitValuesByForFilters |
|
| Default Scrolling Enabled | AnalysisDefaultScrollingEnabled |
|
| Time Zone for Analysis, Dashboards, and Workbooks | DefaultTimeZoneforDateCalculations |
|
| Default User Time Zone | DefaultUserPreferredTimeZone |
|
| Disable Right Trim for VARCHAR Data | DataQueryDisableRightTrimVARCHARData |
|
| Enable Auto Insights on Datasets | EnableAutoInsightsDatasets |
|
| Enable Database Analytics Node in Data Flows | EnableDatabaseAnalyticsNodeDataFlows |
|
| Enable Enhanced Data Flow Diagram | EnableNewDataFlowDiagram |
|
| Enable Enhacement to Limit Value By in Workbooks | EnableEnhancementToLimitValuesByInWorkbooks |
|
| Enable Enrichments in Workbooks | EnableEnrichmentsInWorkbook |
|
| Enable Geometry Data Type | EnableGeometryType |
|
| Enable Immediate Dashboard Rendering | EnableImmediateDashboardRendering |
|
| Enable Personalization in Workbooks | EnablePersonalizationInWorkbooks |
|
| Enable Subrequest Shipping | EnableSubrequestShipping |
|
| Enable Usage Tracking | EnableUsageTracking |
|
| Enforce Safe Domains in Actions | EnforceSafeDomainsActions |
|
| Evaluate Support Level | EvaluateSupportLevel |
|
| Export Data to CSV and Tab-Delimited Files as Text | ExportDataToCSVFilesAsText |
|
| Hide EPM Cloud Members with No Access | HideEPMCloudMembersWithNoAccess |
|
| Hide loading messages | HideLoadingMessages |
|
| Load Semantic Models Using Multiple Threads | LoadSemanticModelsWithMultipleThreads |
|
| Locale | DataQueryLocale |
|
| Maximum Email Size (KB) | EmailMaxEmailSizeKB | <Number between 0 and 20,480>
|
| Maximum Number of Recipients per Email | EmailMaxRecipients | <Number between 0 and 1,024>
|
| Maximum Query Limit (seconds) | MaximumQueryLimit | <Number between 60 and 660>
|
| Maximum Working File Percent Size | MaximumWorkingFilePercentSize | <Number between 5 and 50> |
| OBIEE Compatibility Release | OBIEECompatibilityRelease |
|
| Override Database Features | OverrideDatabaseFeatures |
|
| Portal Path | PortalPath | <Valid path>
|
| Post Logout Redirect URL | PostLogoutRedirectURL | <Valid URL>
|
| Prompt Auto Complete Matching Level | AnalysisPromptAutoCompleteMatchingLevel |
|
| Query Limit Extension | QueryLimitExtension |
|
| Recursive Datetime Type Checking | RecursiveDatetimeTypeChecking |
|
| Repeat Rows on Excel Exports for Tables and Pivots | AnalysisRepeatRowsExcelExportsTablesPivots |
|
| Restrict Data Export and Delivery | RestrictDataExportAndDelivery |
|
| Safe Domains | EmailSafeDomains | <List of safe domains>
|
| Save Workbook Thumbnail | SaveWorkbookThumbnail |
|
| Show Null Value when Column is Nullable | AnalysisPromptsShowNullValueWhenColumnIsNullable |
|
| Sign Out Inactive Users Automatically | SignOutInactiveUsersAutomatically |
|
| Sort Null Values First | SortNullValuesFirst |
|
| Sort Order Locale | DataQuerySortOrderLocale |
|
| Strong Datetime Type Checking | StrongDatetimeTypeChecking |
|
| Support Auto Complete | EnableAnalysisAutoCompletePrompt |
|
| Table/Pivot View: Maximum Visible Rows | TablePivotViewMaximumVisibleRows | <Number between 100 and 5000>
|
| TLS Connection Mode | TLSConnectionMode |
* Legacy mode not available if you switched to Enhanced mode before the July update. |
| URL for Blocking Queries in Analyses | QueryBlockingScriptURL | <Valid URL>
|
| URL for Browser Script Actions | URLBrowserScriptActions | <Valid URL>
|
| Usage Tracking Connection Pool | UsageTrackingConnectionPool | <Valid connection pool>
|
| Usage Tracking Init Block Table | UsageTrackingInitBlockTable | <Valid table name> |
| Usage Tracking Logical Query Logging Table | UsageTrackingLogicalQueryLoggingTable | <Valid table name>
|
| Usage Tracking Maximum Rows | UsageTrackingMaximumRows | <Number between 0 and 100,000>
|
| Usage Tracking Physical Query Logging Table | UsageTrackingPhysicalQueryLoggingTable | <Valid table name>
|
| Use BCC | EmailUseBcc |
|
| Use RFC 2231 Encoding | EmailUseRFC2231 |
|
| Use Vanity URL to Share Content in Email | VanityURLShareContentInEmail | <Valid URL>
|
| User Currency Preferences XML | UserCurrencyPreferencesXml | <Valid XML>
|
| User Inactivity Timeout (minutes) | UserInactivityTimeout | <Number between 4 and 480> |
| User Names as the User Identifier in Service Logs | UserNamesInServiceLogs |
|
| View Interactions: Add/Remove Values | AnalysisViewInteractionsAddRemoveValues |
|
| View Interactions: Create/Edit/Remove Calculated Items | AnalysisViewInteractionsCreateEditRemoveCalculatedItems |
|
| View Interactions: Create/Edit/Remove Groups | AnalysisViewInteractionsCreateEditRemoveGroups |
|
| View Interactions: Display/Hide Running Sum | AnalysisViewInteractionsDisplayHideRunningSum |
|
| View Interactions: Display/Hide Sub-totals | AnalysisViewInteractionsDisplayHideSubtotals |
|
| View Interactions: Drill | AnalysisViewInteractionsDrill |
|
| View Interactions: Include/Exclude Columns | AnalysisViewInteractionsIncludeExcludeColumns |
|
| View Interactions: Move Columns | AnalysisViewInteractionsMoveColumns |
|
| View Interactions: Sort Columns | AnalysisViewInteractionsSortColumns |
|
| WriteBack Template XML | WriteBackTemplateXML | <Valid XML>
|