Code 192
Alpana — 3.0.x
2023R1
2022R2
2022R1
2021R2
2021R1
2020R2 Patch1
2020R2
2020R1
3.2.x
3.1.x
3.0.x
Table of Contents
Code 192
Alpana — 3.0.x
Alpana — 2023R1
Alpana — 2022R2
Alpana — 2022R1
Alpana — 2021R2
Alpana — 2021R1
Alpana — 2020R2 Patch1
Alpana — 2020R2
Alpana — 2020R1
Alpana — 3.2.x
Alpana — 3.1.x
Alpana — 3.0.x
About Alpana
Components of the application
License Portal and Installers Download
Release Notes
v3.0.1.x
v3.0.2.x
Upgrading from an older v2 to v3.0
Alpana Designer
Installation
Pre-Requisites
Installing Alpana Designer
Anti-virus and Firewall set up
Upgrading Alpana Designer
Uninstalling Alpana Designer
Troubleshooting
Finding error logs
Connecting to Data
Alpana data model
Note on data storage
The data Buffer
Bufferized Connection types : What gets bufferized ?
Data Flow : How bufferization happens ?
Buffer database setup
Buffer Refresh settings
Creating and Managing Connections
Create a Connection
Edit a Connection
Delete a Connection
Connection types
SQL Server
Excel
CSV
Wonderware Historian
Web
SQLite
Wonderware Historian
Connecting to Wonderware Historian
Version compatibility
Important pre-requisite
Selecting Connection Type
Login to a Wonderware Historian server
Test connection
Data refresh and Buffer
Creating Queries to Wonderware Historian
Picking Tags
Browsing for Tags
Selecting Tags
Configuring the Historian Query
Going to Query Configuration
Query Type
Time Settings
Static Time Settings
Parameter Based Settings
History Values : query parameters
History Values: query Format
State Statistics : query parameters
Renaming the Query Table
Wonderware Historian query result
Connection Schema
Important : data limits
Transforming Data
Introduction
Learning Pre-Requisites
What are Data Sources
Content : Data Preparation Activities
Creating and Managing Data Sources
Create a Data Source
Browsing Data Sources to Edit
Rename a Data Source
Delete a Data Source
Duplicate a Data Source
Export / Import Data Sources
What is a Data Source Export
Export a Data Source to a file
Import a Data Source from a file
Publish a Data Source to Alpana Server
Import a Data Source from Alpana Server
Fetching Data
using the Data Preview
getting and browsing the Connection schema
fetching data from a data Table
fetching data from a data View
fetching data from a Stored Procedure
fetching data from a Table-Valued Function
Removing a table from the Data Source
Custom Query Tables
Language
Creating a Custom Query Table
Updating a Custom Query Table
Using Parameters
Merging Data
Creating Joins
Configuring Joins
Updating Joins
Filtering Data
Opening the Filter Editor
Managing Filter Conditions
Configuring Filter Conditions
Filtering string fields
Filtering number fields
Filtering date fields
Limiting dataset size
Calculating Expressions
Opening Expression Editor
Managing Expressions
Expression properties
Adding a constant
Adding a field
Adding a function
Removing an existing item
Copying and Pasting an existing item
Aggregated Expressions
Expressions Troubleshooting
Pitfall : Incorrect result in Expression with division
Pitfall : Calculating ratios, averages, …
Error when mixing aggregate fields and non-aggregate fields
Error when wrapping aggregate fields inside aggregate functions
Value-based Settings
Value-based Colors
Formatting Columns
Renaming Columns
Changing Column Type
Hiding Column
Configuring a Widget
Creating and Managing Widgets
Adding a Widget
Editting a Widget
Renaming a Widget
Deleting a Widget
Export / Import Widgets
What is a Widget Export
Export a Widget to a file
Import a Widget from a file
Publish a Widget to Alpana Server
Import a Widget from Alpana Server
Widget Data Binding
using the Widget Preview
Troubleshooting Widget data
Editing Widget data binding
Selecting a Data Source
Configuring the aggregation of number fields
Configure the grouping of category fields
Binding a data field
Un-binding a data field
Re-Ordering data fields
Configure a sorting order
Widget-level Filtering
Opening the Filter Editor
Managing Filter Conditions
Filtering aggregated values
Configuring Filter Conditions
Filtering string fields
Filtering number fields
Filtering date fields
Limiting dataset size
General Widget Properties
Editing Widget Properties
Name, Header and Description
Container Appearance
Widget Menu items
Measure Formatting and Date Formatting
Multi-items Viewport
Animation
Interactions
Drill-Down
Link To URL
Master Filter
Widget Properties Reference
Cartesian Chart
Binding Data
Chart Types
Switching Chart Types
Combining Chart Types
Series Settings
Series Name
Axis binding
Data Point information
Style and Appearance
Axes
X Axis
Strip Line
Paging / Scrolling
Y Axes
Strip Line
Legend
Managing Series Color
Chart value color binding
Trend Lines
Polar Chart
Binding Data
Chart Types / Draw Types
Switching Chart Types
Series Settings
Series Name
Style and Appearance
X Axis
Legend
Map
Maps format : GeoJSON
Choosing a map
Binding Data
Managing Colors
Data Point information
Runtime navigation
Grid
Binding Data
Layout and appearance
User interaction
Column names
Value display
Conditional Formatting
Grid KPI
HTML in the Grid
TreeMap
Binding Data
Managing Colors
Data Point information
Gauge
Binding Data
Value Display
Style and Appearance
Card
Binding Data
Value Display
Style and appearance
Proportion Charts
Binding Data
Switching Chart type
Data Point information
Legend
Managing Series Color
Interaction
Style and Appearance
Filter Widgets
ComboBox
Binding Data
Configuring behavior
Style and Appearance
CheckBox
Binding Data
Configuring behaviour
Style and Appearance
RadioButton
Binding Data
Configuring behaviour
Style and Appearance
RangeSlider
Binding Data
Configuring behaviour
Configuring style
DatePicker
Binding Data
Configuring behaviour
Configuring style
RangeNavigator
Binding Data
Configuring behaviour
Configuring style
Static Widgets
Image
bind image
Image Modes
Label
Configuration
Embed
Configuration
Note : Cross-origin resource sharing
Using Dashboard Parameters
What is a Parameter ?
Managing Parameters
Opening the Parameters Editor
Visualizing Parameter binding
Editing Parameter bindings
Necessary connections
Removing a connection
Adding a connection
Adding/Removing Parameter
Edit Parameter properties
Parameter Name
Value Type
Parameter Default Value
example : Multi-Data Source filtering
Widget as Master Filter
Configuring a Widget as Master
Setting a Widget Default Selection
Using filters at runtime
URL Parameters to receive values
Example
Reserved words
Parameter usage
Dynamic calls to Stored Procedures or Table-Valued Functions
Dynamic calls to Custom Queries
Dynamic Historian Queries
Dynamic Expression Values
Dynamic Data Source filters conditions
Dynamic Widget filters conditions
Widget-specific binding
Grid conditional formatting
Dashboard Settings and Publication
Dashboard Preview
Create and Export / Import Dashboards
Creating a New Dashboard
What is a Dashboard file
Save a Dashboard as file
Open a Dashboard file
Publishing a Dashboard to Alpana Server
Importing a Dashboard from Alpana Server
Dashboard Layout
Layout size and Responsiveness
Moving Widgets
Re-sizing Widgets
Dashboard-level Settings
Dashboard Title
Dashboard Theme and Background
Widget Auto-refresh
Disabling Comments
Designer-level Settings
Login to Alpana Server
Alpana Server
About Alpana server
Architecture
Multitenancy
Installation
Upgrading
Pre-Requisites
IIS Configuration pre-requisite
Installing
Post-Installation
Un-Installing
License Management
License Activation
Host-level Features
License Deactivation
Troubleshooting
Installation Troubleshooting
Dashboard error logs
Website Troubleshooting
Maintenance and Migration
Backup
Migration
Tenant Management
Creating a Tenant
Create Tenant using Email Address
Tenant Features
Categories Management
Creating Categories
Settings
Settings-Tenant Management
User Settings
Settings- Security
Email (SMTP)
Settings-Other Settings
Settings-Appearence (Use Custom CSS)
API Origins Whitelist
Manage Users and Permission
Create User
Edit User
Delete User
Excel Operations
Export users details
Import User Details
Manage Roles
Create Role
Edit Roles
Delete Role
Assign Role to User
API
General API help and troubleshooting
Authentication to the API
Remote Actions
Refreshing / Updating Filters
Alpana Mobile
Installation
How to get Alpana Mobile
Setup
Usage
Login
Tenancy
Dashboard Page
Download as PDF
Create a Connection
To create a new Connection, click
New
:
Last modified:
Apr 16, 2019
Creating and Managing Connections
Edit a Connection
Feedback
Was this helpful?
Yes
No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
×
Thanks for your feedback.
Post your comment on this topic.
Your name *
Your e-mail address *
Comment *
Post Comment
Post your comment on this topic.