Search

Creating a Job

Alpana Update File Dependency » Jobs » Creating a Job

To create a Job, click the Add New button : This creates an un-configured Job :

Configuring a Job

Alpana Update File Dependency » Jobs » Configuring a Job

When a new Job is created, it is not configured. You can also configure an existing job. To configure a Job, configure each property : Target Dependency Source File Update Mode

Deleting a Job

Alpana Update File Dependency » Jobs » Deleting a Job

To delete a Job, click the Remove button in front of it : !This will remove the Job permanently. If instead you want to disable it temporarily, just Disable it.

*By default, 1 Tenant is already created after installing. It is called Default. To create a Tenant, click Create new tenant : This opens the Create new tenant dialog_ : Fill-in the required information : Tenancy name / Tenant name : the name of the…

Creating a Schedule

Alpana Server » Schedule Management » Creating a Schedule

This chapter describes creating a new Schedule or editing an existing Schedule. To create a new Schedule, click the Create new scheduling button : A Schedule is composed of 4 types of properties that correspond to the 4 steps of creating the Schedule : Main : the…

Creating a New Dashboard

Alpana Designer » Dashboard Settings and Publication » Create and Export / Import Dashboards » Creating a New Dashboard

When Alpana Designer opens, an empty Dashboard is available for you to start working. When a Dashboard is already open, you can replace it by a New Dashboard by clicking on the burger menu at the top and selecting New Dashboard (or keyboard shortcut Ctrl+N) : A…

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…

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…

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…

Creating Homepages

Alpana Server » Homepages and Pinning Widgets » Creating Homepages

To create a new Homepage, you can either : add an empty Homepage from the Homepages create a new Homepage on the fly when Pinning a Widget from a Dashboard Create Homepage Create an empty Homepage Click the Create homepage button to add a new empty homepage : …

Creating / Editing Stories

Alpana Server » Stories » Creating / Editing Stories

In order to show Stories, you will have to create or modify them. Creating New Story using the Add new story button will open the creation popup. The popup contains : Name : The name that will be displayed in the Stories list. Theme : What theme will be…

Creating and Managing Connections

Alpana Designer » Connecting to Data » Creating and Managing Connections

Alpana Designer allows to create as many Connections as required. Work with Connections is all done inside the Data activity tab of Alpana Designer : To learn how to create and manage Connections, see the current chapter.

Creating and Managing Widgets

Alpana Designer » Configuring a Widget » Creating and Managing Widgets

This chapter describes how to create and manage Widgets. Since Alpana Designer v3.0, Widgets are spawned in the Dashboard activity tab, and then configured inside the Widgets activity tab :

Creating Queries to Wonderware Historian

Alpana Designer » Wonderware Historian » Creating Queries to Wonderware Historian

Once the Connection to Wonderware Historian is created, you can re-use it to make several different queries. Select the desired Historian Connection, and click on Add Historian Table : This will pop-up the configure Historian Query dialog. When the query…

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.

Export a Widget to a file

Alpana Designer » Configuring a Widget » Export / Import Widgets » Export a Widget 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 Widget from a file

Alpana Designer » Configuring a Widget » Export / Import Widgets » Import a Widget from a file

A Widget can be imported from a file in a few ways : Import in an existing Dashboard Click on the “Import” button in the Widgets list : In the “Import Widget” dialog, under “Computer”, click “…” to browse for…

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 “…”…

Create a Connection

Alpana Designer » Connecting to Data » Creating and Managing Connections » Create a Connection

To create a new Connection, click New :

Edit a Connection

Alpana Designer » Connecting to Data » Creating and Managing Connections » Edit a Connection

To open a Connection to start to Edit it, click the pen icon next to the Connection name : From the pop-up, select Edit : Then the corresponding “Edit Connection” dialog opens for edition (see below for each Connection type).

Delete a Connection

Alpana Designer » Connecting to Data » Creating and Managing Connections » Delete a Connection

To Delete an existing Connection, click the pen icon next to the Connection name : From the pop-up, select Delete : If the Connection is used by any Widget or any Data Source, the following message will appear : If you choose “Yes”, the…

Adding a constant

Alpana Designer » Transforming Data » Calculating Expressions » Adding a constant

Constant value By clicking on a ? question mark, you can input free form text : number constant string constant Note on dates *To input a constant date, it is strongly advised to use the ISO date format : YYYY-MM-DD for dates, for example…

Adding a field

Alpana Designer » Transforming Data » Calculating Expressions » Adding a field

Any field from the Data Source can be used as function argument, including other Expressions Browsing for a field Fields can be browsed from the Fields container at the bottom : This list can be filtered by table name, or by selecting Expressions to list…

Adding a function

Alpana Designer » Transforming Data » Calculating Expressions » Adding a function

Functions take part in the calculation and take other elements as argument. There are two main types of functions : Calculation functions (like Arithmetic functions *, /, -, +, Abs, … or String functions Concat, Left, …) Aggregation functions (SUM,…

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…

Configuring a Widget

Alpana Designer » Configuring a Widget

The main Widget configuration activities in Alpana Designer include : binding data : what to display graphical properties : how to display it interactions : how visualizations interact with each other *A Dashboard can contain up to 50 widgets. *To create…

Adding a Widget

Alpana Designer » Configuring a Widget » Creating and Managing Widgets » Adding a Widget

Dashboard Layout In the Dashboard activity tab, the main area shows the Dashboard layout canvas where some square tiles are displayed to guide you. Created Widgets will appear on this layout canvas and can be re-arranged later. For example, this is what a work in…

Editting a Widget

Alpana Designer » Configuring a Widget » Creating and Managing Widgets » Editting a Widget

How to Edit a Widget From the Dashboard activity tab To open an existing Widget to start to Edit it, first left click on the Widget on Dashboard activity tab, so that it appears selected : Then on the cog icon on the top right of the Widget itself : This will…

Renaming a Widget

Alpana Designer » Configuring a Widget » Creating and Managing Widgets » Renaming a Widget

When the Widget is already open to Edit, you can use the top bar on the left to change its name : No need to validate, the name is updated live. *Note : This Widget name is used internally in the widgets list for example. However, this is not the Widget header…

Deleting a Widget

Alpana Designer » Configuring a Widget » Creating and Managing Widgets » Deleting a Widget

From the Widgets activity tab To delete a Widget, select it in the Widgets activity tab top bar, then click on button “Delete” : From the Dashboard activity tab To delete a Widget when you are in the main Dashboard activity tab, first left click on…

Removing a connection

Alpana Designer » Using Dashboard Parameters » Managing Parameters » Editing Parameter bindings » Removing a connection

Why remove a connection ? By default, a Filter Widget becomes connected to all Listener Widgets using the same Data Source. Sometimes, you only want to filter some Widgets and not others. This can also be useful for sending values into a Parameter without Listener…

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…

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.

Copying/Pasting a Widget

Alpana Designer » Configuring a Widget » Creating and Managing Widgets » Copying/Pasting a Widget

Instead of creating an empty Widget and configure it from scratch, you may duplicate an existing Widget and edit the copy. Copy To copy a Widget, select it on the layout canvas and use the Ctrl+C keyboard shortcut, or click the Copy button in the top window bar : …

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…

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…” …

Configure a sorting order

Alpana Designer » Configuring a Widget » Configure a sorting order

Introduction Most Widgets will present data differently depending on how it is sorted in the query. Example : a Chart is by default sorted by ascending X Axis values. It can instead be sorted by descending Y Axis values. Sorting Priority As a rule, the fields at…

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…

Open a Dashboard file

Alpana Designer » Dashboard Settings and Publication » Create and Export / Import Dashboards » Open a Dashboard file

A Dashboard.alpd file can be opened in a few ways : File > Open To open a Dashboard.alpd file in the currently open Alpana Designer, click on the burger menu at the top and use Open… : Open / Import You can also use the top toolbar Open Dashboard button : …

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…

Adding to a Layout

Alpana OMI App » Adding to a Layout

To add the Alpana app to a layout in OMI, simply browse the Toolbox to find the AlpanaApp object : Then drag the WidgetViewerContainer and drop on the desired layout :

What is a Parameter ?

Alpana Designer » Using Dashboard Parameters » What is a Parameter ?

A Parameter is a proxy between actions and results in a Dashboard. What is this for ? This is the mechanism behind Dashboard Filters, dynamic Stored Procedure calls, URL Parameters, … How does it work ? A Parameter acts as a variable : its value can be…

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…

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…

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.

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…

Save a Dashboard as file

Alpana Designer » Dashboard Settings and Publication » Create and Export / Import Dashboards » Save a Dashboard as file

Click on the burger menu at the top and use Save (keyboard shortcut Ctrl+S) to save the Dashboard with the same file name as currently, or use Save As… (keyboard shortcut Ctrl+Shift+S) to specify a file name and location :

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 :…

Setting a Widget Default Selection

Alpana Designer » Using Dashboard Parameters » Widget as Master Filter » Setting a Widget Default Selection

The Master Widget can be configured to generate a selection by default. This means that every time the Dashboard will load, the Widget will send this default selection into the Parameter Default Value. Setting a static default selection In Alpana Designer, use the…

Login to a Wonderware Historian server

Alpana Designer » Wonderware Historian » Connecting to Wonderware Historian » Login to a Wonderware Historian server

Connection Parameters To login to a Wonderware Historian server, fill-in the following fields : If in the current session you have already connected to a Historian server, you can select it in the combobox below to auto-fill the Host Input. !Important : Because…

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…

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 :

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…

Publish a Widget to Alpana Server

Alpana Designer » Configuring a Widget » Export / Import Widgets » Publish a Widget to Alpana Server

*In order to Publish a Widget to Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server, and have the necessary permissions to create Widgets. In the top bar, click Publish : In the “Publish” dialog, fill in details and…

Import a Widget from Alpana Server

Alpana Designer » Configuring a Widget » Export / Import Widgets » Import a Widget from Alpana Server

*In order to Import a published Widget from Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server, and have the necessary permissions to access the Widget. From the Dashboard activity Click on the “Import Widget” button in the…

Publishing a Dashboard to Alpana Server

Alpana Designer » Dashboard Settings and Publication » Create and Export / Import Dashboards » Publishing a Dashboard to Alpana Server

“Publishing” means pushing the Dashboard to a Tenant on Alpana Server to make it available to other users. *In order to Publish a Dashboard to a Tenant on Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server tenant, and have…

Importing a Dashboard from Alpana Server

Alpana Designer » Dashboard Settings and Publication » Create and Export / Import Dashboards » Importing a Dashboard from Alpana Server

*In order to Publish a Dashboard to a Tenant on Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server tenant, and have the necessary permissions to access the Dashboard. Click the top toolbar Open Dashboard button : In the Import…

Selecting a Tenant or the Host

Alpana Server » Login and User Profile » Selecting a Tenant or the Host

The login screen allows to select which Tenant to connect to, or allows to connect to the Host. Selecting a Tenant To login to a Tenant, you must first enter that Tenant’s name on the login screen. Click on “Current Tenant” : Change : In the…

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…

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 : …

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…

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…

Include Parameter value in a Link to URL

Alpana Designer » Using Dashboard Parameters » Parameter usage » Include Parameter value in a Link to URL

Links To URL can use Parameter values as part of the URL : this allows to include the value of the Parameter inside the URL. For more information, see in chapter Link to URL.

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…

Running jobs

Alpana Update File Dependency » Jobs » Running jobs

Run Automatically Jobs can be run automatically when Enabled. *Jobs are not Enabled by default. To Enable a Job, check the Enabled box : To Disable a Job, uncheck the Enabled box : Run Manually To manually force the update now, click the Upload button…

Background Jobs

Alpana Server » Administration » Background Jobs

(new in version 2020 R1) Introduction Long-running tasks are managed by a Background Jobs manager : manual dashboard exports, manual data import from files, etc If the job fails, it is retried once. Results are communicated through the Notifications. This allows a…

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…

Folders

Alpana Server » Runtime Connections » Folders

Runtime Connections are organized in Folders. Folders can contain other Folders. This Chapter documents the management of Folders. Creating Folders *When you install Alpana Server or create a new Tenant, no Folders exist by default. You will need to create at least…

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…

Schedules management

Alpana Server » Schedule Management » Schedules management

Actions menu Each Schedule has a set of actions available. To list those actions, open the schedule menu next to the Schedule’s name : Some of those actions are detailed in the corresponding chapter : Edit Run now Enable / Disable Delete Edit This…

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…

Maps format : GeoJSON

Alpana Designer » Widget Properties Reference » Map » Maps format : GeoJSON

File format Alpana supports a map format called GeoJSON This is a structured text format similar to Javascript Objects and can be edited with any text editor. Geographic or X-Y The shapes represented by Alpana maps can be : geographic : coordinates are…

Permissions descriptions

Alpana Server » Administration » Users, Roles and Permissions » Permissions descriptions

User and Roles can be assigned Permissions to Alpana Server. Below is the list of existing permissions and their description. Host permissions On the Host, the possible Permissions are as follows : License management : User can manage the license (activate,…

Wonderware Historian

Alpana Designer » Wonderware Historian

The Alpana connector for Wonderware Historian allows to get data from the most common query types of Wonderware Historian in a familiar interface. Getting data is done in two steps : creating the Connection : logging into the Wonderware Historian database using the…

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…

Runtime Connections Management

Alpana Server » Runtime Connections » Runtime Connections Management

Each Runtime Connection has a set of actions available. To list those actions, open the runtime connection menu next to the Runtime Connection’s name : Some of those actions are detailed in the corresponding chapter : Move Copy Manage…

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…

Aveva Insight

Alpana Designer » Aveva Insight

(new in Alpana 2020 R1) The Alpana connector for Insight allows to get data from the “time series” part of Aveva Cloud Operations (historically Historian Online). Internally, it uses the Historian Data REST API. Getting data is done in two steps…

About Alpana server

Alpana Server » About Alpana server

Alpana Server is a web server that allows to share and manage your Alpana content (Dashboards, Widgets, Data Sources). After creating content in Alpana Designer, you simply push it to Alpana Server. This is called Publishing. Securely share your Dashboards and Widgets…

Layouts for Mobile

Alpana Designer » Dashboard Layout » Layouts for Mobile

Introduction The Mobile view of each Layout defines how it will be displayed when viewed on a mobile device. How to edit the Mobile view Selecting the Mobile view Select the desired Layout, then use the view selector to select Mobile : Default…

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…

Footer

Alpana Designer » Widget Properties Reference » Grid » Footer

Introduction Footers are configured under Footer Settings and allow to create summary rows at the bottom of the Grid. *Note : footers are disabled when Paging is enabled. Creating a Footer To create a Footer, navigate under Footer Settings and click the + icon : …

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…

Managing Permissions of Runtime Connections

Alpana Server » Runtime Connections » Managing Permissions of Runtime Connections

Manage permissions !When managing permissions, be careful not to remove access to your own user. If this happens, you can work around it by : creating a new Role with all permissions, assigning this as the only Role to a User, and letting that User remove the…

Browsing the Tenants

Alpana Server » Administration » Tenant Management » Browsing the Tenants

Tenants list The Tenants list shows all Tenants : Tenants can be searched by name and/or creation time by using the search bar at the top. The paginated list can be sorted by : Tenancy code name Tenant name Active status Creation time Actions menu Each…

Roles

Alpana Server » Administration » Users, Roles and Permissions » Roles

Roles allow to easily manage Users and their permissions : you can assign multiple Roles to a User adding/removing Permissions is just adding/removing the Role to the User Note : Additionally, Roles can be used as mailing lists for Schedules. To manage Roles, go…

Users

Alpana Server » Administration » Users, Roles and Permissions » Users

A User represents an access to Alpana Server, with its associated Roles and Permissions. Users can manage some of their own properties by editing their Profile. To manage Users, go to the Administration > Users page : *Note : Users at the Host level are different…

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…

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…

Login options

Alpana Server » Login and User Profile » Login options

The login screen allows several options : Remember Me Check this box if you want to stay logged-in even when the web browser is closed : Forgot Password If you forgot your password, you can click “Forgot password ?” and enter your e-mail address to…

Webhook Subscriptions

Alpana Server » Administration » Webhook Subscriptions

(new in version 2020 R2) Introduction You can use events in Alpana Server to trigger workflows in external tools, thanks to Webhooks. When the event happens, Alpana Server sends a query to your web API and includes information about the event. *Note : Hosting and…

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…

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…

Layouts for PDF Exports

Alpana Designer » Dashboard Layout » Layouts for PDF Exports

Introduction The Pdf export view of each Layout allows to configure the layout that will be rendered when exporting to PDF How to edit the PDF view Selecting the PDF view Select the desired Layout, then use the view selector to select Pdf Export : Using…