SAP Analytics Cloud Reporting Flexibility

SAP Analytics Cloud Reporting Flexibility

Note

This module is optional and requires you to copy the story to your

  1. To copy the preconfigured Story, navigate to Files / My Files / Public.

  2. Click on Demo_15320.

  3. Check the box to the left of the Updated_BestRun__S4Planning_Story2.0_V2 story, then click the Copy to button on the toolbar.

  4. This Copy File To popup should be displayed. Select the My Files folder on the left to ensure you copy the story to the correct location. Change the Name to include your User ID and then click Copy to copy.

  5. Navigate back to the location Files / My Files and the story you copied should be visible. Click on the Updated_BestRun__S4Planning_Story2.0_V2_XXXXX story.

  6. Now you have successfully copied the story and can complete the following steps.

  7. Ensure Edit mode is selected.

  8. Select Ad hoc analysis from the menu bar.

Note

The option may appear as a drop down depending on the resolution of the screen.
  1. Select the table, then choose Edit and Right Side Panel from the right-hand corner, then click the Builder icon.

NOTE

: Please do not publish the data if you are prompted to do so. Press
  1. Select the S/4HANA Finance chart.

Note

Values may differ depending on the values in the underlying model.

  1. From Columns, select the filter icon for G/L Account.

  2. Select the drop-down arrow to expand Available Members

  3. Click Search and enter net revenue.

  4. Deselect Operating Income and select Net Revenue then click OK.

  5. Click Right Side Panel to close the panel.

  6. Right-click BR Budget and select Add column > Single.

  7. Select the header cell of the new column and type Variance and press enter key.

  8. Select Variance and type = then select BR Budget and type minus sign - and select Actual and press enter key, i.e. = C2 - B2.

Note

The values have been inserted into the Variance column.

  1. Add another Single column after Variance, then select the header cell and type %Variance and press enter key.

  2. Select %Variance and type = then select Variance and type divide sign / and select BR Budget and press enter key, i.e. D2 / C2.

  3. Right-click Variance and select In-Cell Chart.

  4. Right-click %Variance and select In-Cell Chart.

  5. Select Right Side Panel to open the Builder panel and select %Variance.

Note

: %Variance results are actually not ZERO, we will change the scale in later steps.

  1. Click on 2 Story Calculations under Version and select the Edit Formatting Options icon of the %Variance calculation.

  2. Deselect Use number formatting of data cells and deselect Use unit of underlying measures. Change Scale to Percentage and select OK.

  3. Click on the %Variance In-Cell Chart to modify the chart structure.

  4. Click on Comparison and select Variance Bar.

  5. Click on the Variance In-Cell Chart to modify the chart structure.

  6. Click the Comparison drop-down and select Variance Bar.

  7. Select Right Side Panel to close the Builder panel.

  8. Click and drag the bottom right of the Updated_BestRun__FI_S4HANA chart to enlarge it horizontally.

  9. Save the story.

Summary

Congratulations you have completed the SAP Analytics Cloud Reporting Flexibility module.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn