Liquidity items table

First let’s access the story that we will be using. Click on Files, then under the main Analytics Cloud space, open the story SAP__FI_CLM_LIQUIDITY_PLANNING.

This story already has two pages added. On the first page, Liquidity Overview, we can see the financial data visualized with different charts and key figures. The second page, Liquidity Planning, is empty and we will be adding to it. To add a table to the story, first switch the story from View mode to Edit mode by clicking Edit in the top right corner, then select the tab Liquidity Planning.

Click the Left Toolbar icon and drag and drop the Table Widget onto the page.

We move the table to the left side of the story and resize it as shown in the screenshot.

Let’s also change the underlying data model of the table from the sample content to our own model which we previously created. Click on the pencil icon to change the primary model.

Click Select other model…

Then select the model you created in the previous exercise NEW_SAP__FI_CLM_IM_LIQUIDITY_PLANNING.

Now we add Measures and Dimensions to the rows and columns of the table. Under Rows, click on Add Dimensions and then select Transaction Currency.

Next, under Columns, add the Time dimension to the columns of the table

For Liquidity Item we make the changes to the filters. Under the Filters panel, click on Liquidity Item (1).

Select Cash Closing, Cash Opening and Cash Flows related to operating activities and click OK.

For better readability, we want the Transaction Currency column to be displayed as the first row of the table. This can be changed by dragging and dropping the Transaction Currency field in the Builder panel as the first row of the Rows section.

We will also filter the time dimension to 2020, 2021 and 2022. Under the Filters section, click Add Filters then select Time (Member).

In the Set Filters for Time window, select the years 2020, 2021 and 2022. Then click OK.

Let’s also drill down on the liquidity items to get a more detailed view of the data. Open the dropdowns for each item under the Liquidity Item column in the table. The table should look like the screenshot below.

Click Save in the file menu to save your progress.

We must now delete the 2022 Actual data from the table (as the zero values in 2022 are a data quality problem). To do this, select all the values in the column 2022 and then hit the delete key.

You will get a confirmation of the deletion at the bottom of the screen.

Save your progress again by clicking Save in the file menu (as you did earlier in step 16).

First let’s access the story that we will be using. Click on Files, then under the main Analytics Cloud space, open the story SAP__FI_CLM_LIQUIDITY_PLANNING.

This story already has two pages added. On the first page, Liquidity Overview, we can see the financial data visualized with different charts and key figures. The second page, Liquidity Planning, is empty and we will be adding to it. To add a table to the story, first switch the story from View mode to Edit mode by clicking Edit in the top right corner, then select the tab Liquidity Planning.

Click the Left Toolbar icon and drag and drop the Table Widget onto the page.

We move the table to the left side of the story and resize it as shown in the screenshot.

Let’s also change the underlying data model of the table from the sample content to our own model which we previously created. Click on the pencil icon to change the primary model.

Click Select other model…

Then select the model you created in the previous exercise NEW_SAP__FI_CLM_IM_LIQUIDITY_PLANNING.

Now we add Measures and Dimensions to the rows and columns of the table. Under Rows, click on Add Dimensions and then select Transaction Currency.

Next, under Columns, add the Time dimension to the columns of the table

For Liquidity Item we make the changes to the filters. Under the Filters panel, click on Liquidity Item (1).

Select Cash Closing, Cash Opening and Cash Flows related to operating activities and click OK.

For better readability, we want the Transaction Currency column to be displayed as the first row of the table. This can be changed by dragging and dropping the Transaction Currency field in the Builder panel as the first row of the Rows section.

We will also filter the time dimension to 2020, 2021 and 2022. Under the Filters section, click Add Filters then select Time (Member).

In the Set Filters for Time window, select the years 2020, 2021 and 2022. Then click OK.

Let’s also drill down on the liquidity items to get a more detailed view of the data. Open the dropdowns for each item under the Liquidity Item column in the table. The table should look like the screenshot below.

Click Save in the file menu to save your progress.

We must now delete the 2022 Actual data from the table (as the zero values in 2022 are a data quality problem). To do this, select all the values in the column 2022 and then hit the delete key.

You will get a confirmation of the deletion at the bottom of the screen.

Save your progress again by clicking Save in the file menu (as you did earlier in step 16).