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
Documentation Overview
Arcadia Enterprise
Quick Start
Welcome
Starting with
Arcadia Enterprise
Main Navigation
Getting Help and Checking the Version
Managing Your Account
Login
Changing Your Password
Logout
User Guide
Visualizing Data
Visuals Interface
Dashboards
Visual Designer for Dashboards
Creating Dashboards
Viewing Dashboards
Using Dashboard Controls
Visuals
Visual Designer for Visuals
Creating Visuals
Cloning Visuals
Emailing Visuals and Dashboards
Ad-hoc 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
Adding Visuals to Favorites
Setting Current Visual as Homepage
Downloading Visuals as PNG Files
Downloading Visuals as PDF Files
Downloading Visual Data to CSV Files
Saving Table Data
Deleting Visuals
Visual Type Catalog
Table
Cross Tabulation
Bars
Filtering by Year
Filtering by Region
Horizontal Bars
Stacked Bars
Labelled Bars
Lines
Making Line Visuals Interactive
Line Visuals with Dual Axes
Combo Visuals
General Bar and Line Chart Visuals
Using Secondary Axis
Changing Lines to Areas
Areas
Area Visual with Trellis Option
Area Visuals Trellis with Independent Scale
Grouped Bars
Single Value Visuals
Gauge Visuals
Bullet Visuals
Box Plot Visuals
Packed Bubbles
Word Cloud Visuals
Trellised Word Clouds
Scatter Visuals
Basic Scatter Visual
Adding Size
Adding Transition Animation
Adding Trellises
Flow Visuals
Funnel Visuals
Pie Visuals
Radial Visuals
Trellised Radial
Chord Visuals
Network Visuals
Dendrogram Visuals
Correlation Heat Map
Correlation Flow
Calendar Heat Map
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
Interactive Maps
Interactive Maps with Multiple Dimensions
Interactive Maps with Multiple Measures
Tile Layers
Layer Options
Sparklines
URL Links
Histograms
Extension Visuals, Simple
Rich Text Visuals
Inserting URL Links
Inserting Tables
Inserting Images
Inserting Videos
Field Statistics Visuals
SQL Query Visuals
Data Discovery
Drill Down and Drill Up Data Discovery
Drill Through Data Discovery
Drill Into Data Discovery
Filter All Data Discovery
Advanced Visualization Techniques
Connecting to Data
Using Connection Explorer
Data Table Detail
Refreshing Table Metadata
Computing Table Statistics
Connecting to a Data Source
Creating Data Connections
Arcadia Engine
Impala
Hive
SQLite
Spark SQL
Apache Solr
Apache Drill
MySQL
TD Aster
PostgreSQL
Amazon Redshift
Creating New Microsoft SQL Server Connections
MariaDB
Oracle DB
Editing Data Connections
Deleting Data Connections
Importing Data
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 in Connection Explorer
Finding Datasets
Dataset Detail
Table
Data Connection
Description
Associated Logical View
Join Elimination
Result Cache
Incremental Results
Information on Creation and Update
Related Visuals
Removing Datasets
Data Model: Joins
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 Data Type
Specifying Geographic Fields
Adding Field Comments
Automatically Renaming Dataset Fields
Custom Renaming Fields
Advanced Analytics
Analysis Overview
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
Segments
Creating Segments
Cloning Segments
Editing Segments
Creating Entity Segments
Deleting Segments
Creating Segments from Filters
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
Moving Average
Percent of Group
Percentage of Previous
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
Customizing Visuals
Customizing Settings for Visuals
Axes
Changing the Axis Scale
Changing the Axes Scale for Radial Graphs
Enabling Gridlines
Enabling Independent Axis Scale
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
Dynamically Sizing a Graph
Changing the Size of Axis Padding
Basic Settings
Histogram Bucket Count
Normalized Histograms
Cumulative histograms
Enabling Links
Disabling Incremental Queries
Displaying NULL Rows
Ordering NULL Rows
Changing Maximum Number of Rows Fetched
Enabling URL Links
General Settings
Enabling CSV Download
Setting the Locale for CSV Downloads
Enabling Image or PDF Download
Enabling Drill Into Behavior
Tile Layer
Changing the Map Layer Style
Heatmap Layer
Displaying the Heatmap Layer
Showing the Heatmap Legend
Changing the Intensity Magnification
Changing the Heatmap Radius
Cluster Layer
Displaying the Cluster Layer
Changing the Cluster Color
Changing the Cluster Radius
Circle Layer
Displaying Circle Layer
Displaying Area Legend
Displaying the Color Legend
Changing the Circle Area Range
Marker Layer Option
Displaying Marker Layer
Customizing Map Options
Map View
Customizing Marks
Showing Trellis Borders
Showing Tooltips
Showing the Context Menu
Showing the Table Data as HTML
Showing the Measure Totals
Changing Legend Style and Removing the Legend
Changing the Legend Item 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 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
Change Display to Overlap
Showing the Same Source and Destination Values
Displaying Bubbles on Maps
Remembering Node Positions
Changing Node Opacity
Changing Link Opacity
Changing Link Color
Changing the Source Node Mark
Changing the Target Node Mark
Changing Link Width Range
Changing Node Size Range
Changing Link Distance
Changing Link Strength
Changing Node Friction
Changing Node Charge
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
Setting Explicit Scope for Visuals
Receiving Parameters with Explicit Scope
Sending Parameters with Dataset Scope
Sending Aggregates as Parameters
Customizing Tooltip
Showing Percentage
Showing Percentage
Changing Number of Decimals for Percentage
Customizing Zoom
Enabling Pan and Zoom
Enabling Zoom to Active Areas
Customizing Visual Colors
Reverse Color Palette
Change Color Palette
Enabling Color
Changing the Foreground Color
Changing the Pointer Color
Changing the Background Color
Changing Color Opacity
Changing Projection Opacity
Changing Background Opacity
Making Colors Consistent on Dimension Values
Assigning Color to Dimension Values
Customizing Visual Style
Customizing Table Style
Changing Table Templates
Choosing Header Alignment
Adjusting Table Width
Showing Table Information
Showing Column Totals
Showing Headers for Column Totals
Specifying Maximum Number of Columns
Specifying Number of Exported Records
Showing Pagination
Specifying the Number of Rows per Page
Customizing Visual Basics
Changing the Font in the Visual
Customizing Visual Title
Changing the Font in the Title of a Visual
Changing the Font Size 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 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 Styles
Adding CSS Classes to Visuals
Adding Included Styles to Visuals
Adding Inline CSS code to Visuals
Customizing Dashboard Settings
Changing Dashboard Width
Adjusting Horizontal Margins
Adjusting Vertical Margins
Showing Borders Around Visuals
Aligning Filters to the Left
Showing Filter Selections for Each Visual
Showing Context Menus for Each Visual
Overriding Visual Font and Alignment Settings
Enabling PNG and PDF Download for Dashboards
Enabling CSV Download for Visuals in Dashboard
Adjusting Automatic Refresh
Customizing Dashboard Style
Customizing Styles for Dashboard Basics
Changing Dashboard Text Color
Changing Dashboard Background Color
Customizing Styles for Dashboard Titles
Changing Dashboard Title Font
Changing Dashboard Title Size
Changing Dashboard Title Text Color
Changing Dashboard Title Background Color
Changing Dashboard Title Alignment
Hiding Dashboard Titles
Customizing Styles for Dashboard Subtitles
Changing Dashboard Subtitle Font
Changing Dashboard Subtitle Size
Changing Dashboard Subtitle Text Color
Changing Dashboard Subtitle Background Color
Changing Dashboard Subtitle Alignment
Customizing Styles for Visual Titles
Changing Visual Title Font in Dashboards
Changing Visual Title Size in Dashboards
Changing Visual Title Text Color in Dashboards
Changing Visual Title Background Color in Dashboards
Changing Visual Title Alignment for Dashboards
Customizing Styles for Visual Subtitles
Changing Visual Subtitle Font in Dashboards
Changing Visual Subtitle Size in Dashboards
Changing Visual Subtitle Text Color in Dashboards
Changing Visual Subtitle Background Color in Dashboards
Changing Visual Subtitle Alignment for Dashboards
Customizing Styles for Filters
Changing Text Color in Dashboard Filters
Changing Selected Text Color in Dashboard Filters
Changing Container Color in Dashboard Filters
Changing Background Color in Dashboard Filters
Hiding Borders around Filters
Adding Custom Styles to Dashboards
Adding CSS Classes to Dashboards
Adding Included Styles to Dashboards
Adding Inline CSS code to Dashboards
Adding Custom Styles to Apps
Adding CSS Classes to Apps
Adding Included Styles to Apps
Adding Inline CSS code to Apps
Customizing Visual Field Options
Aggregates
Date/Time Functions
Text Functions
Analytic Functions
Change Type
Timestamp
String
Integer
Real
Boolean
Geo Types
Order and Top K
Enter/Edit Expression
Display Format
Numbers
Percentages
Scientific
Currency
Date/Time
Custom
Custom Display Formats for Large Numbers
Alias
Description
Duplicate
Derived Data
Accelerating Apps
Using Arcadia Smart Acceleration™
Developer Guide
Filters and Parameters
Filter and Parameter Overview
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 Dashboard Filters and Parameters
Specifying Filters in Visuals
Creating Dashboards with Filters and Parameters
Adjusting Dashboard Settings
Using Dashboard Filters and Parameters
Dashboard Filter Types
Multi-select
Single value
Single Value with Dropdown
Creating Control Parameters
Control Element Actions
Customizing Output Parameters
Receiving Parameters in Dashboards
Optional Dimensions
Visuals with Optional Dimensions
Filters for Optional Dimensions
Optional Measures
Visuals with Optional Measures
Filters for Optional Measures
Variable Dimensions
Visuals with Variable Dimensions
Filters for Variable Dimensions
Variable Measures
Visuals with Variable
Filters for Variable Measures
Setting Parameters in URLs
Using the Date Picker
Configuring Cascading Filters
Prepare the Visual
Create the Dashboard
Adding Filters to the Dashboard
Configure Filters and Enable Cascading Filter Interaction
Explore the Dashboard Filter Interaction
Customizing Dashboard Filter Styles
Embedding
Embedding Overview
Trusted Authentication Mode for Embedded Apps
Trusted Authentication Overview
Request Protocol Syntax
Server Configuration
Server Settings
Analytical Views
Analytical Views Overview
Architecture of Analytical Views
Building Analytical Views
Routing Queries to AVs Based on Tables
Routing Queries to AVs with Logical Views
Analytical View Operations
Creating Analytical Views
Refreshing Analytical Views
Showing the State
SHOW EXTENDED ANALYTICAL VIEWS
Dropping Analytical Views
Using Analytical Views
Creating Base Tables
Loading Base Tables
Creating Analytical Views
Refreshing Analytical Views
Processing User Queries
Checking Query Routing
Enabling Aggregate Functions
Enabling Aggregate Functions
Using Aggregate Functions in Analytical Views
Managing Analytical Views in UI
Creating Analytical Views
Refreshing Analytical Views
Deleting Analytical Views
Understanding SQL of Analytical Views
Best Practices and Support
Partitioning Analytical Views
Including Query Sub-Components
Cardinality Considerations
Support Restrictions
Authorization for Analytical Views
Installation and Administration Guide
Administration
Users and User Groups
Creating User Accounts
Creating Administrator Accounts
Changing User Passwords
Inactivating User Accounts
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
Deleting User Groups
Apps
Creating New Apps
Editing the Properties of Apps
Removing Apps from the App Menu
Deleting Apps
Assigning Visuals to Apps
Removing Visuals and Dashboards from Apps
Deleting Visuals and Dashboards in Apps
Apps Security Model
Creating Standalone Applications
Custom Home Pages
Creating Simple Extension Visuals
Creating Applications with Extension Visuals
Setting Custom Home Pages
Managing Jobs
Job Log
Rerunning Jobs
Deleting Jobs
Scheduled Jobs
Pausing Jobs
Resuming Paused Jobs
Manage Schedule Intervals
Creating New Schedules
Changing Schedule Intervals
Deleting Schedule Intervals
Activity Logging
List View
Statistics
API Keys
Enabling API Keys
Creating New API Keys
Changing API Keys
Deleting API Keys
Custom Styles
Defining Styles
Modifying Styles
Deleting Styles
Custom Colors
Creating New Custom Colors
Distinct Colors
Gradient with Values
Gradient with Percentages
Editing Custom Colors
Deleting Custom Colors
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
Enabling Dataset Field Renaming
Enabling Visual Acceleration
Enabling Derived Data
Enabling Snapshots and Thumbnails
Enabling CSV Download
Customizing the Help Menu
Enabling API Keys for Interactive Map Visuals
Enabling Scheduled Jobs
Enabling and Customizing Email Settings
Enabling Custom Styling
Install/Upgrade
Installing Arcadia Enterprise
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
Set Options and Complete Installation
Start Arcadia Enterprise
Using Ambari Stacks
Start Ambari Server
Download/Prepare Arcadia Enterprise Files
Stop/Restart Ambari Service
Add Arcadia Enterprise Service
Set Options/Complete Installation
Start Arcadia Enterprise
Enable PAM Authentication in Ambari
Installing and Upgrading Arcadia Enterprise on MapR
Get and Distribute
Arcadia Enterprise
Install Files
Configure the Service Node
Configure the Other Nodes
Start Arcadia Services
Connection-Specific Additions
Enabling Oracle Data Connections
Enabling Apache Drill Data Connections
Upgrading Arcadia Enterprise on Cloudera Manager
Upgrading Arcadia Enterprise Using Ambari Stacks
Metadata Upgrade and Migrating Analytical Views
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
Connection Privileges
Dataset Privileges
Managing Member Roles
Editing Role Assignments
User Role Assignments
Group Role Assignments
Adding Multiple Users to Multiple Roles
Deleting Roles
Restricting Row-Level Access
Specifying Segments
Creating Users and User Groups
Specifying Roles
Specifying Filter Associations
Verifying Row/Column Restrictions
LDAP User Authentication
Configuration Dependencies
Collect Configuration Parameters
Authentication
Using LDAPS
Testing the Installation
Edit Local Settings File
Apache Sentry Authorization
Apache Ranger Authorization
Utilities
Utilities Overview
Saving Apps as PNG Files
Migration
Exporting Visuals and Dashboards
Importing Visuals and Dashboards
Exporting Apps
Importing Apps
Migration with REST APIs
Migrating Analytical Views
Reference
Release Notes
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
3.3.1.3
3.3.1.0
3.3.0.0
Certifications
Certifications
Partner Integration
Supported Connections
Supported MetaStores
Supported Platforms
Mobile Devices
Internet
Known Issues
Appendix
Arcadia Engine Aggregate Functions
GCDO() Function
BOOLEAN_AND() Function
BOOLEAN_OR() Function
NDVP()
Data API
Data API Interfaces
Data API Example Settings
Data API Example Usage
Admin API
Enabling Admin API Support
Syntax and General Usage
Setting Up the APIKey for Standard Login
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
Arcadia Shell (ArcShell)
Display Format Reference
Standard Format Specifier
Standard Style Table
Quantity Prefixes
Format Examples
Understanding Date/Time Formats
ARCAPI Library
Custom Style Extension JS APIs
Endpoints
ARCAPI Functions
Custom Style Extension CSS APIs
Datafiles
Glossary
Your browser does not support iframes.