The topic you requested could not be found.
Related topics are listed below.

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…

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…

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…

Alpana Server

Alpana Server

Alpana Server is a website application that allows to make use of the content created with Alpana Designer : display and interact with visualizations, export, notify, socialize. Securely share your Dashboards and Widgets to any modern web browser. Dashboards can be…

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…

Alpana Designer

Alpana Designer

Alpana Designer is used to create the content of Alpana (Widgets, Dashboards, Data Sources). Drag and drop widgets into the interface and manipulate your data right away. The desktop application allows you full autonomy. Once the Dashboard ready, share with your…

About Alpana

About Alpana

Let your Data turn into Insights and put the power into your hands to take Data driven decisions ! Alpana Platform provides real-time access to your data and lets users analyze complex information through graphical representations that are easy to understand. Alpana…

Alpana Mobile

Alpana Mobile

Installation Usage

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

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…

Installing Alpana Designer

Alpana Designer » Installation » Installing Alpana Designer

Download installer See here to download the installer Run installer Double-click the installer to start installation : On the welcome screen, click Next to continue : Accept EULA Read and accept the license agreement, and click Next to continue : …

Upgrading Alpana Designer

Alpana Designer » Installation » Upgrading Alpana Designer

Upgrading Alpana Designer is straightforward : Un-install any previous version of Alpana Designer. Run the new installer

Connecting to Alpana

Alpana OMI App » Configuring » Connecting to Alpana

Login The first tab Alpana Connection allows to connect to an existing Alpana Server. Connection Parameters The following fields are required : Host The full URL to connect to the Alpana Server installation. This must include : the right protocol (HTTP /…

Uninstalling Alpana Designer

Alpana Designer » Installation » Uninstalling Alpana Designer

To uninstall Alpana Designer, use Windows Control Panel > Uninstall a Program and select Uninstall.

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…

Connecting To Alpana

Alpana Update File Dependency » Connecting To Alpana

To log in or log out to your Alpana Server, click the tab Configuration : Log in Fill in the login information and click Connect : These credentials will be remembered by the application and will be used to run the Jobs. Host URL of the Alpana Server with…

Alpana OMI App

Alpana OMI App

The Alpana OMI App allows to display any visuals published on Alpana Server Usage is very simple : Import the App Add the App to a Layout Configure the App

Login to Alpana Server

Alpana Designer » Dashboard Settings and Publication » Designer-level Settings » Login to Alpana Server

Alpana Designer can log in to Alpana Server. This is useful for importing/exporting objects to Alpana Server from the Alpana Designer interface. Logging in To login, click the profile icon on the top right of the Alpana Designer Window and click Log In : The Login…

Alpana Update File Dependency

Alpana Update File Dependency

Alpana dashboards rely on dependencies when they use an external file. Sometimes, you need to update one such dependency. For example : when you need to update the content of an Excel file on a published dashboard without having to re-publish the dashboard. You have…

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…

How to get Alpana Mobile

Alpana Mobile » Installation » How to get Alpana Mobile

You can download Alpana mobile through the usual providers: Google Play Store for Android devices App Store for Apple devices Alpana Mobile is part of the Alpana software solution and as such is free to download.

Time Settings

Alpana Designer » Wonderware Historian » Creating Queries to Wonderware Historian » Configuring the Historian Query » Time Settings

In the panel on the left, you can configure the Time settings for the query The time interval of the query can be : Static : User interaction at runtime cannot change the time interval a frozen time range a moving time window always ending…

Time Settings

Alpana Designer » Aveva Insight » Querying Insight » Configuring the query » Time Settings

In the panel on the left, you can configure the Time settings for the query The time interval of the query can be : Manual : User interaction at runtime cannot change the time interval a frozen time range : the same time interval is always retrieved a time…

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…

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…

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…

Manual Time Settings

Alpana Designer » Aveva Insight » Querying Insight » Configuring the query » Time Settings » Manual Time Settings

What are Manual Time settings When using Manual Time Settings, the start date and end date of the Insight query cannot be changed by user interaction at runtime. Note that you can still create a moving time frame, see below. This allows to make a pre-defined query to…

Static Time Settings

Alpana Designer » Wonderware Historian » Creating Queries to Wonderware Historian » Configuring the Historian Query » Time Settings » Static Time Settings

What are Static Time settings When using Static Time Settings, the start date and end date of the Historian query cannot be changed by user interaction at runtime. Note that you can still create a moving time frame (see below). This allows to make a pre-defined query…

Fetching Data

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…

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

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

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.

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…

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

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…

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…

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

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…

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…

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

Merging Data

Alpana Designer » Transforming Data » Merging Data

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

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 :

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

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…

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…

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…

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

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.

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…

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…

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 » Gantt » Data Point Information

Tooltip The tooltip displays the detailed information about the event : Event name Start Date End Date Info

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…

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.

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…

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

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.

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.

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

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…

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…

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…

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…

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…

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…

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…

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…

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…

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.

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.

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.

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…

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…

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

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…

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.

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…