Search
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…
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 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…
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 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…
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 : …
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
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
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 /…
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…
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…
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…
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…
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.
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.
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.
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…
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…” …
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 :…
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…
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.
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.
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…
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 “…”…
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…