Search
Related topics are listed below.
Multi-items Viewport
Alpana Designer » Configuring a Widget » General Widget Properties » Multi-items Viewport
Introduction Some Widgets can be turned into a container for many Widgets. These Widgets are displayed in a grid showing a certain number of Widgets horizontally (Columns) and vertically (Rows). These many Widgets are generated automatically based on a data field,…
Widget Menu items
Alpana Designer » Configuring a Widget » General Widget Properties » Widget Menu items
Menu At runtime, the top of the Widget Container will include buttons to run some actions on the Widget. The Menu section allows to configure those buttons. *Note : Some of those properties are only visible when the Dashboard is published. Enable…
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 » Tree layout » Binding data
The Tree Layout Widgets displays hierarchical data based on a parent child relation. Tree Layout allows different depth levels for each category visually displayed. For example, one might display a geographic hierarchy in which some regions would not contain…
Binding data
Alpana Designer » Widget Properties Reference » Circle packing » Binding data
The Circle Packing Widgets displays hierarchical data based on a parent child relation. Circle Packing allows different depth levels for each category visually displayed. For example, one might display a geographic hierarchy in which some regions would not contain…
Style and Appearance
Alpana Designer » Widget Properties Reference » Filter Widgets » RadioButton » Style and Appearance
Multi-items Viewport The layout of the radiobuttons inside the container is configurable. Please see the corresponding chapter to configure the view of theWidget container.
Style and Appearance
Alpana Designer » Widget Properties Reference » Filter Widgets » CheckBox » Style and Appearance
Multi-items Viewport The layout of the checkboxes inside the container is configurable. Please see the corresponding chapter to configure the view of the Widget container.
Configuring behavior
Alpana Designer » Widget Properties Reference » Filter Widgets » ComboBox » Configuring behavior
Multiple Selection Configuring Multiple Selection The Combobox can be configured to allow multiple selection. Check the Enable Multi-Select box under Basic Settings : Send Value on Select All By default, the Combo Box widget will send the Keyword…
Binding Data
Alpana Designer » Widget Properties Reference » Sunburst » Binding Data
The Sunburst Widgets displays hierarchical data based on a parent child relation. The size of each arc depends on the aggregated sum of values of its siblings. Sunburst allows different depth levels for each category visually displayed. For example, one might display…
Binding data
Alpana Designer » Widget Properties Reference » Arc diagram » Binding data
The Arc Diagram Widgets displays hierarchical data based on a parent child relation. Arc Diagram points out connections between nodes and renders visual on a horizontal line with each connection represented as an arc. For example, we can visualize the most recurring…
v3.2.3
About Alpana » Release Notes » v3.2.3
Release notes of items completed between Alpana v3.2.2.10 and v3.2.3.3 Alpana Update File Dependency has been upgraded from v1.0.2.2 to v1.0.3.1 Alpana Real Time Data has been upgraded from v1.0.2.1 to v1.0.3.1 Main Features Alpana v3.2.3 is mostly a bugfix release…
Multitenancy
Alpana Server » About Alpana server » Multitenancy
Alpana Server is a multi-Tenant application. This means that a single instance of Alpana Server can manage any number of customer-facing isolated instances. What Is Multi-Tenancy? The term “software multitenancy” refers to a software architecture in…
Bufferized Connection types : What gets bufferized ?
Alpana Designer » Connecting to Data » The data Buffer » Bufferized Connection types : What gets bufferized ?
All Connection types that are not databases are bufferized : RESTful API (web) Insight Alpana Runtime Connections file-based Connections : Excel, CSV Multi-Source case Multi-Source is a special case : in a Multi-Source context, even database-based Connections…
Binding Data
Alpana Designer » Widget Properties Reference » Banner » Binding Data
The Banner has 4 data fields available for binding : Tag : how we split series of different items in the same stream Value : main value displayed Target : target displayed, compared to the Actual Value Split into many widgets : how we split series of different…
The data Buffer
Alpana Designer » Connecting to Data » The data Buffer
Introduction : What is the Buffer ? The primary source for data in Alpana is a database (SQL Server, Oracle). When a Dashboard requires data from a Data Source that is based only on database Connections, the query is composed by Alpana and executed directly on the…
Binding Data
Alpana Designer » Widget Properties Reference » Energy Rating » Binding Data
Introduction The Energy Rating Widget represents the energy rating of equipments. The rating is calculated from an analog/real value of energy consumption : primary energy consumed, in kWh, or in a normalized unit such as kWh / m² mass of CO₂ equivalent, in…
Data refresh and Buffer
Alpana Designer » Wonderware Historian » Connecting to Wonderware Historian » Data refresh and Buffer
Since Alpana v3.0, the Wonderware Historian Connector is not bufferized. Of course, like other data Connectors, it may become bufferized when used in Multi-Connection Data Sources. See the corresponding chapter.
Buffer Refresh settings
Alpana Designer » Connecting to Data » The data Buffer » Buffer Refresh settings
What is Buffer Refresh Settings This setting represents : How long do you want to query the old data in the buffer instead of getting new data from the source ? For example You connect to an Excel file. The data is first copied in the buffer. If you don’t set…
Data Binding
Alpana Designer » Widget Properties Reference » Linear Gauge » Data Binding
The Linear Gauge has 4 data fields available for binding : Main Value : main value displayed on the Linear Gauge, as a cursor position Min Value : minimum value for the Linear Gauge Max Value : maximum value for the Linear Gauge Split into many widgets : how we…
Targets
Alpana Server » Schedule Management » Creating a Schedule » Targets
The Targets are the intended recipients of the Schedule : the Action will be performed for them only. You can see this as a mailing list for example. Adding/removing Targets To add an item (Role, User) from the list of Available items, select it and click the >…
Removing an existing item
Alpana Designer » Transforming Data » Calculating Expressions » Removing an existing item
To remove an item and all the dependent items, click the item and click on the “Reset” button : The item itself and all items underneath will be removed.
v3.2.2
About Alpana » Release Notes » v3.2.2
Release notes of items completed between Alpana v3.2.1.5 and v3.2.2.10 Alpana Update File Dependency has been upgraded from v1.0.2.1 to v1.0.2.2 Alpana Real Time Data has been upgraded from v1.0.2.0 to v1.0.2.1 Alpana OMI App v1.1 is now available upon request. Main…
Configuring behaviour
Alpana Designer » Widget Properties Reference » Filter Widgets » CheckBox » Configuring behaviour
Show/Hide “All” item By default, a item called “(All)” is added at the top, to allow to select/unselect all items at once. You may show or hide this item from the Show (All) Items check box under Basic Settings : Send Value on Select…
Configuring behaviour
Alpana Designer » Widget Properties Reference » Filter Widgets » RadioButton » Configuring behaviour
Show/Hide “All” item By default, a item called “(All)” is added at the top, to allow to select/unselect all items at once. You may show or hide this item from the Show (All) Items check box under Basic Settings :
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…
X Axis
Alpana Designer » Widget Properties Reference » Polar Chart » X Axis
By default, the angular position of X Axis items is calculated automatically to divide the plane evenly : 360° / (number of items) When the X Axis field is a Number, the minimum and maximum angles are calculated from the data. Instead, if a Number type field is bound…
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…
2023 R1
About Alpana » Release Notes » 2023 R1
Release notes of items completed between 2022 R2 and 2023 R1 Alpana Server and Alpana Designer have been upgraded from 3.5.1.16 to 3.6.0.11 Alpana Update File Dependency has been upgraded from 1.2.0.1 to 1.2.1.3 Introduction Version 2023R1 is a major release and…
Managing Series Color
Alpana Designer » Widget Properties Reference » Cartesian Chart » Managing Series Color
Indexed Colors By default, Series are assigned a color based on their index in the ordered list in which they appear (usually alphabetical order). Item1 is assigned Color1, Item2 is assigned Color2, etc… The palette has 15 colors. When there are more series…
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…
Sankey
Alpana Designer » Widget Properties Reference » Sankey
The Sankey widget allows to see and quantify topological connections between items. For example, you can analyze your energy flows, identify losses, find water leaks, etc…
Strip Line
Alpana Designer » Widget Properties Reference » Cartesian Chart » Axes » Y Axes » Strip Line
Strip Lines allow to change the background color of the full chart between a minimum and maximum Y value. This can be useful for adding context information to a chart, for example the limit values of a measurement. To open the Strip Line editor, click on Strip…
Binding Data
Alpana Designer » Widget Properties Reference » Card » Binding Data
Data fields The Card has 3 data fields available for binding : Value : main value displayed on the Card Target : target displayed in the Card, compared to the Value Sparkline : series field (usually a date) to use as X Axis values on the sparkline Group By :…
Binding Data
Alpana Designer » Widget Properties Reference » Gantt » Binding Data
Introduction The Gantt Widget represents the time span of a series of events (work orders, shifts, machine states, …) happening in parallel on a series of “Tags” (equipments, production lines, …). Time is represented on a X axis, and the…
Managing Series Color
Alpana Designer » Widget Properties Reference » Proportion Charts » Managing Series Color
Indexed Colors (default) By default, Proportion Chart portions are assigned a color based on their index in the ordered list in which they appear (usually alphabetical order) : Item1 in the values of the series (see Legend order) is assigned Color1, Item2 is assigned…
Limiting dataset size
Alpana Designer » Configuring a Widget » Widget-level Filtering » Limiting dataset size
How to limit Check “Limit result to” and select the number of rows you want to keep in the dataset : Why limit ? Checking this option with “Limit result to 10 rows” for example will apply a “TOP 10” to the query. When widgets…
Updating a Custom Query Table
Alpana Designer » Transforming Data » Custom Query Tables » Updating a Custom Query Table
To do so, click on the cog icon to view and update the Custom Query. *Important Be careful that any changes in the schema (column names and types) could impact the items that use this Custom Query Table, such as Widgets or Expressions. Changing the schema of the…
Limiting dataset size
Alpana Designer » Transforming Data » Filtering Data » Limiting dataset size
How to limit Check “Limit result to” and select the number of rows you want to keep in the dataset : Why limit ? Checking this option with “Limit result to 10 rows” for example will apply a “TOP 10” to the query. When widgets…
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…
Stories
Alpana Server » Stories
Alpana Stories are a collection of item displayed in a slideshow. You can include in a story multiple Dashboards and images to create a page where all items will cycle automatically. It can be used for entrance site screen to show revelant informations to visitors…
Binding Data
Alpana Designer » Widget Properties Reference » Circular Gauge » Binding Data
The Circular Gauge has 5 data fields available for binding : Actual Value : value displayed as a filling of the Circular Gauge Start Value : dynamic minimum value End Value : dynamic maximum value Tolerance Threshold Minimum Value : dynamic threshold minimum value…
Copying and Pasting an existing item
Alpana Designer » Transforming Data » Calculating Expressions » Copying and Pasting an existing item
Copy Click to select any item (function, field, value), then click on the Copy icon : Paste Click on the target item, then click on the Paste icon : You can paste onto any item : to replace a ? question mark as a function argument replace a single…
Style and Appearance
Alpana Designer » Widget Properties Reference » Banner » Style and Appearance
Colors The colors of items can be configured : Value This is the color of the numerical value (the value from the Value field). *If a Target field is configured, then this color is ignored. Instead the Good/Bad color is displayed (see below). Tag This is…
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……
Binding Data
Alpana Designer » Widget Properties Reference » Sparkline » Binding Data
Data fields The Sparkline has 7 fields available for binding : Tag : the name of the variable Value : the value of the variable Serie : the field used as X Axis of the chart Low : the low threshold High : the high threshold Target : the target value Split into…
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…
Managing Colors
Alpana Designer » Widget Properties Reference » TreeMap » Managing Colors
Monochromatic By default, the TreeMap shows value intensity as a gradient of a single color. This Monochromatic Gradient can be set to a different color by using the dedicated combobox under Range Color Settings : Range Brush The TreeMap can be configured to…
2020 R2 Patch 1
About Alpana » Release Notes » 2020 R2 Patch 1
Release notes of items completed between Alpana 2020 R2 and 2020 R2 Patch 1 Alpana Server and Alpana Designer have been upgraded from 3.3.1.17 to 3.3.1.20 Alpana Update File Dependency has been upgraded from 1.1.0.2 to 1.1.1.0 Introduction Version 2020 R2 Patch 1 is…
Tooltip configuration
Alpana Designer » Configuring a Widget » Tooltip configuration
Most widgets have tooltip, it helps getting more information from the data without overloading the view. You can bind data to your widget and define what datas will be visible in the tooltip. Some tooltip information are specific to some widgets (i.e : KPI in Gauge or…
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…
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…
Titles Configuration
Alpana Designer » Widget Properties Reference » Gantt » Titles Configuration
Optionally a title can be displayed on top of the Gantt. This is useful especially when configuring a Split into many widgets field : then configuring the Title as {{:Row}} will give you the field value for each sub-widget. Title This is the title itself. If no…
Legend
Alpana Designer » Widget Properties Reference » Cartesian Chart » Legend
Series Legend The Legend shows the meaning of each series : Hide/Show Legend The chart Legend can be be hidden or displayed using Show Legend under Basic Settings : Legend position The chart Legend can be positioned on any side of the widget : Custom…
Legend
Alpana Designer » Widget Properties Reference » Polar Chart » Legend
Series Legend The Legend shows the meaning of each series : Hide/Show Legend The chart Legend can be be hidden or displayed using Show Legend under Basic Settings : Legend position The chart Legend can be positioned on any side of the widget : Customize…
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…
Configuring Widgets on the Layout
Alpana Designer » Dashboard Layout » Configuring Widgets on the Layout
Layout canvas Widgets are laid out on a bi-dimensional (2D) canvas. In Alpana Designer, the layout is configurable in the center part of the Dashboard activity tab : This is where you will configure the Widget’s position and size. Navigating the…
v3.1.2
About Alpana » Release Notes » v3.1.2
Release notes of items completed between Alpana v3.1.0.7 and v3.1.2.1 Alpana Update File Dependency has been upgraded from v1.0.0.3 to v1.0.0.4 Main Features Date Time Picker The Date Picker widget now supports selecting time intervals. Custom date formats Custom…
v3.0.2.x
About Alpana » Release Notes » v3.0.2.x
Release notes of items completed between Alpana v3.0.1.1 and v3.0.2.2 Upgrading Alpana Server install upgrade from v3 To upgrade Alpana Server from v3.0.1.1, first un-install the previous version from Windows Control Panel, as documented here. License upgrade !An…
Public / Private Dashboards and Dashboard-level Permissions
Alpana Server » Dashboards » Public / Private Dashboards and Dashboard-level Permissions
Dashboard access can be managed through the Permissions system, or by making it public. Both items are listed in the actions menu of the Dashboard. Make public / Make private What is a Public dashboard By default, content on Alpana Server is secured behind the…
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…
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…
2022 R2
About Alpana » Release Notes » 2022 R2
Release notes of items completed between 2022 R1 and 2022 R2 Alpana Server and Alpana Designer have been upgraded from 3.5.0.18 to 3.5.1.16 Alpana Update File Dependency has been upgraded from 1.2.0.1 to 1.2.1.3 Introduction Version 2022R2 is a minor release and…
Legend
Alpana Designer » Widget Properties Reference » Proportion Charts » Legend
Portion Legend The Legend shows the meaning of each portion : Hide/Show Legend The chart Legend can be be hidden or displayed using the corresponding checkbox : Legend position The chart Legend can be positioned on any side of the widget : Custom Legend…
Manual Exports
Alpana Server » Dashboards » Viewing Dashboards » Manual Exports
From the Dashboard viewer, Dashboards can be manually exported to several formats. After completion of the export, a Notification informs you that your file is ready. Click on the notification, and your web browser proposes a “download” or “save…
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…
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…
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…
Comments
Alpana Server » Dashboards » Viewing Dashboards » Comments
When viewing Dashboards, you can leave comments and have discussions with other users. You can create comment threads and choose to be notified. This is a good way to have your analysis and discussion in the same place. Opening the Comments To open the Comments…
2021 R2
About Alpana » Release Notes » 2021 R2
Release notes of items completed between 2021 R1 and 2021 R2 Alpana Server and Alpana Designer have been upgraded from 3.4.0.3 to 3.4.1.19 Alpana Update File Dependency has been upgraded from 1.2.0.1 to 1.2.1.2 Introduction Version 2021R2 is a minor release and…
2022 R1
About Alpana » Release Notes » 2022 R1
Release notes of items completed between 2021 R2 and 2022 R1 Alpana Server and Alpana Designer have been upgraded from 3.4.1.19 to 3.5.0.18 Alpana Update File Dependency has been upgraded from 1.2.0.1 to 1.2.1.3 Introduction Version 2022R1 is a major release and…
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…
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…
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…
X Axis
Alpana Designer » Widget Properties Reference » Cartesian Chart » Axes » X Axis
X Axis configuration is located in the right side in the properties, under section X Axis : Title X Axis has a default title generated from the name of the currently displayed data field. If you wish to customize this title, check the box Custom Title, and write…
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…
Third party licenses
About Alpana » Third party licenses
Alpana is running with third part add-ons that are under open source licenses. This is a list of all license text required to appear in Alpana : This software is provided ‘as-is’, without any express or implied warranty. In no event will the authors be…