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.
open_dashboard
Go to the Data tab in the Spreadsheet → From Other sources → From SQL server.
data_tab
To connect to the SQL server database enter the SQL Server name and credentials as mentioned in the following screenshot.
connect_to_database_server
Now select the database and table you want to use in the model.
select_database_and_table
Enter the name of your data connection file and click Finish.
save_dataconnection_file
Let’s select the area in the embedded spreadsheet and click ok. You need to enter the credentials again if it prompts.
select_area_of_spreadsheet
You can select all the tables from the database to the embedded spreadsheet.
select_tables_from_database

tables

How to Add a Selector Component?

To add the selector component – select a radio button to implement Currency conversion in the data model.
add_radio_button
Now enter the title of the Radio button and go to the Cell selector to select cells from the spreadsheet.
title_of_radio_button
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.
title_and_sub_title
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.
add_labels
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.
add_more_pie_chart
sales_by_region

How to Enable Dynamic Visibility?

To apply dynamic visibility for each chart, go to Behavior → Dynamic Visibility and Status.
dynamic_visibility
Now, enter the key value of each pie chart as per the Radio button selector component.
key_value_pie_chart
Now save the model at the top and go to the Preview option to view the preview as mentioned in the following screenshot.
preview_of_sales_by_region
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.
sales_by_region_and_year
Now go to labels and select the Years column from the embedded spreadsheet.
add_years_as_labels
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.
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.
view_all_charts
You can do as mentioned in the screenshot to add more charts with the title − Sales by Category.
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.
save_and_preview
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 DMCA.com Protection Status

SAP Dashboards Topics