Tutorial part 2: Create App with Navigation

In this second part of the Tutorial on Creating and Registering Your Own Dashboard Apps, you extend the simple app from the first part by adding the option of a drill down, that is, you can context-dependently call another app from your app. The app displays the monthly telephone costs of the branches of a fictitious company in a bar chart: the drill down allows you to click the bar for a branch to display the daily telephone costs for that branch.

The primary aim of this part of the tutorial is to introduce the possibility of a drill down.

Prerequisites

Since the different parts of the tutorial build on each other, you should have completed the previous part of the tutorial (Tutorial Part 1: Creating and Registering a Simple App). However, if you only want to work through this part of the tutorial, you can replace the files required from the first part with files delivered by SAP.

Required File	Steps to create the required file
Xcelsius file of the app from part 1(`ztut1_costs_month.xlf`)	Start the registration tool, select the app Tutorial Samples SAP_TUTORIAL_1_APP , and choose Details. You can now download the required file by choosing the Download Xcelsius File for Editing in the Xcelsius File (XLF) row, and saving the file locally under the name at the left.
BW query from part 1 (`ZTUT1_COSTS_MONTH`)	Start the BEx Query Designer, and enter the BW system or the BW client that is assigned to your SAP Solution Manager system. Open the BW query with the technical name `TUT1_COSTS_MONTH`, and save it under the name `ZTUT1_COSTS_MONTH`.

Required File

Steps to create the required file

Xcelsius file of the app from part 1(ztut1_costs_month.xlf)

Start the registration tool, select the app Start of the navigation path Tutorial Samples Next navigation step SAP_TUTORIAL_1_APP End of the navigation path , and choose Details.

You can now download the required file by choosing the Download Xcelsius File for Editing in the Xcelsius File (XLF) row, and saving the file locally under the name at the left.

BW query from part 1 (ZTUT1_COSTS_MONTH)

Start the BEx Query Designer, and enter the BW system or the BW client that is assigned to your SAP Solution Manager system.

Open the BW query with the technical name TUT1_COSTS_MONTH, and save it under the name ZTUT1_COSTS_MONTH.

Process

Creating the User Interface of the App with Xcelsius

You use the app from the first part of the tutorial, and extend it with a drill down that is activated when the data for a branch is clicked. The selected branch is passed to the Dashboard Framework using an Xcelsius connection. You do not need to have set up the data provision yet. You can concentrate on the design of the user interface, and use example data in the Microsoft Excel worksheet that is integrated into Xcelsius (see Tutorial Part 2: Creating an App with Xcelsius)..

Creating the User Interface of the Detail App with Xcelsius

You use Xcelsius to create the user interface of the detail app; that is, the app that is called if the user clicks a branch (see Tutorial Part 2: Creating the Detail App with Xcelsius).

Creating a BW Query as the Data Source of the App

You create a BW query as data source for the detail app. You need a separate BW query for the detail app, since the detail app is to display only the telephone costs for a single branch, on a daily basis (see Tutorial Part 2: Creating the BW Query).

Registering the App and Detail App with the Dashboard Framework

Finally, you need to register both of the newly-created apps with the Dashboard Framework, so that you can add the app to all appropriate dashboards (see Tutorial Part 2: Registering the App and Detail App).

Displaying the App in Your Own Dashboard

Once you have created and registered your app, display your app in your personal dashboard. To call your personalized dashboard, and to display the app that you created there, proceed as follows:

You call your personalized dashboard using a Web Dynpro application called my_dashboard. If you have not yet added this Web Dynpro application to your favorites in your SAP Easy Access Menu, you can create this entry as follows:
1. In the SAP Easy Access menu, call Favorites Add Other Objects .
2. From the list in the Restrictions screen, choose Web Dynpro Applications.
3. On the Web Dynpro Application screen, in the Web Dynpro Application field, enter the name generic_dashboard_viewer.
4. Enter a description, for example Personal Dashboard.
5. Insert a row in the table Parameter, in the Name column, enter ALIAS, and in the Value column, enter PERSONAL_DASHBOARD.
Start your personal dashboard by double-clicking the relevant entry in you favorites.
To add a new app to the dashboard, choose the Configure button, and then Add New App.
A list of the available apps appears, grouped by category. The app that you created in this tutorial is not assigned to a category. Therefore expand the Not Assigned category.
Your app Z_TUTORIAL_2_APP is displayed in the list. Select your app and choose OK.
To save the dashboard with the app that you have just added, choose the Save Dashboard button.

Result

You have completed this part of the tutorial and displayed the relevant app in your personal dashboard. If you have not achieved the desired result, compare your results with the apps delivered by SAP.

Created File	Corresponding File Delivered by SAP
Xcelsius file of the app (`ztut2_costs_month.xlf`)	`SAP_TUTORIAL_2_APP.xlf` To download this file, start the registration tool, select the app Tutorial Samples SAP_TUTORIAL_2_APP , and choose the Details button. You can now download the required file by choosing the Download Xcelsius File for Editing in the Xcelsius File (XLF) row.
Xcelsius file of the detail app (`ztut2_costs_day.xlf`)	`SAP_TUTORIAL_2_DETAIL.xlf` To download this file, start the registration tool, select the app Tutorial Samples SAP_TUTORIAL_2_DETAIL , and choose the Details button. You can now download the required file by choosing the Download Xcelsius File for Editing in the Xcelsius File (XLF) row.
BW query to supply the data for the app from the first part of the tutorial (`ZTUT1_COSTS_MONTH`)	`TUT1_COSTS_MONTH` To display the query, start the BEx Query Designer, and enter the BW system or the BW client that is assigned to your SAP Solution Manager system. Open the file specified above.
BW query to supply the data for the detail app (`ZTUT2_COSTS_DAY`)	`TUT2_COSTS_DAY` To display the query, start the BEx Query Designer, and enter the BW system or the BW client that is assigned to your SAP Solution Manager system. Open the file specified above.

Created File

Corresponding File Delivered by SAP

Xcelsius file of the app

(ztut2_costs_month.xlf)

SAP_TUTORIAL_2_APP.xlf

To download this file, start the registration tool, select the app Start of the navigation path Tutorial Samples Next navigation step SAP_TUTORIAL_2_APP End of the navigation path , and choose the Details button. You can now download the required file by choosing the Download Xcelsius File for Editing in the Xcelsius File (XLF) row.

Xcelsius file of the detail app

(ztut2_costs_day.xlf)

SAP_TUTORIAL_2_DETAIL.xlf

To download this file, start the registration tool, select the app Start of the navigation path Tutorial Samples Next navigation step SAP_TUTORIAL_2_DETAIL End of the navigation path , and choose the Details button. You can now download the required file by choosing the Download Xcelsius File for Editing in the Xcelsius File (XLF) row.

BW query to supply the data for the app from the first part of the tutorial

(ZTUT1_COSTS_MONTH)

TUT1_COSTS_MONTH

To display the query, start the BEx Query Designer, and enter the BW system or the BW client that is assigned to your SAP Solution Manager system. Open the file specified above.

BW query to supply the data for the detail app

(ZTUT2_COSTS_DAY)

TUT2_COSTS_DAY

To display the query, start the BEx Query Designer, and enter the BW system or the BW client that is assigned to your SAP Solution Manager system. Open the file specified above.