Search
Related topics are listed below.
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 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 7+ Windows Server 2012+ Microsoft .NET…
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…
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.
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-Requisistes
Alpana Real Time Data » Installation » Pre-Requisistes
This section explains the system requirements to run Alpana Real Time Data. Software Requirements The following minimum software requirements are necessary to run Alpana Real Time Data : .NET Framework 4.8 can be found here then download the “Runtime”.…
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…
Web 2
Alpana Designer » Connecting to Data » Connection types » Web 2
Formats The Web Connector allows to get data from RESTful Web Services that serve JSON content. Supported response content include the three most commons standards: JSON:API, ODATA, JSEND JSON:API format example: { "links": { "self":…
Installation
Alpana Server » Installation
To install Alpana Server, please follow the below chapters. Pre-Requisites are very important, in particular “IIS Configuration”.
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…
Installation Troubleshooting
Alpana Server » Troubleshooting » Installation Troubleshooting
Generating install logs In some cases, the installation of Alpana Server may fail and roll back the changes. To get more information, you can start the installer with error output by following the below procedure. Start cmd Run Windows command prompt…
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…
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.…
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…
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…
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…
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…
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…
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…
Web
Alpana Designer » Connecting to Data » Connection types » Web
Formats The Web Connector allows to get data from RESTful Web Services that serve JSON content. Supported response content include the three most commons standards: JSON:API, ODATA, JSEND JSON:API format example: { "links": { "self":…
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…
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”…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
Binding Data
Alpana Designer » Widget Properties Reference » Grid » Binding Data
Introduction The following field containers are available for configuring data binding on a Grid : Column(s) : fields that will be Grid columns Hidden Column(s) : field that will be in the query but not visible to the user Columns Any number of fields of any…
Switching Chart Types
Alpana Designer » Widget Properties Reference » Polar Chart » Switching Chart Types
When adding a Widget, the Chart will have a single type globally. The Chart type can be changed on the fly while keeping the widget configuration. To change the Chart type, use the selector under As in the data configuration : There is also a shortcut under Basic…
Value display and Limits configuration
Alpana Designer » Widget Properties Reference » Linear Gauge » Value display and Limits configuration
Linear Gauge colors The Linear Gauge cursor is constrained between the minimum and maximum bounds. The interval between the minimum and the maximum can be split into intervals. Those intervals are calculated linearly by splitting the interval into a scale of N equal…
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…
Binding Data
Alpana Designer » Widget Properties Reference » TreeMap » Binding Data
Introduction The following field containers are available for configuring data binding on a TreeMap : Weight : the size of the rectangles. If no “Value” is configured, this is also the color. Value : the color of the rectangles Group By : how we…
Switching Chart type
Alpana Designer » Widget Properties Reference » Proportion Charts » Switching Chart type
Proportion Chart type Chart type can be changed on the fly while keeping the widget configuration. To change the Chart type, use the selector under As in the data configuration : Or use the setting Chart Type under Basic Settings : Or use the corresponding…
Adding a connection
Alpana Designer » Using Dashboard Parameters » Managing Parameters » Editing Parameter bindings » Adding a connection
Why add a connection ? This can be useful for filtering across Data Sources : Only Widgets from the same Data Source are linked by default. If you wish to use a Master Widget from DataSource_A to filter a Listener Widget from DataSource_B, you have to manually define…
Binding Data
Alpana Designer » Widget Properties Reference » Proportion Charts » Binding Data
Introduction The following fields are available for configuring data binding on a Proportion Chart : Part : the size of the portion (pie slice, doughnut slice, etc) Split into the chart : how we group values together to create separate portions Split into many…
Configuring a Widget as Master
Alpana Designer » Using Dashboard Parameters » Widget as Master Filter » Configuring a Widget as Master
Configuration To turn a Widget into a Master Widget and allow it to filter other Widgets, check Act As Master Widget under Filter : There is also a shortcut in the top bar : Master Widget by default Some widgets do not require to perform this setting manually :…
Edit Parameter properties
Alpana Designer » Using Dashboard Parameters » Managing Parameters » Edit Parameter properties
To edit a Parameter, click on it in the middle list : The Parameter properties are editable at the bottom :
Selecting a Data Source
Alpana Designer » Configuring a Widget » Widget Data Binding » Selecting a Data Source
*Each Widget binds data from a single Data Source. In order to select a Data Source for this Widget, open the Data Source listbox on the top of the Data panel, under the From title : !Warning If the Widget had any data binding from another Data Source, it will be…
Pitfall : Calculating ratios, averages, …
Alpana Designer » Transforming Data » Expressions Troubleshooting » Pitfall : Calculating ratios, averages, …
Introduction An Expression may seem to perform the correct calculations, but it is important to double-check results during the development process, and question the calculations themselves. One crucial point to remember is that fields must be aggregated in order to…
History Values: query Format
Alpana Designer » Wonderware Historian » Creating Queries to Wonderware Historian » Configuring the Historian Query » History Values: query Format
As with the Wonderware Historian Query client, the Alpana query to Historian is by default in Narrow format. Alternately, you can select the Wide Query Format by checking the checkbox under Format : *Note : This is only available when using the History Values…
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…
User interaction
Alpana Designer » Widget Properties Reference » Grid » User interaction
Note : Grid as Master Widget As most other Widget types, the Grid can be configured as a Master Widget to filter other widgets. Additionally, the Grid allows you to make multiple selections : maintain the keyboard Ctrl key while clicking Grid rows to select multiple…
Axes
Alpana Designer » Widget Properties Reference » Cartesian Chart » Axes
Since Alpana v3.0, Charts have 2 types of axes : one X Axis : for displaying values in the X Axis field. It’s the grouping axis : grouping categories are displayed along this axis. one or more Y Axis : for displaying values in the Y Values Series fields.…
Map
Alpana Designer » Widget Properties Reference » Map
Alpana allows to display geographical data using 2 types of maps : Choropleth Maps show a color on the complete map areas Bubble Maps show a bubble centered on the map areas
Redundant Connections
Alpana Designer » Connecting to Data » Alpana data model » Redundant Connections
What are redundant Connections Since v3.1.0, Alpana implements a redundancy mechanism on Connections that allows to store multiple connection configurations inside a single Connection. Each connection configuration is defined by a set of parameters (database name,…
Conditional Formatting
Alpana Designer » Widget Properties Reference » Grid » Conditional Formatting
Grid cells can be formatted with color and text style based on data conditions. Access Conditional Formatting For this, click Template under Column Settings : In the Edit Columns Template dialog, select on the left a a column where you want to apply a formatting,…
Strip Line
Alpana Designer » Widget Properties Reference » Cartesian Chart » Axes » X Axis » Strip Line
Strip Lines allow to change the background color of the full chart between a minimum and maximum X value. This can be useful for adding context information to a chart, for example the states of an equipment. To open the Strip Line editor, click on Strip Line……
Y Axes
Alpana Designer » Widget Properties Reference » Cartesian Chart » Axes » Y Axes
All Y Axes are listed in the right side in the properties, under section Y Axes : Managing the list of Axes Adding By default, only one Y Axis exists, named after the first Y Value Series field. Click the + icon to add a new Y Axis. This opens the Edit Axis…
Binding Data
Alpana Designer » Widget Properties Reference » Cartesian Chart » Binding Data
Introduction The following fields are available for configuring data binding on a Cartesian Chart : Y Value(s) : the height of the chart line along the Y Axis X Axis : how we group values together on the X Axis to create points on the line Split into the same…
Anti-virus and Firewall set up
Alpana Server » Installation » Anti-virus and Firewall set up
Ports Reaching Alpana Server Alpana Server is composed of 2 websites that must both be reachable by the web browser on the client machines : the_Back-End Site_ and the Front-End Site The ports number are defined during installation. Allowing Alpana Server to get…
License incompatibility for Major upgrades
About Alpana » Upgrading » License incompatibility for Major upgrades
!Upgrading may require to re-activate your license in some cases. Read below for details. If this is your case, please check beforehand that you will have a the ability to activate, otherwise your Alpana Server installation will stop working while you are reaching…
Binding Data
Alpana Designer » Widget Properties Reference » Filter Widgets » ComboBox » Binding Data
The Combobox has a 2 data fields for binding : Using : the value used internally for filtering Displaying : the value displayed for selection Using : filter value This represents the category we want to use internally to filter distinct values. This field…
Binding Data
Alpana Designer » Widget Properties Reference » Filter Widgets » CheckBox » Binding Data
The Checkbox has a 2 data fields for binding : Using : the value used internally for filtering Displaying : the value displayed for selection Using : filter value This represents the category we want to use internally to filter distinct values. This field…
Binding Data
Alpana Designer » Widget Properties Reference » Filter Widgets » RadioButton » Binding Data
The Radiobutton has a 2 data fields for binding : Using : the value used internally for filtering Displaying : the value displayed for selection Using : filter value This represents the category we want to use internally to filter distinct values. This field…
Chart Types / Draw Types
Alpana Designer » Widget Properties Reference » Polar Chart » Chart Types / Draw Types
Chart Widget Types There are 2 main types of polar charts : Polar Chart Constant values are circles. Each separate X Axis value is in the middle of a radial portion. Radar Chart Constant values are straight lines. Each separate X Axis value is on the edge of a…
Creating Joins
Alpana Designer » Transforming Data » Merging Data » Creating Joins
Why Join ? When an object (a Table, a View, etc…) is already present in the Data Source and you want to add another object, you will have to specify how the two objects will be merged together to create a single data query. In order to do this, a database JOIN…
example : Multi-Data Source filtering
Alpana Designer » Using Dashboard Parameters » Managing Parameters » example : Multi-Data Source filtering
Multi-Data Source filtering You can bind Parameters to any Listener Widget independently of its Data Source and independently of the corresponding field name. *This can be useful if you want to use for example a single date filter to apply to several Listener Widgets…
Binding Data
Alpana Designer » Widget Properties Reference » Filter Widgets » TreeView » Binding Data
Introduction The Tree View is composed of Nodes representing the hierarchy. This allows the user to select context values from the top level, or drill-down into the lower levels to filter more specifically. Each Node Group corresponds to a hierarchy level. The…
Migration
Alpana Server » Maintenance and Migration » Migration
Purpose Case 1 : Development → Staging → Production You have several environments for your development cycle. When development has been tested on one environment, you want to migrate the content (dashboards, users, etc) towards the Production environment. Case 2…
Name, Header and Description
Alpana Designer » Configuring a Widget » General Widget Properties » Name, Header and Description
Widget Name Each Widget has an internal Name used only at design-time, for example in the Widgets list. This Name is not visible to the end user when the Widget is published. It allows to have a clear useful name for the developer while the end user will want to see a…
Parameter Default Value
Alpana Designer » Using Dashboard Parameters » Managing Parameters » Edit Parameter properties » Parameter Default Value
The value that the Parameter has by default is called the Default Value. This is the value that the Parameter has before any manual filtering at runtime for example. Setting Default Value from URL Parameters URL Parameters actually replace the Default Value when the…
Parameter Based Settings
Alpana Designer » Wonderware Historian » Creating Queries to Wonderware Historian » Configuring the Historian Query » Time Settings » Parameter Based Settings
What are Parameter-Based Time Settings With Parameter-Based Time Settings, the start date and end date of the Historian query are contained in a Alpana Parameter. This means that the values can be changed at runtime using User interaction (filters, URL…
Binding Data
Alpana Designer » Widget Properties Reference » Polar Chart » Binding Data
Introduction The following fields are available for configuring data binding on a Polar Chart : Y Value(s) : the distance between the data point and the center of the chart X Axis : how we group values together at different angles to create points on the…
Parameter Based Settings
Alpana Designer » Aveva Insight » Querying Insight » Configuring the query » Time Settings » Parameter Based Settings
What are Parameter-Based Time Settings With Parameter-Based Time Settings, the start date and end date of the Insight query are contained in a Alpana Parameter. This means that the values can be changed at runtime using User interaction (filters, URL…
SQL Server
Alpana Designer » Connecting to Data » Connection types » SQL Server
Versions This connector can be used to get data from local or remote Microsoft SQL Server installations with the following versions : Microsoft SQL Server 2012 and later Microsoft SQL Server Express 2012 and later Selecting Connection Type In the “Create…
Layout and appearance
Alpana Designer » Widget Properties Reference » Grid » Layout and appearance
Paging When loading a Grid Widget, all the rows of data are loaded. The Grid can also be configured with Paging : it only loads pages of 50 rows (configurable), and a page navigator allows to see the rest of the data. Check Allow Paging under Basic Settings and set…
Binding Data
Alpana Designer » Widget Properties Reference » Sankey » Binding Data
Introduction The Sankey diagram is composed of Nodes representing the items that will be interconnected. Nodes are grouped in Sets of columns. this represents items that are at the same hierarchy level and which never interconnect. Each Node from each Node Set can…
Choosing a map
Alpana Designer » Widget Properties Reference » Map » Choosing a map
Select a Map Built-in Maps Some geographical maps of the world are provided with Alpana. They are available under Map Settings, by selecting Built-in : By default, the selected map shows the world’s countries. Custom Maps You own custom GeoJSON files…
Binding a data field
Alpana Designer » Configuring a Widget » Widget Data Binding » Binding a data field
Mandatory fields, optional fields In order to complete the Widget configuration, some Widget properties must be configured : the Widget will not work without this field bound. The corresponding field selector is marked with “Select required field…” …
Accessing behind a router
Alpana Server » Troubleshooting » Accessing behind a router
Scenario In this scenario, Alpana Server is installed in the local network on a machine with IP address 192.168.0.1, and you wish to reach it from a public network through a router with external IP address 88.88.88.88. Configuring *Note : for this configuration…
Filtering aggregated values
Alpana Designer » Configuring a Widget » Widget-level Filtering » Filtering aggregated values
Introduction There are 2 ways to apply a widget filter : on the raw values : each row in the raw dataset is evaluated against the filter condition on the aggregated values : the raw dataset is first aggregated by the Widget, and only then the filter condition is…
Post-Installation
Alpana Server » Installation » Post-Installation
The steps required to activate and configure the application after installation are listed below. Startup If you didn’t start the website during the installation procedure, manually start the Alpana3App and Alpana3Client websites from Microsoft IIS Management…
Timer
Alpana Server » Schedule Management » Creating a Schedule » Trigger » Timer
Timed triggers can be defined in several ways depending on the desired time scale. You can select a time scale from the corresponding tabs : Minutes Select a frequency in minutes : You can also specify a “second”. This means that the trigger will…
v3.0.1.x
About Alpana » Release Notes » v3.0.1.x
Release notes of items completed between Alpana v2.0.8.12 and v3.0.1.1 Upgrading Upgrading from v2 to v3.0 requires manual steps. Please read these steps and incompatibilities in the full chapter about Upgrading. Main Features Some main features in a few words…
Chart Types
Alpana Designer » Widget Properties Reference » Cartesian Chart » Chart Types
Categories There are two main categories of Chart types : Horizontal X Axis : the grouping axis (X) is displayed from left to right Vertical X Axis : the grouping axis (Y) is displayed from bottom to top Types Cartesian Charts are split into several Widget…