In this exercise, we will design a SAC Story by copying and enhancing a pre-defined story from the Manage KPIs and Reports application. The charts in this story will be configured on the custom analytical query created in Exercise 1. Once the story is activated, we will create an application to launch the story directly from the Fiori Launchpad.
Go back to the Analytics Page in Fiori Launchpad.
Under KPI Design group, launch the Manage KPIs and Reports application.
Go to the ‘Stories’ tab. You will find the list of embedded analytical stories under the ‘Embedded Stories’ section.
Search for ‘Purchasing Spend Dashboard’.
The search result will display the predefined story. Click on the row to navigate inside the Purchasing Spend Dashboard story details page.
Switch to Configuration section to view the predefined story configuration.
Click on Copy button on the top of the screen.
Enter the title as ‘DT169-XXX Purchasing Spend Dashboard’ and click on Copy. (XXX should be replaced with your group number for eg for place number 25 it is 025)
You will be navigated to the display page of your newly copied story.
Click on the Edit button on top.
To add a new page, Click on the “+” button beside Off Contract Details and select Responsive.
Rename the page by clicking on the down arrow beside ‘Page 1’.
Enter ‘Open Purchase Orders’ as the new name for the page.
Under Data section, add New Data source.
Search for the custom analytical query created in Exercise 1, i.e, YY1_PURCHASING_DT169_XXX. (XXX should be replaced with your group number for eg for place number 25 it is 025)
A prompt will be displayed to set the variables for the data source. Since the filter values were already prefilled during the query designing, no change is required here.
Click on Set.
First, we will add a chart to see the Number of Open PO Items per Supplier. Note that Number of Open PO Items is the field which was added in the custom query as a new calculated measure.
Under the Insert section, click on the Chart icon to add a new chart.
In the Builder section, scroll down to Measures section and click on Add Measure.
Select ‘Number of Open PO items from…’ .
Under Dimensions sections, click on Add Dimensions and select ‘Supplier’ and ‘Name of Supplier’.
The chart will get updated with the appropriate title on the widget.
Similarly, add another chart widget that will display the Number of open PO Items per Purchasing Organization Name.
Along with selecting the required measures and dimensions, you can also change the Chart orientation from ‘Horizontal’ to ‘Vertical’.
The chart data will get updated in real time inside the widgets.
Now we will add another calculated measure and add a chart for it.
Click on the empty space in the page section on the right and add another chart widget.
In the Builder section, under Measures click on Add Measure, then click on Create Calculation.
Enter the Name as ‘PO Net Amount in Thousands’.
Inside the Edit formula section, type PO and select PO Net Amount from the suggestions.
Add ‘ / 1000 ‘ after the PO Net amount to scale the amount in thousands.
Click on OK.
In the Dimensions, add ‘Calendar Month’ and ‘Supplier’ to the same chart widget.
Scroll up to the Chart structure section in the Builder, click on the dropdown under Trend chart and select Line.
Change the titles of the page sections in the area marked as 'Click to enter title'.
You can explore the other designing options in the Builder and add more charts to your page.
Adding Numerical points in the story
Add another chart with Measure ‘Number of Open PO Items from..’.
Change the Chart structure to Indicator -> Numeric Point.
Go to Color section and click on Add Threshold.
Inside thresholds, select the Measure as ‘Number of Open PO items from…’.
Maintain the Ranges as displayed in the image below. These define the thresholds for being marked in the OK, Warning or Critical state.
Click on Apply.
The numerical point will update the color of the data according to the defined threshold values.
Linking models within the story
You can link dimensions between models to create charts or tables that display data from multiple models. Linked dimensions also let you create filters that simultaneously update all charts that include linked data.
Click on the ‘Link Dimensions’ icon on the top.
Select the model on the left as ‘C_PURCHASEORDERVALUEQUERY’ and the custom query ‘YY1_PURCHASING_DT169_XXX’ on the right dropdown.
Choose the ‘Supplier’ dimension on both sides.
Click on Set. Click on Done.
You can modify the visualization of the numerical point by selecting the required options from Show/Hide.
You can explore further by adding more widgets with charts, tables, data points with different measures and dimensions. You can also rearrange and resize the widgets freely according to your design requirements.
Once your story configuration is completed, click on the Definition tab on top. Since this is a copied story, the Description and the Tags is already populated from the parent story. You can modify these as per your requirements.
Click on Activate.
You will be navigated to the Display Story page after successful activation.
You can review the modifications from the Configuration tab.
Switch to the Applications tab and click on the + icon.
Select Static tile and click on OK.
Title will be pre-filled with the name of the Story. You can change the title and subtitle as per your requirement. These texts will be used to distinguish your tile in the Fiori Launchpad.
Under Target mapping section, enter the Semantic Object as ‘DT169_XXX’. (XXX should be replaced with your group number for eg for place number 25 it is 025)
Default Values and Navigation Intents can be left empty for this exercise.
Click on Save and Publish.
You will be navigated to the Custom Catalog Extensions app. This enables you to make an application available on the SAP Fiori Launchpad by assigning it to the required business catalogs and publishing it.
Click on Add and search for the catalog ‘SAP_MM_BC_PO_MANAGE_PC’.
Select the Catalog and click on OK.
Click on Publish.
When the status changes from ‘Publishing’ to ‘Published’, your tile is ready for use.
Launch https://my407161.s4hana.cloud.sap/ui in a new tab in your browser.
From the Home page, navigate to the ‘Purchase Order Processing’ section under Purchasing page.
Go to the User settings icon on the top-right and click on Edit Current Page.
Click on Add tile.
Search the title of your newly created application in the search bar.
The search result will show your tile. Click on the add icon.
Exit edit mode and go back to the Purchase Order Processing page.
You can now launch your Story from the Fiori Launchpad tile. Proceed to the next exercise where we will explore some of the features inside this SAC story report.
You've now created a custom embedded analytical story and published it as an application
Continue to - Exercise 3 - Embedded SAC Stories Runtime Analysis