Code 192
Alpana — 2020R2 Patch1
2023R1
2022R2
2022R1
2021R2
2021R1
2020R2 Patch1
2020R2
2020R1
3.2.x
3.1.x
3.0.x
Table of Contents
Code 192
Alpana — 2020R2 Patch1
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 and Architecture of Alpana
Getting Started
License Portal and Installers Download
Release Notes
v3.0.1.x
v3.0.2.x
v3.1.0
v3.1.2
v3.2.1
v3.2.2
v3.2.3
2020 R1
2020 R2
2020 R2 Patch 1
Upgrading
License incompatibility for Major upgrades
General upgrade procedure for v3
Upgrading from an older v2 to v3.0
Upgrading from an older v1 version
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
Redundant Connections
The data Buffer
Bufferized Connection types : What gets bufferized ?
Data Flow : How bufferization happens ?
Buffer database setup
Buffer Refresh settings
refreshing file-based connections
Creating and Managing Connections
Create a Connection
Edit a Connection
Delete a Connection
Connection types
SQL Server
Excel
CSV
Wonderware Historian
Web
Oracle
Alpana Runtime
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
Aveva Insight
Connecting to Insight
Selecting Connection Type
Login to Aveva Cloud Operations
Test connection
Data refresh and Buffer
Querying Insight
Picking Tags
Browsing for Tags
Selecting Tags
Configuring the query
Going to Query Configuration
Query Type
Time Settings
Manual Time Settings
Parameter Based Settings
Process Values : query parameters
Renaming the Query Table
Configuring the query result
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
Copying/Pasting 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
Binding to Real-Time Data
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
Getting Distinct Values
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
Y 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
Footer
HTML in the Grid
TreeMap
Binding Data
Managing Colors
Data Point information
Circular Gauge
Binding Data
Value Display
Style and Appearance
Linear Gauge
Data Binding
Value display and Limits configuration
Style and Appearance
Card
Binding Data
Value Display
Card Sparkline
Sparkline
Binding Data
Configuring Layout
Sparkline chart style
Style and Appearance
Banner
Binding Data
Style and Appearance
Proportion Charts
Binding Data
Switching Chart type
Data Point information
Legend
Managing Series Color
Interaction
Style and Appearance
Gantt
Binding Data
Data Point Information
Events Configuration
Axis Configuration
Titles Configuration
Sankey
Binding Data
Data Point information
Energy Rating
Binding Data
Grading Calculation and Display
Titles and Labels
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
Configuring without data
Binding Data
Configuring behaviour
Configuring style
RangeNavigator
Binding Data
Configuring behaviour
Configuring style
TreeView
Binding Data
Configuring Behaviour
Static Widgets
Image
bind image
Image Modes
Label
Configuration
Embed
Configuration
Note : Cross-origin resource sharing
PDF viewer
Configuration
Input Grid
Configuration
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
Label Parameters
Dynamic calls to Stored Procedures or Table-Valued Functions
Dynamic calls to Custom Queries
Dynamic Expression Values
Dynamic Data Source filters conditions
Dynamic Widget filters conditions
Dynamic Historian Queries
Include Parameter value in a Link to URL
Widget-specific binding
Grid conditional formatting
Dynamically updating embedded content
Dashboard Layout
Managing Layouts
Dashboard Theme and Background
Layout size and Responsiveness
Configuring Widgets on the Layout
Layouts for PDF Exports
Layouts for Mobile
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-level Settings
Dashboard Title
Widget Auto-refresh
Disabling Comments
Widget Headers size
Designer-level Settings
Login to Alpana Server
Alpana Server
About Alpana server
Architecture
Multitenancy
Installation
Pre-Requisites
Installing
Anti-virus and Firewall set up
Post-Installation
Un-Installing
Login and User Profile
Selecting a Tenant or the Host
Login options
User Settings and Logout
Linked Accounts
Account details and password
Account Security and Privacy
Notifications
Chat
Dashboards
Categories
Browsing the Dashboards
Viewing Dashboards
Opening Dashboards for Viewing
Favorite Dashboards
Refreshing Dashboards
Manual Exports
Dashboard Views
Comments
Pinning Widgets
Managing / Publishing Dashboards
Dashboard Version History
Public / Private Dashboards and Dashboard-level Permissions
Linking / Embedding Dashboards
Widgets
Viewing Widgets
Managing / Publishing Widgets
Widget Version History
Linking / Embedding Widgets
Data Sources
Managing / Publishing Data Sources
Data Sources Version History
Schedule Management
Schedules management
Creating a Schedule
Main
Trigger
Timer
Data condition
Managing conditions
Logical condition
Field value watcher
Actions
Targets
Homepages and Pinning Widgets
Viewing Homepages
Creating Homepages
Pinning Widgets
Editing the Homepage Layout
Runtime Connections
Folders
Browsing the Runtime Connections
Creating a Runtime Connection table schema
Inputting and Managing data
Runtime Connections Management
Managing Permissions of Runtime Connections
Administration
License Management
License Activation
Host-level Features
License Deactivation
Tenant Management
Browsing the Tenants
Creating a Tenant
Tenant Features
Users, Roles and Permissions
Permissions descriptions
Roles
Users
User Lockout
User Impersonation
User Settings
Theme and Appearance
Host-level Settings
Email (SMTP)
API Origins Whitelist
External Login
Concurrent Login
Background Jobs
Webhook Subscriptions
API
General API help and troubleshooting
Authentication to the API
Remote Actions
Refreshing / Updating Filters
Real Time Widgets Data
Client-Side Hooks
Maintenance and Migration
Start / Stop IIS websites
Backup
Migration
Troubleshooting
Installation Troubleshooting
Dashboard error logs
Server usage logs
Website Troubleshooting
License troubleshooting
Accessing behind a router
Alpana Mobile
Installation
How to get Alpana Mobile
Setup
Usage
Login
Tenancy
Dashboard Page
Alpana Update File Dependency
Installation
Pre-Requisistes
Installing
Running the application
Settings
Connecting To Alpana
Jobs
Creating a Job
Configuring a Job
Target Dependency
Source File
Update Mode
Running jobs
Deleting a Job
Troubleshooting
Alpana Real Time Data
Installation
Pre-Requisistes
Installing
Running the application
Settings
Connecting To Alpana
Jobs
Creating a Job
Configuring a Job
Target Widget
Data Source
Running jobs
Deleting a Job
Troubleshooting
Alpana OMI App
Pre-Requisites
Importing
Importing in WSP 2017 U3
Importing in WSP 2020
Adding to a Layout
Configuring
Connecting to Alpana
Selecting Visuals
Configuring interactions
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.