You must enable javascript in order to view this page or you can go
here
to view the webhelp.
Arcadia Enterprise
Documentation
Content
Search Results
Loading, please wait ...
Arcadia Enterprise
Product Documentation
Release Notes
Release Notes
4.5.0.2
4.5.0.1
4.5.0.0
4.4.0.1
4.4.0.0
4.3.0.0
4.2.1.0
ArcViz
4.2.0.0
ArcViz
ArcEngine
4.1.2.0
4.1.1.0
4.1.0.0
ArcViz
ArcEngine
4.0.2.3
4.0.2.0
4.0.1.0
4.0.0.0
Quick Start Guide
Managing Your Account
Login
Changing Your Password
Checking
Arcadia Enterprise
Version
Logout
Understanding the Web Interface
Exploring a Sample Application
Creating a New Connection
Creating Datasets
Creating Dashboards
Visualization Guide
About Data Visualization
Visuals Interface
Apps
Overview of App Designer
Creating New Apps
Adding Dashboards to Tabs
Saving New Apps for the First Time
Adding Tabs
Changing Datasets in Apps
Removing Tabs from Apps
Removing Dashboards from Tabs
Rearranging Dashboards
Rearranging Tabs
Launching Apps
Changing App Workspace
Cloning Apps
Deleting Apps
Apps Security Model
Workspace
Creating New Workspaces
Changing Workspace Properties
Deleting Workspaces
Dashboards
Visual Designer for Dashboards
Creating Dashboards
Viewing Dashboards
Using Dashboard Controls
Cloning Dashboards
Adding Dashboards to Favorites
Set as Hompepage
Emailing Dashboards
Downloading Dashboards and Sheets as PDF Files
Downloading Current Sheet as a PDF File
Downloading Current Sheet with One Visual per Page as a PDF File
Downloading Entire Dashboard with One Sheet per Page as a PDF File
Exporting Dashboards
Moving Dashboards
Refreshing Visuals Manually
Deleting Dashboards
Sheets
Renaming Sheets
Creating New Sheets
Adding Visuals to a Sheet
Adding Filters to a Sheet
Moving/Reordering Sheets
Cloning Sheets
Adding External Sheets (Cloning)
Sheet URLs
Downloading Sheets as PNG Files
Downloading Sheets as PDF Files
Emailing Sheets
Deleting Sheets
Visuals
Visual Builder for Visuals
Creating Visuals
Cloning Visuals
Linking Visuals
Unlinking Visuals
Setting Current Visual as Homepage
Emailing Visuals
Exporting Visuals
Downloading Visuals as PNG Files
Downloading Visuals as PDF Files
Downloading Visual Data to CSV Files
Saving Tables As...
Materialized Table
Logical View
New Dataset Based on Query
Removing Visuals
Deleting Visuals
Visual Type Catalog
Table
Shelves for Table Visuals
Cross Tabulation
Displaying Totals With Data Expansion
Shelves for Cross Tabulation Visuals
Bars
Filtering by Year
Filtering by Region
Horizontal Bars
Stacked Bars
Labelled Bars
Shelves for Bar Visuals
Lines
Line Visuals with Dual Axes
Shelves for Line Visuals
Combo Visuals
General Bar and Line Chart Visuals
Using Secondary Axis
Changing Lines to Areas
Shelves for Combo Visuals
Areas
Area Visual with Trellis Option
Area Visuals Trellis with Independent Scale
Shelves for Area Visuals
Grouped Bars
Shelves for Grouped Bar Visuals
KPI / Single Value Visuals
Shelves for KPI Visuals
Gauge Visuals
Shelves for Gauge Visuals
Bullet Visuals
Shelves for Bullet Visuals
Box Plot Visuals
Shelves for Box Plot Visuals
Packed Bubbles
Shelves for Packed Bubbles Visuals
Word Cloud Visuals
Trellised Word Clouds
Shelves for Word Cloud Visuals
Scatter Visuals
Basic Scatter Visual
Adding Size
Adding Transition Animation
Adding Trellises
Shelves for Scatter Visuals
Flow Visuals
Shelves for Flow Visuals
Funnel Visuals
Shelves for Funnel Visuals
Pie Visuals
Shelves for Pie Visuals
Radial Visuals
Trellised Radial
Shelves for Radial Visuals
Chord Visuals
Shelves for Chord Visuals
Network Visuals
Shelves for Network Visuals
Advanced Options
Same Source and Target
Network Visuals: Link Color Menu
Network Visuals: Link Color Shelf
Network Visuals: Link Width Shelf
Network Visuals: Link Legend
Network Visuals: Node Size Shelves
Network Visuals: Nodes Color Menu
Network Visuals: Node Color Shelves
Network Visuals: Node Legend
Dendrogram Visuals
Shelves for Dendrogram Visuals
Treemap Visuals
Shelves for Treemap Visuals
Correlation Heat Map
Shelves for Correlation Heatmap Visuals
Correlation Flow
Shelves for Correlation Flow Visuals
Calendar Heat Map
Shelves for Calendar Heatmap Visuals
Maps
Country Map, Choropleth
Country Map, Bubbles
State Map, Choropleth
State Map, Bubbles
County Map, Choropleth
County Map, Bubbles
Zipcode Map, Bubbles
Lat./Long. Map, Bubbles
DMA Map, Choropleth
Canadian Province Map, Choropleth
Canadian Province Map, Bubbles
Canadian Postal Code Map, Choropleth
Canadian Postal Code Map, Bubbles
Shelves for Map Visuals
Interactive Maps
Basic Interactive Map Visuals
Creating Choropleth Interactive Map Visuals
Interactive Maps with Multiple Dimensions
Interactive Maps with Multiple Measures
Map Servers
Layer Options
Plotting Routes on Interactive Maps
Using Alphabetic Values on Color Shelf of Interactive Maps
Segmenting Data Qualitatively on Color Shelves of Interactive Maps
Shelves for Interactive Map Visuals
Sparklines
Shelves for Sparklines Visuals
URL Links
Shelves for External Link Visuals
Histograms
Shelves for Histogram Visuals
Extension Visuals, Simple
Examples of Extension Visuals
Rich Text Visuals
Inserting URL Links
Inserting Tables
Inserting Images
Inserting Videos
Field Statistics Visuals
SQL Query Visuals
Data Discovery Through Context Menus
Drill Down and Drill Up Data Discovery
Drill Through Data Discovery
Drill Into Data Discovery
Filter All Data Discovery
Detailed Data Discovery
Filter Data Using the Include Option in the Context Menu
Filter Data Using the Exclude Option in the Context Menu
Filter Data Using Legends
Explore Visual Options
Connectivity Guide
Connecting to Data
Using Connection Explorer
Data Table Detail
Computing Table Statistics
Refreshing Table Metadata
Using Direct Access
Using Direct Access to Run a Query
Creating a Dataset from a Direct Access Query
Downloading Results of Direct Access Query
Connecting to a Data Source
Creating Data Connections
Arcadia Engine
Amazon Redshift
Apache Drill
Apache Solr
Confluent KSQL
Creating New Google BigQuery Connections
Hive
Impala
MariaDB
Microsoft SQL Server
MySQL
Oracle DB
PostgreSQL
Creating New Snowflake Connections
Spark SQL
SQLite
TD Aster
Teradata
Editing Data Connections
Deleting Data Connections
Adding Data
Adding Data in CSV Format
Adding Data through URL
Changing Locale Settings
Preparing Excel Files for Data Import
Working with Data
Overview of Data Modeling
Datasets
Creating Datasets
Creating Datasets in Data Interface
Creating Datasets from a Query
Creating Datasets in Connection Explorer
Finding Datasets
Dataset Detail
Table
Connection Type
Description
Associated Logical View
Join Elimination
Result Cache
Incremental Results
SQL
Information on Creation and Update
Related Visuals
Editing Datasets Based on a SQL Query
Restricting Columns in Datasets Based on SQL Query
Restricting Rows in Datasets Based on SQL Query
Removing Datasets
Data Model: Joins
Join Types
Creating Joins
Changing Join Types
Editing Join Details
Deleting Joins
Working with Logical Views
Dataset Fields
Hiding Fields from Applications
Changing Field Aggregation
Creating Calculated Fields
Changing the Field Display Format
Currency Field Display Format
Custom Field Display Format
Custom Javascript Field Display Format
Changing Data Type
Specifying Geographic Fields
Adding Field Comments
Automatically Renaming Dataset Fields
Custom Renaming Fields
Advanced Analytics Guide
Analysis Overview
Complex Data Types
STRUCT Data Type
ARRAY Data Type
MAP Data Type
Dimension Hierarchies
Creating New Dimension Hierarchies
Changing Dimension Hierarchies
Changing the Name of the Hierarchy
Changing the Order of Components in the Hierarchy
Adding Levels to the Hierarchy
Removing Levels from the Hierarchy
Deleting Dimension Hierarchies
Hierarchy Drill Into Support on the Color Shelf
Segments
Creating Segments
Cloning Segments
Editing Segments
Creating Entity Segments
Deleting Segments
Creating Segments from Filters
Using Segments in Visuals
Events
Creating Events
Cloning Events
Editing Events
Deleting Events
Visuals for Analytics
Combo Visuals
General Bar and Line Chart Visuals
Using Secondary Axis
Changing Lines to Areas
Gauge Visuals
Bullet Visuals
Box Plot Visuals
Flows
Funnels
Correlation Flows
Network Visuals
Dendrogram Visuals
Histograms
Advanced Visualization Techniques
Trellis
Trellis on Dimensions
Trellis on Measures
Multiple Measure Analysis
Dual Axis
Dimension Hierarchies
Hierarchical Cross-Tabulation Visuals
Adding Highlights
Analytic Functions
Previous Value Analytic Function
Difference from Previous Value Analytic Function
Percentage Difference from Previous Value Analytic Function
Next Value Analytic Function
Difference from Next Value Analytic Function
Percentage Difference from Next Value Analytic Function
Row Number Function
Rank Analytic Function
Dense Rank Analytic Function
Moving Average
Percent of Group
Running Total
Derived Data
Define Derived Data
Define Additional Derived Data
Use Derived Data
View Derived Data Definitions
Save Derived Data
Delete Derived Data Definitions
Making Visuals Interactive with Legends
Customization Guide
Customizing Visuals
Customizing Settings for Visuals
Axes
Changing the Axis Scale
Changing the Axes Scale for Radial Graphs
Enabling Gridlines
Enabling Continuous Axis for Date/Time Values
Change the Padding on the X Axis
Change the Padding on the Y Axis
Starting Aggregate Scale at Zero
Changing the Min/Max of the Aggregate Scale
Showing or Hiding the Axis Labels
Change the Size of Dimension Text
Hiding an Axis
Reversing the Axis Scale
Dynamically Sizing a Graph
Setting Maximum Row Label Length
Setting Column Label Length
Enabling a Continuous X Axis
Changing Scale of a Continuous X Axis
Enabling Continuous Y Axis
Changing Scale of Continuous Y Axis
Enabling a Continuous Axis on Dimensions
Changing the Scale of a Continuous Axis on Dimensions
Basic Settings
Histogram Bucket Count
Normalized Histograms
Cumulative histograms
Data
Disabling Incremental Queries
Displaying NULL Rows
Ordering NULL Rows
Changing Maximum Number of Rows Fetched
Changing Number of Rows to Download
Enabling Links
Specifying Qualitative Range as Percentages
General Settings
Enabling Animations
Enabling Drill Into Context Menu
Customizing Downloads Settings
Enabling CSV Download
Enabling Excel Download
Setting the Locale for CSV Downloads
Customizing Links
Changing Link Color
Changing Link Opacity
Changing Link Width Range
Changing Link Distance
Changing Link Strength
Adding Arrow Direction to Links
Changing the Direction Arrow Size
Adding the Link Legend
Changing the Name of the Links Legend
Customizing Map Options
Map View
Customizing Marks
Displaying Tooltips
Showing Detail Data Button in Context Menu
Showing the Context Menu
Showing the Table Data as HTML
Showing Adjacent Duplicate Values
Showing Column Totals
Showing Row Totals
Showing Combined Row Totals
Showing Expansion Totals Above Expansion Rows
Displaying Title for Subtotal Rows
Changing Legend Style and Removing the Legend
Changing the Legend Item Width
Changing the Legend Width
Reversing the Legend Order
Displaying a Linear Trendline
Separating Trendlines by Color
Changing Trendline Number of Decimals
Showing a Selection Brush for Ranges
Bar Size Range
Showing Measure Values Inside Bars
Showing Points
Ignoring Missing Date Values
Changing the Line Shape
Linear Line Shape
Basis Line Shape
Bundle Line Shape
Cardinal Line Shape
Monotone Line Shape
Step Line Shape
Step Before Line Shape
Changing the Line Style
Changing the Highlight Type
Converting Line to Area Visual
Changing the Size of the Highlight
Changing the Mark Size Range
Change Transition Delay
Showing Autoplay Transition Animation
Changing Arc Width
Showing Dimensions as Marks
Showing Percentages as Marks
Changing Number of Decimals for Percentage Marks
Changing Number of Decimals
Change Display to Overlap
Showing the Same Source and Destination Values
Displaying Bubbles on Maps
Changing Layout Gravity
Changing Layout Theta
Showing Node Labels
Tokenizing Input
Displaying Gauge Lines
Displaying Axis Ticks
Changing Outer Width
Changing Qualitative Thickness
Changing the Arc Gap
Changing the Arc Thickness
Changing Label Font Size
Changing Label Offset
Changing Sublabel Font Size
Changing Sublabel Offset
Making Box Plots Horizontal
Changing Outline Width
Changing the Font Size of Main Indicator
Changing the Value of Main Indicator
Use Same Color for Main Indicator as Arrow
Display First Measure as Main Indicator
Changing the Value of Compare Indicator
Changing the Position of Compare Indicator
Changing the Arrow Type
Flipping the Compare Indicator
Changing the Position of Label Indicator
Changing the Font Size of Label Indicator
Ignoring Negative Values
Changing the Approximate Tick Count
Orienting Bars Vertically
Removing the Default Label
Customizing Nodes
Remembering Node Positions
Showing the Same Source and Target Values
Changing the Source Node Mark
Changing the Target Node Mark
Changing the Combined Node Mark
Changing Node Size Range
Changing Node Friction
Changing Node Charge
Changing Node Opacity
Showing Node Labels
Adding the Nodes Legend
Changing the Name of the Nodes Legend
Setting Explicit Scope for Visuals
Using Parameters with Explicit Scope
Sending Parameters with Dataset Scope
Sending Aggregates as Parameters
Customizing Map Server
Changing the Map Server
Specifying a Mapbox Key for the Visual
Specifying an Atlas Mapbox Server for a Visual
Customizing Map Style
Changing the Map Style of a Visual
Adding Custom Mapbox Style
Customizing Choropleth
Specifying a Choropleth Layer ID
Specifying a Choropleth Opacity
Displaying a Legend in a Choropleth Map
Remembering Location of Map
Customizing Heatmap
Displaying the Heatmap
Changing the Heatmap Radius
Changing the Intensity Magnification
Showing the Heatmap Legend
Changing the Visible Zoom Levels in Heatmap
Customizing Cluster
Displaying Cluster
Changing the Cluster Color
Changing the Cluster Radius
Customizing Circles
Displaying Circles
Displaying the Color Legend
Displaying Area Legend
Changing the Circle Radius Range
Changing the Visible Zoom Levels in Circles
Customizing Routes and Pins
Enabling Routes
Enabling Pins
Selecting Pin Types
Selecting Start Pin Type
Selecting Middle Pin Type
Selecting End Pin Type
Specifying a Custom Icon
Changing Custom Icon Size
Changing Tooltip Font Size
Showing Percentage
Label for Percentage
Changing Number of Decimals for Percentage
Changing Tooltip Font Size
Changing Tooltip Font Family
Customizing Trellis
Displaying Trellis Borders
Enabling Independent Axis Scale
Setting Minimum Trellis Cell Width
Setting Minimum Trellis Cell Height
Customizing Zoom
Enabling Pan and Zoom
Enabling Zoom to Active Areas
Customizing Visual Style
Customizing Table Style
Changing Table Templates
Choosing Header Alignment
Adjusting Table Width
Wrapping Column Contents
Showing Totals
Showing Headers for Totals
Specifying Maximum Number of Columns
Showing Row Information
Showing Pagination
Specifying the Number of Rows per Page
Showing Header Column Borders
Adjusting Table Column Width
Customizing Table Colors
Changing Table Header Background Color
Changing Table Header Text Color
Changing Table Odd Rows Background Color
Changing Table Even Rows Background Color
Changing Table Odd Rows Text Color
Changing Table Even Rows Text Color
Changing Table Border Color
Changing Totals Row Background Color
Changing Totals Row Text Color
Customizing Visual Title
Changing the Font Family in the Title of a Visual
Changing the Font Size in the Title of a Visual
Changing the Font Weight in the Title of a Visual
Changing the Text Alignment in the Title of a Visual
Hiding the Title of a Visual
Customizing Visual Subtitle
Changing the Font Family in the Subtitle of a Visual
Changing the Font Size in the Subtitle of a Visual
Changing the Text Alignment in the Subtitle of a Visual
Customizing Visual Axes and Labels
Changing the Font Size of Axis Label in a Visual
Changing the Font Size of Ticks in a Visual
Changing the Font Size of Labels in a Visual
Changing the Font Size of Trellis in a Visual
Changing the Font Size of a Legend in a Visual
Customizing Tooltip
Changing Tooltip Font Family
Changing Tooltip Font Size
Customizing Aggregate Row Style
Changing Font
Changing Font Weight
Customizing Visual Basics
Changing the Font Family in the Visual
Changing the Font Size in the Visual
Customizing Visual Colors
Reverse Color Palette
Change Color Palette
Enabling Color
Changing the Foreground Color
Changing the Pointer Color
Changing the Background Color
Changing the Arrow Color
Changing Color Opacity
Changing the Link Color
Changing the Drop off Color
Changing the Highlight Color
Changing Projection Opacity
Changing Background Opacity
Making Colors Consistent on Dimension Values
Assigning Color to Specified Values
Up Arrow
Changing the Color of the Up Arrow
Changing the Color of the Flat Arrow
Changing the Color of the Down Arrow
Changing the Color of the Main Font
Changing the Color of the Label Font
Customizing Styles
Adding CSS Classes to Visuals
Adding Included Styles to Visuals
Searching Custom Styles in Visuals
Sorting Custom Styles in Visuals
Adding Inline CSS code to Visuals
Customizing Field Properties
Aggregates
Date/Time Functions
Text Functions
Analytic Functions
Change Type
Timestamp
String
Integer
Real
Boolean
Geo Types
Order and Top K
Enter/Edit Expression
Aggregate Display
Expansion
Display Format
Numbers
Integer Display Format
Percentages
Scientific
Currency
Date/Time
Custom
Custom Display Formats for Large Numbers
Custom Display Javascript Format
Alias
Column Position
Description
Duplicate
Derived Data
Customizing Dashboards
Dashboard Settings Customization
Customizing General Settings for Dashboards
Changing Dashboard Width
Enabling Manual Refresh
Enabling Animations
Adjusting Horizontal Margins
Adjusting Vertical Margins
Displaying a Visual in Full Screen
Showing Borders Around Visuals
Showing Filter Selections for Each Visual
Displaying Context Menus Within Visuals
Overriding Visual Font and Alignment Settings
Adjusting Automatic Refresh
Enabling Case Sensitive Dashboard Filters
Enabling Viewing Data in Dashboard Visuals
Customizing Download Settings for Dashboards
Enabling PNG and PDF Download for Dashboards
Enabling Printing Style in PDF for Dashboards
Changing the Scale of Dashboards for PDFs
Selecting the Page Size of PDF Downloads
Selecting the Page Orientation of PDF Downloads
Enabling Headers and Footers when Printing in PDF
Enabling CSV/Excel Download for Visuals in Dashboard
Enabling Email for Dashboards
Dashboard Style Customization
Dashboard Basics Styles
Dashboard Text Color
Dashboard Background Color
Dashboard Page Background Color
Dashboard Titles Styles
Dashboard Titles Font Family
Dashboard Titles Font Size
Dashboard Titles Font Weight
Dashboard Titles Text Color
Dashboard Titles Background Color
Dashboard Titles Alignment
Hiding Dashboard Titles
Dashboard Subtitles Styles
Dashboard Subtitle Font Family
Dashboard Subtitle Font Size
Dashboard Subtitle Text Color
Dashboard Subtitle Background Color
Dashboard Subtitle Alignment
Filter Styles in Dashboards
Align Filters
Position Labels
Separator
Border
Font Family
Font Size
Text Color
Selected Text Color
Container Color
Background Color
Visual Basics Styles in Dashboards
Visual Basic Font Family in Dashboards
Visual Basic Font Size in Dashboards
Visual Basic Background Color in Dashboards
Visual Border Styles in Dashboards
Show Borders on Visuals in Dashboards
Visual Border Color in Dashboards
Visual Border Radius in Dashboards
Visual Titles Styles in Dashboards
Visual Title Font Family in Dashboards
Visual Title Font Size in Dashboards
Visual Title Font Weight in Dashboards
Visual Title Text Color in Dashboards
Visual Title Background Color in Dashboards
Visual Title Alignment in Dashboards
Visual Subtitles Styles in Dashboards
Visual Subtitle Font Family in Dashboards
Visual Subtitle Font Size in Dashboards
Visual Subtitle Text Color in Dashboards
Visual Subtitle Background Color in Dashboards
Visual Subtitle Alignment in Dashboards
Visual Axes and Labels Styles in Dashboards
Axis Label Font Size in Dashboards
Visual Axis Ticks Font Size in Dashboards
Visual Label Font Size in Dashboards
Visual Trellis Font Size in Dashboards
Visual Legend Font Size in Dashboards
Tooltip Styles in Dashboards
Tooltip Font Family in Dashboards
Tooltip Font Size in Dashboards
Adding Custom Styles to Dashboards
Adding CSS Classes to Dashboards
Adding Included Styles to Dashboards
Searching Custom Styles in dashboards
Sorting Custom Styles in Dashboards
Adding Inline CSS code to Dashboards
Customizing Apps
Customizing General Settings for Apps
Enabling Navigation from Logo
Customizing Style on Apps
Customizing Menu Bar Style for Apps
Displaying Menu on the Left
Changing Menu Background Color
Changing Menu Bottom Bar Color
Changing Menu Selected Color
Customizing Menu Text for Apps
Changing Menu Font Family
Changing Menu Font Size
Changing Menu Font Weight
Changing Menu Text Color
Changing Menu Text Selected Color
Displaying Menu Text in Uppercase
Customizing the Logo for Apps
Changing the Logo Image
Changing the Logo Width
Changing the Logo Height
Changing the Logo Top Margin
Changing the Logo Bottom Margin
Customizing the Background for Apps
Changing App Background Color
Removing Dashboard Shadow
Adding Custom Styles to Apps
Adding CSS Classes to Apps
Adding Included Styles to Apps
Adding Inline CSS code to Apps
Customization Examples
Creating Dashboards with Multi-Page Table Visuals
Developer Guide
Filters and Parameters
Overview
Filter Shelves
Syntax for Using Parameters
Filter Widgets
Filter Scope
Setting Explicit Scope
Setting Dataset Scope
Setting AppGroup Scope
Filter Shelves
Selecting Discrete Values
Selecting a Range of Numbers
Selecting a String Pattern
Selecting a Range of Dates
Selecting Through an Expression
Click Behavior Between Visuals
Creating Control Visuals
Creating Target Visuals
Enabling Click Send
Enablling Click Receive
Exploring Click Behavior Interaction
Using Filter Widgets on Dashboards
Creating Dataset Filters on Dashboards
Creating Custom Filters on Dashboards
Creating Date and Time Filters on Dashboards
Using Fixed Dates (Date Picker) Mode
Using Relative Dates Mode
Using Quick Filters
Including Null Values in Date Filters
Actions for Dashboard Controls
Moving Filter Widgets in Dashboards
Configuring Dashboard Filter Settings
Configuring Ranges on Dashboard Filters
Values Options
Customizing Output Parameters
Setting Parameters in URLs
Data Options
Specifying Maximum Numbers of Rows to Fetch
Disabling Incremental Queries in Filters
Configuring Sort Order in Filter Values
Display Settings Options
Displaying A Parameter Text Box
Changing the Width of the Filter Text Box
Entering Values Manually
Number of Initial Output Options
Number of Search Output Options
Single value
Selecting All Values
Single Value with Dropdown
Displaying Distinct Parameters
Hiding Filter
Remembering Previous Selections on Dashboard Filters
Multi-select
Scope Options
Configuring Custom Style for Dashboard Filters
Customizing Dashboard Filter Styles
Adding Included Styles to Dashboards
Receiving Parameters in Dashboards
Visuals with Optional Dimensions
Creating Visuals with Optional Dimensions
Creating Filters that Control Optional Dimensions
Visuals with Optional Measures
Creating Visuals with Optional Measures
Creating Filters that Control Optional Measures
Visuals with Variable Dimensions
Creating Visuals with Variable Dimensions
Creating Filters that Control Variable Dimensions
Visuals with Variable
Creating Visuals with Variable Measures
Creating Filters that Control Variable Measures
Configuring Cascading Filters
Creating the Dashboard
Adding Filters to the Dashboard
Configure Filters and Enable Cascading Filter Interaction
Explore the Dashboard Filter Interaction
Embedding
Embedding Apps Using Trusted Authentication
Trusted Authentication Overview
Enabling Trusted Authentication
Authenticating Embedded Requests
Embedding Dashboards and Reports
Performance Guide
Analytical Views
Architecture of Analytical Views
Building Analytical Views
Routing and Compensation with Analytical Views
Routing Queries to AVs Based on Tables
Routing Queries to AVs with Logical Views
Routing and Compensation Examples
Checking Query Routing
Analytical View States
Staleness Period
Effect of Changes to Tables
Partition-Based Analytical Views
Operations for Partition-Based Analytical Views
CREATE
REFRESH
SHOW
DROP
Using Partition-Based Analytical Views
Best Practices and Support
Sequence-Based Analytical Views
Operations for Sequence-Based Analytical Views
CREATE
REFRESH
SHOW
DROP
Using Sequence-Based Analytical Views
Best Practices for Sequence-Based Analytical Views
Enabling Aggregate Functions
Enabling Aggregate Functions
Using Aggregate Functions in Analytical Views
Authorization for Analytical Views
Authorization Concepts
Examples of Authorization
Managing Analytical Views in UI
Filtering Analytical Views
Creating Analytical Views
Creating an Analytical View Over a Logical View
Creating an Analytical View Over a Base Table
Refreshing Analytical Views
Scheduling Analytical View Refresh
Deleting Analytical Views
Understanding SQL of Analytical Views
Using Arcadia Smart Acceleration™
Using Arcadia Smart Acceleration™
Get Analytical View Recommendation
Understanding the Recommendations
Create Analytical View
Review Recommendation
Refresh Analytical View
Scheduling Analytical View Refresh
Eager Aggregation
How Eager Aggregation Works
Modeling Referential Integrity
Specifying Primary Key - Foreign Key Constraints
Comparing Performance
ArcEngine Catalog Tables
Using Arcadia Catalog Tables
Best Practices for Arcadia Catalog Tables
Limitations
arcadia_catalog.inflight_queries
arcadia_catalog.completed_queries
ArcEngine Cost Model
Multi-Process ArcViz
Best Practices for Multi-Process ArcViz
Limitations of Multi-Process ArcViz
Dashboard Performance
Updating ArcEngine Metadata Automatically with Hive Notification
Setting up Message Queue Server
Configuring Hive with MQ Server
Configuring ArcEngine with MQ Server
Notification Types
Limitations of the Hive Notification Mechanism
Queueing Notifications when Hive is Unavailable
Queueing Notifications when ArcEngine or Impala are Unavailable
Invalidating Analytical Views
Installation Guide
Overview of Installation
Installation Terminology and Architecture
Installation Prerequisites
Arcadia Ports
Additional Installation Topics
Connection-Specific Additions
Enabling Oracle Data Connections
Enabling Apache Drill Data Connections
OpenID Connect
Setting up the MS SQL Driver
Support for Apache Solr Connections
Support for Confluent KSQL Connections
RPM Dependencies
Upgrading
Arcadia Enterprise
to Release 4.2.0.0 or Later
Upgrade Considerations for Visuals
Upgrade Considerations for Sheets
Upgrade Considerations for Workspaces
Upgrade Considerations for Analytical Views
Cloudera Installations
Using Cloudera Manager
Get Arcadia Data Install Files
Start Cloudera Manager
Install Vendor-Supplied Packages
Configure the Parcels
Add Arcadia Enterprise Service to the Cluster
Setting up Multi-Process ArcViz on Cloudera
Set Options and Complete Installation
Start Arcadia Enterprise
Upgrading Arcadia Enterprise on Cloudera Manager
High Availability for CM Installations; Multiple State Store and Catalog Configurations
Post-Installation Tasks for Cloudera Manager
Setting Log Verbosity
Setting Memory Limit
Checking Server-Level Privileges
Cloudera: Installing an SSL Certificate on ArcViz Server
Cloudera: Proxy Group Configuration
Cloudera: Specifying LDAP Settings
Cloudera: Specifying Kerberos Settings
Cloudera: Enabling BlueData
Hortonworks Installations
Using Ambari Stacks
Start Ambari Server
Download/Prepare Arcadia Enterprise Files
Stop/Restart Ambari Service
Add Arcadia Enterprise Service
Setting up Multi-Process ArcViz on Ambari Stacks
Set Options/Complete Installation
Start Arcadia Enterprise
Enable PAM Authentication in Ambari
Upgrading Arcadia Enterprise Using Ambari Stacks
High Availability for AS Installations; Multiple State Store and Catalog Configurations
Post-Installation Tasks for Ambari Stacks
Checking Server-Level Privileges
Ambari: Installing an SSL Certificate on ArcViz Server
Ambari: Specifying LDAP Settings
Proxy Group Configuration on Ambari
Ranger Auditing on Kerberized Clusters with an Arcadia User
Ranger Auditing on Kerberized Clusters with a Custom Arcadia Service Account
MapR Installation
Installing Arcadia Enterprise on MapR
Get and Distribute
Arcadia Enterprise
Install Files on MapR
Configure the Service Node on MapR
Configure Non-Service Nodes on MapR
Store Metadata on MapR
Start Arcadia Services on MapR
Stop Arcadia Services on MapR
Upgrading Arcadia Enterprise on MapR
Post-Installation Tasks for MapR
Checking Server-Level Privileges
MapR: Installing an SSL Certificate on ArcViz Server
Administration Guide
Administration
Users and User Groups
Creating User Accounts
Creating Administrator Accounts
Editing Accounts
Changing User Passwords
Inactivating User Accounts
Assigning Roles to Users
Assigning Roles to a Single User
Assigning Roles to Users in Roles Interface
Assigning Multiple Roles to Multiple Users
Deleting User Accounts
Deleting Individual User Accounts
Deleting Several User Accounts
Creating User Groups
Editing User Groups
Adding Users to Groups
One User, Many Groups
One Group, Many Users
Many Users, Many Groups
Assigning Roles to User Groups
Deleting User Groups
Custom Home Pages
Select Dashboard as Homepage
Using Set Homepage for Your Own Home
Setting Custom Home Pages
Resetting the Homepage to Default
Managing Jobs
Job Log
Rerunning Jobs
Deleting Jobs
Scheduled Jobs
Pausing Jobs
Resuming Paused Jobs
Deleting Scheduled Jobs
Manage Schedule Intervals
Creating New Schedules
Changing Schedule Intervals
Deleting Schedule Intervals
Activity Logging
Activity Log
List View of Activity Log
Statistical View of Activity Log
WebServer Log
ArcEngine Logs
API Keys
Enabling API Keys
Creating New API Keys
Changing API Keys
Deleting API Keys
Custom Styles
Defining Styles
CSS Custom Styles
JavaScript Custom Styles
Modifying Styles
Deleting Styles
Searching Site-Wide Custom Styles
Sorting Site-Wide Custom Styles
Email Templates
Create
Edit
Clone
Delete
Custom Colors
Creating New Custom Colors
Distinct Colors
Gradient with Values
Gradient with Percentages
Editing Custom Colors
Deleting Custom Colors
Managing Custom Dates
Creating New Custom Dateranges
Cloning Custom Date Ranges
Deleting Custom Date Ranges
Managing Static Assets
Creating New Assets
Viewing an Existing Asset
Changing Existing Assets
Automatically Uploading Assets
Deleting an Existing Asset
Site Settings
Setting Default Dashboard Width at Site-Level
Enabling Dataset Field Renaming
Enabling Smart Acceleration
Enabling Derived Data
Enabling Visual Options
Enabling Snapshots and Thumbnails
Enabling CSV Download
Downloading Maximum Number of Rows in CSV Files
Downloading Maximum Data Rows in Visuals
Customizing the Help Menu
In ArcViz
In settings.py file
Enabling API Keys for Interactive Map Visuals
Specifying an Atlas Mapbox Server at the Site Level
Enabling Scheduled Jobs
Enabling and Customizing Email Settings
Setting User Password Requirements
Enabling Custom Styling
Security Model
Security Overview
Role Based Access Control
Overview of Role Based Access Control
List of Permissions
Support for Sentry Authentication
Working with User Roles
Creating New Roles
Managing Privileges
Adding Privileges
System Privileges
Setting Role Privileges
Connection Privileges
Dataset Privileges
Managing Member Roles
Editing Role Assignments
Assigning Roles to Users
Assigning Roles to User Groups
All Groups Requirement
Assigning Multiple Roles to Multiple Users
Deleting Roles
Account Lockout Configuration
Publishing Datasets
RBAC Setup for Dataset Publishing
Specifying the Dataset Recipient Roles
Specifying the Dataset Publisher Role
Define Groups for Teams and Access Levels
Assign Groups to Roles
Assign Users to Groups
Restricting Row-Level Access
Specifying Segments
Creating Users and User Groups
Specifying Roles
Specifying Filter Associations
Verifying Row/Column Restrictions
Restricting Column-Level Access
Authorizing Access to Analytical Views
Integration with Sentry
LDAP User Authentication
LDAP Configuration Dependencies
Collect LDAP Configuration Parameters
LDAP Authentication
Using LDAPS
Testing the Installation
Edit Local Settings File for LDAP Authentication
Complex Matching logic for Group Queries using LDAPGroupQuery()
Using Apache Sentry on Cloudera
Apache Sentry Authorization
Auditing with Sentry
Using Apache Ranger on Hortonworks
Authorization
Auditing
Utilities
Saving Apps as PNG Files
Emailing
Immediate Emails
Adding Job Parameters to Emails
Scheduled Emails
Specifying Custom Intervals for Scheduled Emails
Adding Job Parameters to Scheduled Emails
Checking Scheduled Email Jobs
Triggered Emails
Specifying Custom Intervals for Threshold Emails
Adding Job Parameters to Threshold Emails
Checking Threshold Email Jobs
Importing and Exporting Visual Artifacts
Exporting Dashboards
Exporting Linked Visuals
Exporting Apps
Importing Dashboards
Importing Linked Visuals
Importing Apps
Migration with REST APIs
Arcadia Smart Acceleration™ Command Line Utility
Getting Started with the Command Line Utility
Navigating to the Command Line Utility
Accessing the Command Line Utility
Smart Acceleration Command Line Utility Options
Getting Recommendations in the Utility
Input from a File
Input from a Query
Input from File and Query
Displaying Recommendation Output in the Utility
Default Output Mode
Recommendation-Only Output Mode
Verbose Output Mode
ArcEngine Log Bundling Utility
ArcEngine Log Bundling User Interface
ArcEngine Log Bundling Command-Line Utility
ArcEngine Log Bundling Command Line Utility Options
ArcEngine Log Bundling File
Licensing
Arcadia Enterprise
APIs
Data API
Enabling Data API
Example of Data API Usage
Data API Request Payload
Data API Response Payload
Accessing Data API Request Payload
Admin API
Enabling Admin API Support
Admin API Syntax and General Usage
Admin API Syntax Parameters
Setting Up a Session
Python Admin API Data Format and Response
CURL Data Format and APIKey examples
Admin API Demo
Using Admin API Demo; Examples
Data Type Details
Users
Groups
Roles
Segments
Filter Associations API
Workspaces
Arcadia Engine Aggregate Functions
GCDO() Function
BOOLEAN_AND() Function
BOOLEAN_OR() Function
NDVP()
ARCAPI Library
Custom Style Extension JS APIs
Endpoints
arcapi Functions
arcapi.dataResult Functions
Custom Style Extension CSS APIs
Enumerated Values
Display Format Reference
Standard Format Specifier
Standard Style Table
Quantity Prefixes
Format Examples
Understanding Date/Time Formats
RBAC Permissions
Arcadia Shell (ArcShell)
Email Job Parameters
Email Development Recommendations
Reference
Certifications
Partner Integration
Supported Connections
Supported MetaStores
Supported Platforms
Supported Data Storage
Mobile Devices
Internet Browsers
Deprecated Features
Videos
Datafiles
Glossary
Your browser does not support iframes.