Toggle navigation
Documentation
User Guide
Developer Guide
Install/Admin Guide
Reference
Documentation at a Glance
We're here to help.
Arcadia Enterprise
3.3.0
(ArcViz 3.3.0, ArcEngine 2.5.1)
User Guide
Visualizing Data
Apps Interface
Working with Visuals
Creating Visuals
Cloning Visuals
Deleting Visuals
Emailing Visuals
Saving Table Data
Saving Data to CSV Files
Visualizations
Visual Types
Table
Cross Tabulation
Bars
Filtering by Year
Filtering by Region
Horizontal Bars
Stacked Bars
Lines
Making Line Visuals Interactive
Line Visuals with Dual Axis
Bars and Lines
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
Packed Bubbles
Scatter Visuals
Basic Scatter Visual
Adding Size
Adding Transition Animation
Adding Trellises
Flow Visuals
Funnel Visuals
Pie Visuals
Radial Visuals
Chord Visuals
Correlation Heat Map
Correlation Flow
Calendar Heat Map
Sparklines
URL Links
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
Maps with Trellis Option
Interactive Maps
Interactive Maps; Tile Layers
Interactive Maps; Layer Options
Histograms
Extension Visuals, Simple
Customizing Settings for Visuals
Customizing Axes
Bars and Grouped Bars Axes Options
Line and Area Axes Options
Combined Bar/Line Axes Options
Scatter Axes Options
Radial Axes Options
Calendar Heat Map Axes Options
Map Axes Options
Column Statistics Axes Options
Customizing Basic Settings
Histogram Bucket Count
Normalized Histograms
Cumulative histograms
Customizing Color
Reverse Color Palette
Change Color Palette
Enabling Color
Changing Color Opacity
Making Colors Consistent on Dimension Values
Assigning Color to Dimension Values
Customizing Data
Ordering NULL Rows
Displaying NULL Rows
Enabling Links
Customizing Layer Options
Heatmap Layer Options
Cluster Layer Options
Circle Marker Layer Options
Marker Layer Options
Customizing Marks
Arc Width
Autoplay Transition Animation
Autoplay Transition Delay
Bar Size
Convert Line to Area Visual
Data Points
Highlight Mark Type
Highlight Mark Size
Ignore Missing Dates
Legend
Marks as Bubbles
Marks Size Range
Overlap Marks
Reverse Legend Order
Trendlines
Customizing Parameters
Setting Explicit Scope for Visuals
Sending All Columns
Customizing Styles
Customizing Tables
Choosing Table Templates
Choosing Header Alignment
Adjusting Table Width
Showing Table Information
Showing Totals
Specifying Number of Exported Records
Showing Pagination
Customizing Tooltip
Customizing Zoom
Customizing Visual Field Options
Aggregates
Date/Time Functions
Text Functions
Analytic Functions
Change Type
Types Supported for Conversion
Timestamp
String
Integer
Real
Boolean
Geo
Remove Cast
Order
Enter/Edit Expression
Display Format
Numbers
Percentages
Scientific
Currency
Date/Time
Custom
Alias
Description
Duplicate
Derived Data
Advanced Visualization Techniques
Working with Applications
Creating Applications
Customizing Styles for Apps
Automatic Application Refresh
Thumbnails
Connecting to Data
Connecting to a Data Source
Creating Data Connections
Arcadia Engine
Impala
Hive
SQLite
TD Aster
Apache Drill
Spark SQL
Oracle DB
Apache Solr
MySQL
MariaDB
PostgreSQL
Amazon Redshift
Editing Data Connections
Deleting Data Connections
Using Connection Explorer
Importing Data
Importing Data from Flat Files
Creating Datasets from Imported Data
Working with Data
Overview of Data Modeling
Datasets
Creating Datasets
Finding Datasets
Dataset Details
Related Apps
Removing Datasets
Working with Joins
Creating Joins
Changing Join Types
Editing Join Details
Deleting Joins
Eliminating Joins
Working with Logical Views
Working with Column Attributes
Hiding Columns from Applications
Changing Column Aggregations
Changing Column Definitions
Changing Column Type
Adding Column Comments
Automatically Renaming Columns
Custom Renaming Columns
Advanced Analytics
Analysis Overview
Working with Dimension Hierarchies
Creating New Dimension Hierarchies
Changing Dimension Hierarchies
Deleting Dimension Hierarchies
Working with Segments
Creating Segments
Cloning Segments
Editing Segments
Creating Entity Segments
Deleting Segments
Creating Segments from Filters
Working with Events
Creating Events
Cloning Events
Editing Events
Deleting Events
Visuals for Analytics
Bars and Lines
General Bar and Line Chart Visuals
Using Secondary Axis
Changing Lines to Areas
Flows
Funnels
Correlation Flows
Histograms
Advanced Visualization Techniques
Trellis
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
Accelerating Apps
Using Arcadia Smart Acceleration
Developer Guide
Filters/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 Application Controls
Application Control Filters
Multi-select
Single value
Single Value with Dropdown
Creating Control Parameters
Control Element Actions
Customizing Output Parameters
Receiving Parameters in Apps
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
Daterange Picker in Apps
Linking Application Filters
Prepare the Visual
Create the Application
Adding Filters to the Application
Configure Filters and Enable Linking
Explore the Application Filter Interaction
Customizing Application Filter Styles
Security Model
Security Overview
Role Based Access Control
Overview of Role Based Access Control
List of Permissions
Support for Sentry Authentication
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
Global Settings
Settings Overview
Managing Site Settings
Turning On Dataset Attribute Renaming
Turning On App Acceleration
Turning On Derived Data
Turning On Thumbnails
Customizing the Help Menu
Specifying API Keys for Interactive Maps
Enabling and Customizing Emails
Turning On Custom Styling
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
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
Embedding
Embedding Overview
Trusted Authentication Mode for Embedded Apps
Trusted Authentication Overview
Request Protocol Syntax
Server Configuration
Server Settings
Utilities
Utilities Overview
Saving Apps as PNG Files
Migrating Datasets, Visuals, and Apps
Migrating Analytical Views
Install/Admin Guide
Administration
Welcome
Starting with Arcadia Enterprise
Main Navigation
Getting Help
Managing Your Account
Login
Changing Your Password
Logout
Managing Other Users
Creating User Accounts
Creating Administrator Accounts
Changing User Passwords
Inactivating User Accounts
Deleting 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
Managing App Groups
Creating Custom App Groups
Assigning Visuals to App Groups
Managing Visuals in App Groups
Editing App Groups
Navigating Through App Groups
App Group Security Model
Externalizing: Standalone Applications
Customizing Home Pages
Creating Simple Extension Visuals
Creating Applications with Extension Visuals
Setting Custom Home Pages
Managing Custom Colors
Creating New Custom Colors
Distinct Colors
Gradient with Values
Gradient with Percentages
Editing Custom Colors
Deleting Custom Colors
Managing Custom Styles
Defining Styles
Modifying Styles
Deleting Styles
Activity Logging
List View
Statistics
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
Connection-Specific Additions
Enabling Oracle Data Connections
Enabling Apache Drill Data Connections
Updating Sentry Configuration
Upgrading Arcadia Enterprise on Cloudera Manager
Reference
Release Notes
3.3.0
3.2.1
3.2.0
3.1.0
3.0.0
2.4.1
Certifications
Certifications
Known Issues
Known Issues
PNG Export and Thumbnails Package Dependencies
PNG Export and Thumbnails Custom JS
Metadata Sync Delay
Optional Services on Ambari 2.1
Emails Not Monitored
Job Logs Pagination
Non-ASCII in Email Titles
AV: Exception on Refresh
Appendix
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
Arcadia Engine Aggregate Functions
GCDO() Function
BOOLEAN_AND() Function
BOOLEAN_OR() Function
Data API
Data API Interfaces
Data API Example Settings
Data API Example Usage
Datafiles
Datafiles
Glossary
Glossary
