Index

**Report Bursting ** Report Bursting will be used in a condition when multiple reports are required to be generated and shared with relevant users at a specific predefined time period.

**Server Migration if not at same location ** This contains set of instructions to migrate whole AIV from one server machine to some others server machine with all data.

**Layer Sorting ** By using this feature user can add N number of layers & alter the sequence of Layers.

**Decimal Point in Dynamic Label ** user can control the decimal numbers by changing expression in ‘Text’ option of Dynamic label section.

**Decimal Value in Chart Tooltip ** User can add Decimal places in series tooltip of chart widget.

**Filter Validation ** User can validate the filter data as per the written script & show the output in the widget.

**Optional Category Grouping ** User will be able to sort & group the given data at the category axis.

**Hide Grid in Report Export ** User can disable grids in a report scheduled in XLSX, XLS format.

**Group Dataset - Stash Dataset ** be used in a scenario where data coming from a dataset is very large and it takes a huge amount of time to refresh the data. This happens when your dataset has a parameter and we are passing values in this parameter from the dashboard using filters. What happens here is when a filter is applied from dashboard, this filter value is passed inside this dataset parameter and query written in a dataset is called on database.

**Pivot Event ** User can redirect from one Tab to another Tab in same Dashboard using Script in Pivot widget.

**Pivot Drill Database ** describes how users can disable the Pivot drill function in the pivot widget. By default, drill, data checkbox is enabled, but in case if users do not want it, they can disable it from widget edit settings.

**Pivot Analysis Download ** allow user to download the Pivot analysis in the excel format.

**Notebook Widget ** is a dashboard widget, which provides flexibility to view notebook model file inside the dashboard.

**Dummy Filter using Custom Visualization ** is used when user require to make user-defined filters with required looks and design, user need to use custom visualization to make designs and link them with widgets using dummy filters.

**Layer Change Event ** uses to apply functionality of change layers on user click. User can shift from one layer to another layer using event with the use of custom visualization.

**Backup Restore MySQL database ** used to perform backup and restore operations of AIV Database with MySQL database in Windows platform.

**Backup Restore PostgreMySQL database ** sed to perform backup and restore operations of AIV Database with PostgreSQL database in Windows platform.

**AIV SSO ** allows single sign on option so that AIV can be integrated with third party application as an integrated solution.

**Optional Grouping Color ** used to add multiple Series when required. Optional Grouping color will be enabled when user is using Optional Y series Grouping Property.

**Match Global Color ** enable to take color from the colors List of Dashboard Global Theme in Dashboard setting.

**Spreadsheet Widget ** user can Analyse and Play with the data of dataset and also can import external excel files in to this widget.

**Notification - Request Approval ** used when a user schedules the report using the once or recurring option with Approval Required.

**Notification - Message ** used to send a message internally to the person who is using this application.

**Annotation Widget Hover ** used to modify annotations from the widget hover icon. From the annotation icon user can annotate using lines, add a custom text, add image, and download these changes in various output formats.

**Custom Date Range Filter **

**Skip Widget from Event Filtering ** used When Event has used to filter other widgets data on click, Filter event will filter clicked widget also.

**External Dataset **

**Custom Column Table Widget ** used to add an image in a column of table widgets using a custom column.

**Custom Column Micro Chart ** used to add a micro chart image in table widget using a custom column.

**Clear Job ** provides the facility to clean the files like output files, notifications, alerts, sessions, audit messages. The user can insert the days as numbers in the controls to clean up the files before the contained days it made.

**Backup/restore PostgreSQL database **

AIV Patch Update used to patch update at client side.

What is Embed Link used for embedding external applications which is generally multimedia content like audio or video into an HTML document. It is used as a container for embedding plug-ins such as flash animations.

Calling Detail Dashboard with Event Tab used to open the detailed dashboard on clicks of grouped values.

Calling Detail Dashboard from Table custom column with Filter used to call the detail dashboard from the table widget custom column.

Adhoc Embed Link shows how to use adhoc embed link to achieve various functionalities.

Embed Link with-without Bypass shows how to generate or use external embed with or without bypass

Filter Condition used to filter the data in a widget that fulfills the condition which user set in the filter setting.

Hide Grid option in Filter Setting shows Hide Border function for the filter.

**Section Grid & Blank Widget ** used to run the report directly while previewing the dashboard.

**X-Axis Alignment ** used to make changes in the alignment of the category labels.

**DML with Multiple join condition ** used for manipulation with the records in our table, so with them, user can select/read data with some criteria or not, we can insert new data or edit existing ones and of course user can delete records if they don’t need them anymore.

**Optional Y Series Grouping ** used to visualize chart data by some group values for example year, month or something else.

**Prediction in Dashboard ** contains the information steps to get prediction data by applying set of input data using dataset.

**Select all on Percent change ** is useful in a case when it is required that all the child options should be selected when we make change in parent filter options

**Alert section ** shows certain usage of alerts.

Embedlink with Pivot using filter

**Embedlink with Pivot using Global Parameter ** used to create embed link and how to connect embed link with one dashboard to another dashboard and filter detail dashboard with global filter parameters.

**AIV License request & update License ** shows how to send request for AIV license & how to update it.

**Datasource using MongoDB ** shows how to create Datasource using MongoDB & make a dataset out of it.

**Datsource using BigQuery ** shows how to create Datasource using Google BigQuery & make dataset using that data source

**Category Navigate Icon ** contains information on a feature Category Navigate Icon. In AIV, the user can redirect from chart Property.

**Chart Category Grouping & Sorting ** user can create a grouping in two types String and Date Time, and create a sorting by column using Ascending or Descending orders.

**Embed Link within extra label Property with filter ** shows how to Use Embed Link within extra label Property with filter.

AIV Server Migration Windows shows how to migrate whole AIV from one server machine to some others server machine with all data.

**Click event expression using console.log ** shows how to get on click value using events for different widgets

**Embedlink within extra label property ** shows how to use dashboard embed link to travel from one dashboard to another

**Custom Column Table Widget Icon ** shows how to add icons in column of table widgets using custom column.

**Datasource Mapping ** allows multiple users to connect with different data sources and working on the same AIV application.

**Custom column table widget hyperlink ** allows user to add hyper link in column of table widgets using custom column.