Search
Related topics are listed below.
Pre-Requisistes
Alpana Update File Dependency » Installation » Pre-Requisistes
This section explains the system requirements to run Alpana Update File Dependency. Software Requirements The following minimum software requirements are necessary to run Alpana Update File Dependency : .NET Framework 4.8 can be found here then download the…
Pre-Requisites
Alpana Designer » Installation » Pre-Requisites
This section explains the system requirements to run Alpana Designer. Software Requirements The following minimum software requirements are necessary to run Alpana Designer : Operating System Windows OS (x64) : Windows 10+ Windows Server 2012R2+ Microsoft .NET…
Pre-Requisites
Alpana Server » Installation » Pre-Requisites
This section explains the system requirements to run Alpana Server. Alpana Server Pre-Requisites : Software Operating System Windows OS (x64) : Windows Server : 2012 R2, 2016, 2019 (see note below) Windows 10 (Version 1607+) !Important : A server OS is…
Pre-Requisites
Alpana OMI App » Pre-Requisites
The following software pre-requisites are needed : Wonderware System Platform 2020, or Wonderware System Platform 2017 Update 3 Alpana Advanced license Dashboards or Widgets published on Alpana Server v3.2.1.5 or later *Note : During the OMI Preview, the Alpana…
Important pre-requisite
Alpana Designer » Wonderware Historian » Connecting to Wonderware Historian » Important pre-requisite
!Important If you connect to a fresh install of Wonderware Historian Server, tags may not be available for browsing. Starting Historian clients once In order to make tags available for browsing, you will have to startup Wonderware Historian Client Query or Wonderware…
Learning Pre-Requisites
Alpana Designer » Transforming Data » Introduction » Learning Pre-Requisites
To create Data Sources, you will need to connect to your data first. Please see the corresponding chapter : Connecting to Data. More generally, it is also important to understand the Alpana data model.
Binding to Real-Time Data
Alpana Designer » Configuring a Widget » Widget Data Binding » Binding to Real-Time Data
Introduction Instead of binding Widget data to a Alpana Data Source, you can configure it to accept Real-Time Data. Instead, it lets you create a Widget with no Data Source, and then you can push data directly into the Widget, using the Alpana web API. The general…
Functions reference
Alpana Designer » Transforming Data » Calculating Expressions » Functions reference
*Important : the exact behavior of each function depends on the database engine that is running them. The same function can have a different behavior depending on whether it is used on an Oracle Connection, or MS SQL, or SQLite (Designer buffer). Below is a list of…
Components and Architecture of Alpana
About Alpana » Components and Architecture of Alpana
Installable components Alpana Platform is composed of : Alpana Designer : the development tool for creating Data Sources, Widgets, Dashboards Alpana Server : the website deployed for sharing content Alpana Mobile : the mobile app used for viewing on mobile…
Using Parameters
Alpana Designer » Transforming Data » Custom Query Tables » Using Parameters
Parameters can be used to parametrize a Custom Query : the Custom Query changes dynamically. Syntax ${parametername} will be replaced in-place by the values of “parametername”. Example : SELECT * FROM MyTable WHERE MyColumn = ${parametername} will get replaced…
Link To URL
Alpana Designer » Configuring a Widget » Interactions » Link To URL
Introduction Most Widgets can be configured as a link to a URL : when the user clicks on the Widget, the URL is opened. It is possible to configure the URL to be generated dynamically : when the user clicks on different parts of the Widget, different URLs are…
Label Parameters
Alpana Designer » Using Dashboard Parameters » Parameter usage » Label Parameters
Parameters can be used as a placeholder inside a text string : the placeholder is replaced dynamically by the Parameter’s value. Syntax ${parametername} will be replaced in-place by the values of the Parameter called “parametername”. Example : The high…
Filtering number fields
Alpana Designer » Transforming Data » Filtering Data » Configuring Filter Conditions » Filtering number fields
In a basic configuration, the condition is expressed as : For example : DownTimeDuration > 10 Operators Operators appropriate to Numbers can be selected : Field formatting In addition to the basic configuration, a formatting function can be applied to the…
Filtering number fields
Alpana Designer » Configuring a Widget » Widget-level Filtering » Configuring Filter Conditions » Filtering number fields
In a basic configuration, the condition is expressed as : For example : DownTimeDuration > 10 Operators Operators appropriate to Numbers can be selected : Field formatting In addition to the basic configuration, a formatting function can be applied to the…
Filtering date fields
Alpana Designer » Configuring a Widget » Widget-level Filtering » Configuring Filter Conditions » Filtering date fields
In a basic configuration, the condition is expressed as : For example : aaValueStartTime > 2018-01-05T00:00:00 Operators Operators appropriate to Dates and Times can be selected : Relative date filtering The special operator “Relative date”…
Filtering date fields
Alpana Designer » Transforming Data » Filtering Data » Configuring Filter Conditions » Filtering date fields
In a basic configuration, the condition is expressed as : For example : aaValueStartTime > 2018-01-05T00:00:00 Operators Operators appropriate to Dates and Times can be selected : Relative date filtering The special operator “Relative date”…
Configuration
Alpana Designer » Widget Properties Reference » Static Widgets » Embed » Configuration
Source Url This is the Url that points to the content you wish to embed. Simply paste the Url in this text box. Dynamic URL You can update the URL displayed in the widget when a Parameter value is updated. For this, use the Parameter placeholder…
Grid KPI
Alpana Designer » Widget Properties Reference » Grid » Grid KPI
Introduction A KPI Expression (a new calculated column) can be generated to show how a value deviates from a target. Creating a KPI To create a KPI, navigate under section Column Settings near the list of KPI Expressions and click the + icon : Configuring a…
Example
Alpana Designer » Using Dashboard Parameters » URL Parameters to receive values » Example
Your dashboard contains a Parameter called Parameter1 and another called Parameter2 which accepts multiple values. The dashboard is published at http://yoursite.com/viewer/dashboard/YourDashboardID By adding this…
Pitfall : Incorrect result in Expression with division
Alpana Designer » Transforming Data » Expressions Troubleshooting » Pitfall : Incorrect result in Expression with division
Your issue In some cases, Expressions with a division will give an unexpected result : 0 everywhere, or imprecise value for example. Example Expression : Expression1 = 100 * (SUM([isActive]) / COUNT([ID])) In this case I want the % of Active items. [isActive] is 0…
Client-Side Hooks
Alpana Server » API » Client-Side Hooks
Alpana provides hooks to let you implement custom behavior when you embed inside your application. You can subscribe to be notified of the event in Javascript, and get event properties. !Authentication is not explained here, and should be managed by your application…
Website Troubleshooting
Alpana Server » Troubleshooting » Website Troubleshooting
Below are some useful resources and some answers to common issues with reaching or starting the websites. Useful logs IIS Requests Logs If you need to investigate your network configuration to see the content of HTTP requests, you can find IIS log files : 1. Open…
Manual Time Settings
Alpana Designer » Aveva Insight » Querying Insight » Configuring the query » Time Settings » Manual Time Settings
What are Manual Time settings When using Manual Time Settings, the start date and end date of the Insight query cannot be changed by user interaction at runtime. Note that you can still create a moving time frame, see below. This allows to make a pre-defined query to…
Web
Alpana Designer » Connecting to Data » Connection types » Web
The web connector is used to connect to different Web API source. Using GET or POST methods, you can query your data. *Alpana is using JSONPath to perform transformation to the received data. Formats The Web Connector allows to get data from RESTful Web Services…
Installation
Alpana Server » Installation
To install Alpana Server, please follow the below chapters. Pre-Requisites are very important, in particular “IIS Configuration”.
Value Display
Alpana Designer » Widget Properties Reference » Card » Value Display
Depending on how it’s configured, the Card displays several informations : Each part can be configured, as detailed below. Configuring KPI, Left Value, Right Value For each of KPI, Left Value, Right Value, the following can be configured : Show/hide Each…
Static Time Settings
Alpana Designer » Wonderware Historian » Creating Queries to Wonderware Historian » Configuring the Historian Query » Time Settings » Static Time Settings
What are Static Time settings When using Static Time Settings, the start date and end date of the Historian query cannot be changed by user interaction at runtime. Note that you can still create a moving time frame (see below). This allows to make a pre-defined query…
Getting Started
About Alpana » Getting Started
Getting started with Alpana is easy, and the summary below should help you follow the steps. Getting Alpana Contact your official Distributor to get a license. If you don’t know who is your official Distributor, get in touch with us at information@code192.com…
fetching data from a Stored Procedure
Alpana Designer » Transforming Data » Fetching Data » fetching data from a Stored Procedure
Important notice Stored Procedure can perform destructive actions when called : deleting tables, inserting data, etc… In Alpana, the Stored Procedure will be called every time data is fetched : every time anyone loads a dashboard or refreshes a filter pointing…
2021 R1
About Alpana » Release Notes » 2021 R1
Release notes of items completed between 2020 R2 Patch 1 and 2021 R1 Alpana Server and Alpana Designer have been upgraded from 3.3.1.20 to 3.4.0.3 Alpana Update File Dependency has been upgraded from 1.1.0.2 to 1.2.0.1 Introduction Version 2021R1 is a major release…
Custom Query Tables
Alpana Designer » Transforming Data » Custom Query Tables
What is a Custom Query Table ? When composing a Data Source, you are not limited to using Tables or Views from your Connection. You can also add a Custom Query Table : similarly to a SQL View, you write a SQL query and a Table will be created in the currently opened…
Actions
Alpana Server » Schedule Management » Creating a Schedule » Actions
The Action defines what will be executed when the Trigger happens. There are two types of Actions : Refresh open dashboards This will force open the Dashboards of the Target users to refresh. This is useful for implementing even-based refresh : You have a…
Fetching Data
Alpana Designer » Transforming Data » Fetching Data
Introduction A Data Source can fetch data from Connections by selecting the corresponding object in the Connection schema : a data Table a data View a Stored Procedure a Table-Valued Function an Alpana Custom Query Table (see next Chapter Custom Query…
Input Grid
Alpana Designer » Widget Properties Reference » Input Grid
The Alpana Runtime Connection Input Grid widget allows to configure an input form for an existing Runtime Connection and include it inside a Dashboard. *This widget is a bit special : it allows to input data. it is not bound to a Data Source it is not displayed…
Installation Troubleshooting
Alpana Server » Troubleshooting » Installation Troubleshooting
installation logs After Alpana installation, you will be prompted with a windows that ask you if you want to save installation log file : *If you get any trouble during the installation, the support will need the installation log file. Get the Alpana Server…
How to Use a Custom CSS
Alpana Server » Administration » Theme and Appearance » How to Use a Custom CSS
Applying a Custom CSS To apply your Custom CSS theme to Alpana Server please follow the below steps: Prepare the Theme First, you need to go to the Visual Settings Page by clicking on Administration (Step 1 on screenshot), then click to Visual Settings (Step 2 on…
API Origins Whitelist
Alpana Server » Administration » Host-level Settings » API Origins Whitelist
Why Querying or embedding a content from Alpana into another website requires to be allowed from Alpana. This is called Cross-origin resource sharing , see also Same-origin policy. If you fail to do so, you won’t be able to query or embed Alpana content from…
Alpana Runtime
Alpana Designer » Connecting to Data » Connection types » Alpana Runtime
Introduction The Alpana Runtime connection allows to connect to Runtime Connections you created in Alpana Server, see Runtime Connections. This allows you query this data in a Data Source, and then display it in Widgets like any other data. Pre-requisite : login In…
General upgrade procedure for v3
About Alpana » Upgrading » General upgrade procedure for v3
Introduction : limits of applicability This procedure only applies if you are upgrading from Alpana Server v3.0 or newer. Upgrading from older versions requires manual steps detailed elsewhere. Some v3 upgrades may still require specific attention or manual steps.…
v3.1.0
About Alpana » Release Notes » v3.1.0
Release notes of items completed between Alpana and v3.0.2.2 and v3.1.0.7 Upgrading New Pre-Requisites Alpana Server and Designer v3.1.0.7 now require .NET Framework 4.8 Alpana Server install upgrade from v3 To upgrade Alpana Server from v3.0.2.2, see Upgrading…
v3.2.1
About Alpana » Release Notes » v3.2.1
Release notes of items completed between Alpana v3.1.2.1 and v3.2.1.5 Alpana Update File Dependency has been upgraded from v1.0.0.4 to v1.0.2.1 New Pre-Requisites IIS Express is no longer necessary as a pre-requisite of Alpana Designer. It may be uninstalled…
Creating a Runtime Connection table schema
Alpana Server » Runtime Connections » Creating a Runtime Connection table schema
This chapter describes creating the schema for a Runtime Connection table. This is similar to creating a template form for the user input, or defining a schema for the hosted table. Creating a new Runtime Connection Select a folder and click the Create Runtime…
Widget Auto-refresh
Alpana Designer » Dashboard Settings and Publication » Dashboard-level Settings » Widget Auto-refresh
What is Auto-Refresh At runtime, when the Dashboard loads in the browser, data is fetched from the data sources and Widgets are drawn. After this, if the user doesn’t interact with the Dashboard, no new data is fetched and the data displayed can become…
Upgrading from an older v2 to v3.0
About Alpana » Upgrading » Upgrading from an older v2 to v3.0
Introduction : limits of applicability This procedure only applies if you are upgrading from Alpana Server version number starting with v2 Dashboards migration Notice of incompatibility Due to internal changes for supporting new features, two component from…
Configuration
Alpana Designer » Widget Properties Reference » Input Grid » Configuration
When clicking the widget’s settings, the Edit Input Grid dialog opens and lets you configure the options of that widget : Selecting a Target Connection Once you are connected to Alpana Server, the dialog presents the list of all Runtime Connections published…
2020 R1
About Alpana » Release Notes » 2020 R1
Release notes of items completed between Alpana v3.2.3.3 and 2020 R1 Alpana Update File Dependency has been upgraded from v1.0.2.1 to 1.1.0.2 Alpana Real Time Data has been upgraded from v1.0.2.1 to 1.1.0.2 Introduction Version 2020 R1 is the first big release of the…
User Settings
Alpana Server » Administration » Users, Roles and Permissions » User Settings
As administrator of the Host or of a Tenant, you can configure user account and login features on a global level. To manage user account and login features of a Host or Tenant, go to the corresponding Administration > Settings and browse to the tabs User management…
Measure Formatting and Date Formatting
Alpana Designer » Configuring a Widget » General Widget Properties » Measure Formatting and Date Formatting
Introduction Most Widgets show data labels for values and dates, which may depend on user culture and personal choices. The properties panel has a “Format” section which allows to configure these labels. All number and date fields are listed there, and…
2020 R2
About Alpana » Release Notes » 2020 R2
Release notes of items completed between Alpana 2020 R1 and 2020 R2 Alpana Server and Alpana Designer have been upgraded from 3.3.0.25 to 3.3.1.17 Alpana Update File Dependency has been upgraded from 1.1.0.2 to 1.1.1.0 Introduction Version 2020 R2 is a minor release…
Installing
Alpana Server » Installation » Installing
Important !Before installing, make sure you meet the Pre-Requisites. *Alpana Server will create folders and SQL databases. Download installer See here to download the installer. Running the Alpana Server installer Login with administrator rights to the machine…