SAP Dashboards Dynamic Dashboard - SAP Dashboards

How to create a Dashboard?

This chapter explains about how to create a Dashboard on top of the SQL Server using Embedded Spreadsheets.

Dynamic Dashboard using SQL Server

Now open the Dashboard Designer and select an untitled dashboard.
Go to the Data tab in the Spreadsheet → From Other sources → From SQL server.
To connect to the SQL server database enter the SQL Server name and credentials as mentioned in the following screenshot.
Now select the database and table you want to use in the model.
Enter the name of your data connection file and click Finish.
Let’s select the area in the embedded spreadsheet and click ok. You need to enter the credentials again if it prompts.
You can select all the tables from the database to the embedded spreadsheet.


How to Add a Selector Component?

To add the selector component – select a radio button to implement Currency conversion in the data model.
Now enter the title of the Radio button and go to the Cell selector to select cells from the spreadsheet.
Now select a Pie chart from components. After that enter the title and sub title of the chart. Then go to cell selector from the Values tab and select cells from the spreadsheets.
Go to General → Labels → Cell Selector to add labels to this component. Select cells from the spreadsheet to add labels as mentioned in the following screenshot.
To show sales add more pie charts to add Currency in Euros and Rupees. Add titles and subtitles to the chart to show the same and go to a cell selector.

How to Enable Dynamic Visibility?

To apply dynamic visibility for each chart, go to Behavior → Dynamic Visibility and Status.
Now, enter the key value of each pie chart as per the Radio button selector component.
Now save the model at the top and go to the Preview option to view the preview as mentioned in the following screenshot.
To add year wise sales use Pie chart to add more components to display sales by year, and title it as Sales by year and subtitle as USD. Go to cell selector to pass value from embedded spreadsheet.
Now go to labels and select the Years column from the embedded spreadsheet.
You can set the dynamic visibility of the chart as shown in the previous topics. Value of the key is stored in the cell under Destination.
You can add pie charts for Sales by Year (In Euros) and Sales by Year (In Rupees). Now save the Sales Project. To apply any type of formatting, you can view all the charts from the object browser, go to Appearance → Text.
You can do as mentioned in the screenshot to add more charts with the title − Sales by Category.
You can add labels by moving to the cell selector then set the dynamic visibility for the components and multiple charts.
Now save the project again and go to Preview option at the top.
As mentioned above you can create models in SAP Business Objects Dashboard Designer and use embedded spreadsheets. Use the dynamic visibility feature to get data from external data sources and to bind data with different components in the Canvas.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

SAP Dashboards Topics