Skip to main content

Dynamic Link

  • For instance, if a table and chart are linked dynamically, then on the click of any cell in the table, detail of that particular cell will be displayed in the chart.

Objective​

  • Dynamic Link Widgets & present them in different layers and tabs.

Use Case​

  • We will create a table about sales of different products, and link it to a chart widget dynamically.

Prerequisite​

  • Used Sales.cds for this example.

  • Download dashboard.zip file from link given dashboard.zip.

  • After downloading the zip file, Open Preview - Edit Dashboard & upload Sales.cds into Master Data --> Dataset section of AIV. To add it into AIV follow this Link.

Dynamic Link: This video contains how to use Dynamic Link in AIV.

  1. Follw this link & perofrm given steps in order to create a new dashboard.

  2. Give Dynamic Link name to the dashboard.

  3. From Right Vertical Menu Select the Table Widget icon.

    dashboard -icon 1

  4. The Edit menu box appears as you click on the Table Widget icon. And a widget gets added in content place automatically in the dashboard, As shown in the figure above:

  5. Enter the Following details in chart controls:

  • Name: Product Sales Data
  • Datasets: Sales.cds
  • Header Height: 40
  • Row Height: 30
  • Select all Dataset Columns to the Selected Columns

  1. Fill above details in the edit box, As Shown in the figure:

    dashboard -icon 1

  2. Click on Preview and Save and Exit button.

  3. From Right Vertical Menu Select the chart Widget icon.

  4. The Edit menu box appears as you click on the Chart Widget icon. And a widget gets added in content place automatically in the dashboard.

    dashboard -icon 1

  5. In Chart Widget Select Pie & Donut chart and click on Pie Chart & fill the below details as shown:

  • Datasets: Sales.cds
  • Category Axis: ProductLine
  • Value Column: OrderNumber
  • Aggregation: Sum

  1. Fill above details in the edit box, As Shown in the figure:

    dashboard -icon 1

  2. Click on Preview and Save and Exit button.

  3. Click on the side ellipsis in your table widget and Select Widget Link As shown in Figure Below:

    dashboard -icon 1

  4. Enter the Following details in Widget Link:

  • Linked Column: ProductLine
  • Layer: Layer1
  • Tab: Tab1
  • Chart Widget 2 - Column Drop-Down: ProductLine

  1. Fill above details in the edit box, As Shown in the figure below:

    dashboard -icon 1

  2. Click on Save and Exit button.

  3. Now, match your Dynamic Link with the below example, it should look like the figure below:

    dashboard -icon 1

  4. In this manner, the user can dynamically link widgets to obtain specialized data.

  5. Now as we click on the slice name Vintage Cars of the pie chart, it will show the data of Vintage Cars in the Product Sales Data Table.

    dashboard -icon 1

  6. Widgets can be linked across multiple layers also which will be discussed in the Dashboard Layers, Views & Tab section of the Documents.