Search
Related topics are listed below.
Rename a Data Source
Alpana Designer » Transforming Data » Creating and Managing Data Sources » Rename a Data Source
Why rename a Data Source? The Data Source name will appear in widget data binding. Giving good names can help the user who will make the Dashboard based on this Data Source. How Use the text box on the left of the top bar to rename the currently open Data Source…
Delete a Data Source
Alpana Designer » Transforming Data » Creating and Managing Data Sources » Delete a Data Source
How to Delete a Data Source To Delete an existing Data Source, left click then click on the trash icon in the top bar : If the Data Source is used by any Widget, the following message will appear : If you choose “Yes”, the Data Source is deleted…
Duplicate a Data Source
Alpana Designer » Transforming Data » Creating and Managing Data Sources » Duplicate a Data Source
You can Duplicate an existing Data Source to start working on a copy. In the top bar, click on the Duplicate_ icon : A copy of your Data Source is created, and you can start working on it independently.
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…
Create a Data Source
Alpana Designer » Transforming Data » Creating and Managing Data Sources » Create a Data Source
New Dashboard : first Data Source When creating a new Dashboard, a new Data Source called “DataSource_1” is created and opened in Alpana Designer. Creating a Data Source After creating a Connection, you can create a Data Source by clicking the + button…
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…
Dynamic Data Source filters conditions
Alpana Designer » Using Dashboard Parameters » Parameter usage » Dynamic Data Source filters conditions
The value of a Data Source filter condition can be a Parameter value : this allows to change the Data Source-level filter depending on the value of the Parameter. For more information, see in chapter Filtering Data.
What is a Data Source Export
Alpana Designer » Transforming Data » Export / Import Data Sources » What is a Data Source Export
A Data Source can be exported to a file with format *.alps . This DataSource.syds file contains the definition of the Data Source and all the dependent Connections, including their credentials. This is useful for splitting roles in Dashboard creation : User1 needs…
Source File
Alpana Update File Dependency » Jobs » Configuring a Job » Source File
Selecting the Source file means selecting the path where you want to fetch the new file that will replace the current dependency. To configure the Source File, click the “…” button and browse for a desired file : !Important : If you plan to…
Export a Data Source to a file
Alpana Designer » Transforming Data » Export / Import Data Sources » Export a Data Source to a file
How to Export to a file In the top bar, click the Export as Template icon : Select a file name and save locally.
Import a Data Source from a file
Alpana Designer » Transforming Data » Export / Import Data Sources » Import a Data Source from a file
A Data Source can be imported from a file in a few ways : Import in an existing Dashboard Click on the “Import” button in the Data Sources list : In the “Import Data Source” dialog, under “Computer”, click “…”…
Publish a Data Source to Alpana Server
Alpana Designer » Transforming Data » Export / Import Data Sources » Publish a Data Source to Alpana Server
*In order to Publish a Data Source to Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server, and have the necessary permissions to create Data Sources. In the top bar, click Publish : In the “Publish” dialog, fill in…
Import a Data Source from Alpana Server
Alpana Designer » Transforming Data » Export / Import Data Sources » Import a Data Source from Alpana Server
*In order to Import a published Data Source from Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server, and have the necessary permissions to access the Data Source. Click on the “Import” button in the Data Sources list : …
Removing a table from the Data Source
Alpana Designer » Transforming Data » Fetching Data » Removing a table from the Data Source
You can remove an object (Table, View, etc, …) from the Data Source by clicking the cross on the top right of the table : If the table is in a relationship with other tables and removing it breaks Join conditions, a confirmation dialog appears : All…
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…
Filtering Data
Alpana Designer » Transforming Data » Filtering Data
Data Source Filters You can apply filters at the Data Source level. All Widgets that will use this Data Source will only see the data after the filter is applied. Note : If you wish to apply different filters to each Widget separately, see the corresponding…
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…
Binding Data
Alpana Designer » Widget Properties Reference » Map » Binding Data
Introduction The following field containers are available for configuring data binding on a Map : Value : the color intensity of the shape (Choropleth Map), or the size of the bubble (Bubble Map) Shape : what Data Source field will be bound to the selected…
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…
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…
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…
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…
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…
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 » 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 » 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…
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…
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…
Transforming Data
Alpana Designer » Transforming Data
This Chapter is a reference on how to create and configure a Data Source to prepare data for your Widgets and Dashboard. To understand the Alpana Data Model, see the corresponding chapter in this documentation. Since Alpana Designer v3.0, all data preparation is made…
Data Sources
Alpana Server » Data Sources
Data Sources are basic bricks of construction for Dashboards.. They are created using Alpana Designer. “Publishing a Data Source” means pushing it to Alpana Server to make it available to other users on the platform. Publishing Data Sources can be useful…
Data condition
Alpana Server » Schedule Management » Creating a Schedule » Trigger » Data condition
*Note : to define a Data condition trigger, you must also set a Timer. This is needed to define when the condition will be checked.
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…
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…
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…
Binding Data
Alpana Designer » Widget Properties Reference » Filter Widgets » RangeSlider » Binding Data
The Range Slider has a single data field for binding : Using Using : filter value and display This represents the category we want to use internally to filter distinct values. This is also the text labels displayed to the user when viewing the RangeSlider This…
Binding Data
Alpana Designer » Widget Properties Reference » Filter Widgets » DatePicker » Binding Data
Instead of filling the calendar with all dates, you may wish to configure it to allow to select only the dates that exist in the data. For this, select Datasource Data : The DatePicker has a single data field for binding : Using Using : filter value and…
Binding Data
Alpana Designer » Widget Properties Reference » Filter Widgets » RangeNavigator » Binding Data
The following field containers are available for configuring data binding on a Range Navigator : Value : the height of the background chart Argument : the field used to filter data during selection, and also how we group values together to create points on the…
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…
fetching data from a data Table
Alpana Designer » Transforming Data » Fetching Data » fetching data from a data Table
To get data from a data Table, browse to the desired Table in the schema and drag it to the top main area :
fetching data from a data View
Alpana Designer » Transforming Data » Fetching Data » fetching data from a data View
To get data from a data View, browse to the desired View in the schema and drag it to the top main area :
Connecting to Data
Alpana Designer » Connecting to Data
Alpana Designer allows to connect to your data using Connections. The current chapter describes this process. Since Alpana Designer v3.0, all data preparation is made inside the Data activity tab.
Alpana data model
Alpana Designer » Connecting to Data » Alpana data model
Alpana Designer allows to access your data by providing a variety of Connection types. Once the appropriate credentials are validated, you will be able to navigate the data structure and retrieve the raw data. Now, in order to feed your Dashboard with data, you will…
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…
Data Point information
Alpana Designer » Widget Properties Reference » Map » Data Point information
Legend (Choropleth) Depending on the color mode selected, the Choropleth Map can display a legend. Click on Show Legend under Basic Settings : In Monochromatic color, a gradient is displayed with the minimum and maximum values and an arrow for the current value…
Data Point information
Alpana Designer » Widget Properties Reference » TreeMap » Data Point information
Legend If using Range Brush colors, the TreeMap can display a legend. Click on Show Legend under Basic Settings : The scale is displayed with the value interval for each color, and the value for the currently selected shape is highlighted with an arrow : …
Data Point information
Alpana Designer » Widget Properties Reference » Cartesian Chart » Series Settings » Data Point information
Value Labels Text labels can be used to display the value next to each data point. Edit the Series Settings, in tab Advanced, check Value Labels : With the following result for example : Null values By default, when the Y Value is NULL, the chart…
Data Point information
Alpana Designer » Widget Properties Reference » Proportion Charts » Data Point information
Value Labels Text labels can be used to display the value next to each portion. Under Basic Settings, check Show Value Labels : Position The position of labels can be configured with the Labels position selector : Outside (default) By default, labels are…
Data Point Information
Alpana Designer » Widget Properties Reference » Gantt » Data Point Information
Tooltip The tooltip displays the detailed information about the event : Event name Start Date End Date Info
Widget Data Binding
Alpana Designer » Configuring a Widget » Widget Data Binding
Introduction Each Widget displays data from a single Data Source. Some Widget graphical properties are automatically generated from the values in the data. As a result, it is preferable to start Widget configuration by binding data. *In addition, data binding in…
Troubleshooting Widget data
Alpana Designer » Configuring a Widget » Widget Data Binding » Troubleshooting Widget data
Show last query In order to troubleshoot widget data, it is possible to get the last data query that was successfully composed for this Widget. Select the desired Widget, and click the “Show last query” button on the top : A dialog pops up and lets…
Important : data limits
Alpana Designer » Wonderware Historian » Wonderware Historian query result » Important : data limits
!Important In order to limit performance issues for huge Historian queries, some limitations have been set. The Wonderware Historian Connector has the following intentional limitations : 10000 max data rows per query 30s timeout When a Historian query returns…
Data Point information
Alpana Designer » Widget Properties Reference » Sankey » Data Point information
Value Labels Text labels can be used to display the value next to each Node. Under Basic Settings, check Show Values On Nodes : Regardless of this setting, hovering a Node or a Link shows the corresponding value in the tooltip :
Configuring without data
Alpana Designer » Widget Properties Reference » Filter Widgets » DatePicker » Configuring without data
The Date Picker doesn’t need to be bound to a Data source. Instead, you may wish to configure it as a calendar filled with dates. To choose this, select Custom Data : Then you can just configure a Minimum and Maximum date to generate the calendar : …
Note on data storage
Alpana Designer » Connecting to Data » Alpana data model » Note on data storage
Alpana generally doesn’t replicate data. Alpana Dashboards, Data Sources and Connections generally don’t contain the data itself. They only contain information on how to query the data sources and prepare the data on the fly. Each Dashboard contains the…
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.
Export / Import Data Sources
Alpana Designer » Transforming Data » Export / Import Data Sources
Sharing Data Sources allows to collaborate between users with different skill sets : an IT engineer creates a Data Source, exports it, then a process engineer only has to import it and start creating visualizations. This chapter describes how to…
using the Data Preview
Alpana Designer » Transforming Data » Fetching Data » using the Data Preview
Previewing data When the Data Source definition is updated, the bottom main area shows a data preview : Loading more data rows In order to improve performance while editing the Data Source, only a few data rows are fetched. By default, only the first 100 data…
Editing Widget data binding
Alpana Designer » Configuring a Widget » Widget Data Binding » Editing Widget data binding
Accessing the data binding Starting with Alpana v3.0.0, all Widget data binding happens in the data panel on the left of the Widgets activity : Folding / Unfolding sections Different parts of the data binding interface are grouped into sections. For better…
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…” …
Re-Ordering data fields
Alpana Designer » Configuring a Widget » Widget Data Binding » Re-Ordering data fields
Some Widget configurations rely on the order of the list of bound fields. In order to change the order of a field, hover it, and see small up and down arrows appear : Click the down arrow to move the field down : As a result, the field is swapped with the…
Data refresh and Buffer
Alpana Designer » Aveva Insight » Connecting to Insight » Data refresh and Buffer
The Insight Connector is bufferized. If you need to get new data, see the corresponding chapter.
What are Data Sources
Alpana Designer » Transforming Data » Introduction » What are Data Sources
In Alpana, data preparation happens in Data Sources. Each Data Source prepares a query to the original data to be presented inside Widgets. Data is fetched through the Alpana Connections, see Course Connecting to Data. Each Widget displays data from a single Data…
Content : Data Preparation Activities
Alpana Designer » Transforming Data » Introduction » Content : Data Preparation Activities
The main data preparation activities in Alpana Designer include : Fetch : select an object (table, view, stored procedure, …) from which to get data Merge : join tables from one or more Connections Filter : remove data based on multiple criteria Calculate :…
Real Time Widgets Data
Alpana Server » API » Remote Actions » Real Time Widgets Data
Scenario You want to instantly send values inside a Widget, but you don’t want to configure this Widget with a Data Source. For example, the data does not exist in storage, but your application holds it and sends it live into the published Widget. Example : You…
Inputting and Managing data
Alpana Server » Runtime Connections » Inputting and Managing data
The Show Data button opens the Runtime Connection table in a full web page to let you view current data, and add/update/delete entries : Viewing data The page displays the content of the Runtime Connection in a paginated table. Use the controls to change page if…
Managing / Publishing Data Sources
Alpana Server » Data Sources » Managing / Publishing Data Sources
Publishing from Alpana Server Data Sources can be published from Alpana Designer. Alternately, you can publish a Data Source .alps file directly to the Server. Click the Add datasource button : This opens the Upload New dialog : Click the Select File button to…
Data Sources Version History
Alpana Server » Data Sources » Data Sources Version History
Every time you over-write an existing Data Source, the previous version in saved also. The Version History allows you to see the changes applied to a Data Source, and restore a previous state. Opening the Versions History From each Data Source action menu, select…
Data Flow : How bufferization happens ?
Alpana Designer » Connecting to Data » The data Buffer » Data Flow : How bufferization happens ?
Data flow When data is requested from a bufferized Connection, the following happens : If Buffer Refresh is not enabled : data is retrieved from the buffer. If Buffer Refresh is enabled : If the buffer is valid ⇒ data is retrieved from the buffer. If the…
Un-binding a data field
Alpana Designer » Configuring a Widget » Widget Data Binding » Un-binding a data field
To remove a field binding from a Widget, click the cross inside the field container : !All related configuration will be lost.
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…
Creating and Managing Data Sources
Alpana Designer » Transforming Data » Creating and Managing Data Sources
This chapter describes how to create and manage Data Sources. Since Alpana Designer v3.0, all data preparation is made inside the Data activity tab.
Browsing Data Sources to Edit
Alpana Designer » Transforming Data » Creating and Managing Data Sources » Browsing Data Sources to Edit
To browse Data Sources, open the Data Sources list in the top bar, and select by name : All the actions to actually edit the Data Source are explained in the following chapters of this Course.
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…
fetching data from a Table-Valued Function
Alpana Designer » Transforming Data » Fetching Data » fetching data from a Table-Valued Function
Table-Valued Functions without parameters To get data from a Table-Valued Function, browse to the desired Table-Valued Function in the schema and drag it to the top main area : If the Table-Valued Function takes no input parameters, then that’s all. If the…
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…
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…
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…
Configuring Filter Conditions
Alpana Designer » Transforming Data » Filtering Data » Configuring Filter Conditions
Filter conditions are expressed with : a field name from the Data Source. This can also be an Expression. a boolean operator a value. This can also be a Parameter. Depending on the Data Source field type, the settings are slightly different, please see for each…
Configuring Filter Conditions
Alpana Designer » Configuring a Widget » Widget-level Filtering » Configuring Filter Conditions
Filter conditions are expressed with : a field name from the Data Source. This can also be an Expression. a boolean operator a value. This can also be a Parameter. Depending on the Data Source field type, the settings are slightly different, please see for each…
Calculating Expressions
Alpana Designer » Transforming Data » Calculating Expressions
Alpana can add any number of calculated fields to a Data Source. These are called Expressions. Expressions are stored inside the Data Source and exported along with it. Expressions are evaluated when the Widget query is made, and will show accurate result depending…
Additional fields
Alpana Designer » Configuring a Widget » Widget Data Binding » Additional fields
Introduction standard data binding is used to render the widget information. But in some case, it will be useful to get more data than the standard one. The Additional fields are made for that : Adding more fields in the tooltip Binding linked data to…
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…
Hiding Column
Alpana Designer » Transforming Data » Formatting Columns » Hiding Column
Why hide columns ? The visible columns will appear in widget data binding. hiding un-necessary or confusing columns can help the user who will make the Dashboard based on this Data Source. *NOTE If you hide a column, it won’t be accessible for Widgets data…
Creating a Custom Query Table
Alpana Designer » Transforming Data » Custom Query Tables » Creating a Custom Query Table
To do so, open the Data Source where you need to add a Custom Query Table. From the Connection schema below, click on Add Custom Query. This will bring up the Custom Query Editor frame. Write the query in the correct SQL language (see the previous 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…
Configuration
Alpana Designer » Widget Properties Reference » Static Widgets » Label » Configuration
Text editor The Label Widget can be configured like any rich text editor, with font type, size, style, color, alignment, bullet lists, hyperlinks, … Label Parameters The text content can include placeholders that will be replaced by Parameter values, see…
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…
Configuring the aggregation of number fields
Alpana Designer » Configuring a Widget » Widget Data Binding » Configuring the aggregation of number fields
Introduction Most Widgets have configuration fields that require to generate a single number for each corresponding shape in the Widget. Examples : Chart : the chart line Y position of each point TreeMap : the rectangle relative size for each…
Wonderware Historian query result
Alpana Designer » Wonderware Historian » Wonderware Historian query result
After configuring the query, Alpana is able to send it to the Wonderware Historian server and get the result. This result will be modeled as a Table inside the current Data Source. For details about the schema and data of this query result, see the next…
Value-based Settings
Alpana Designer » Transforming Data » Value-based Settings
In addition to data preparation itself, Data Sources also contain information that is bound to the data. These “value-based settings” have a different value based on the value inside a Data Source field. Since v2.0, the only value-based setting is…
Widget-level Filtering
Alpana Designer » Configuring a Widget » Widget-level Filtering
Filtering data at the Widget level You can apply filters at the Widget level. The current Widget will only see the data after the filter is applied. Those Widget-level filters are applied on top of any Data Source filters (if any) and apply only to the current…
Configuring the query result
Alpana Designer » Aveva Insight » Querying Insight » Configuring the query result
The Insight Connection presents its Result in a table. Some default fields are always displayed, and some additional fields can be added, to help add more context to the data. Data Fields The following fields are returned by default : FQN : the fully qualified name…
Renaming Columns
Alpana Designer » Transforming Data » Formatting Columns » Renaming Columns
Why rename columns ? The column names will appear in widget data binding. Giving good names can help the user who will make the Dashboard based on this Data Source. How To rename a column, click on the cog icon and select “Rename Column” to enable the…
What is a Widget Export
Alpana Designer » Configuring a Widget » Export / Import Widgets » What is a Widget Export
A Widget can be exported to a file with format *.alpw This Widget.sydw file contains : the configuration of the Widget itself its position on the Dashboard canvas the dependent Data Source all the dependent Connections, including their credentials all related…
Widget Properties Reference
Alpana Designer » Widget Properties Reference
Each Widget type has specific properties and configuration options. This chapter is a reference of all Widget properties. A Widget is a visualization entity that uses data from a single Data Source and displays it in an interactive way. Widgets are assembled to…
What is a Dashboard file
Alpana Designer » Dashboard Settings and Publication » Create and Export / Import Dashboards » What is a Dashboard file
A complete Dashboard can be saved to a file with format *.alpd" This Dashboard.alpd file contains : all Dashboard-level settings (theme, layout, filters, …) all Widgets and their configuration all Data Sources all Connections, including their…
Opening the Parameters Editor
Alpana Designer » Using Dashboard Parameters » Managing Parameters » Opening the Parameters Editor
How to open From the Dashboard activity tab In the top bar, use the Edit Filters icon : From a “Use Parameter” configuration In many places where a Parameter can be used, a list icon acts as shortcut to open the Parameters Editor : This appears…