Creating your own calculations In SAP BO

(4.0)

| 1997 Ratings

So far, we learned about the basic functionality of SAP BUSINESSOBJECTS ANALYSIS, EDITION FOR OLAP and we learned already some of the advanced capabilities. In this section, we will take a look, on how we can create our own custom calculations as part of our workspace.Let us start with the very basic workspace showing all the key figures in the columns and the characteristics Country and Region in the Rows.

There are multiple ways to add calculations:You can select those key figures that are part of the calculation in the cross tab and then use the Calculations menu from the tab Analyze.You can select a single key figure and then use the option to create a dynamic calculation using the menu Calculations from the tab Analyze.You can use the option to create a custom calculation available in the menu Calculations on the tab Analyze.In the next few steps, we will use our cross tab, that we just created, to explore these three options.

24. The calculation is shown on the left hand side and you can now change and customize the new column (see Figure 5.27)

.Figure 5.27 Calculation Details

25. Enter “Total Costs” for the Name. 26. For the option Place After use the Screenshot_560 symbol and place the calculation after Net Value. 27. Click Validate. The Status will display if your calculation is valid or not. 28. Click OK. 29. Use a right click on the Key Figures in the Columns area. 30. Select the menu Filter by Member. 31. Remove the key figures Transport Costs and Product Costs from the cross tab. 32. Click OK. 33. In the cross tab, select the column header for the key figure Total Costs. 34. Press (and keep pressed) the CTRL button on the keyboard. 35. In the cross tab, select the column header for the key figure Net Value. 36. Navigate to the tab Analyze. 37. Select the menu Calculations > Percentage Share.Based on the order, we used to select the columns, the newly added calculation will show the percentage share of the Total Costs in relation to the Net Value. 38. In the cross tab, select the column header for the key figure Net Value. 39. Navigate to the tab Analyze. 40. Select the menu Calculations > Dynamic Calculation (see Figure 5.28).

Figure 5.28 Dynamic Calculations

Because now we only selected a single key figure, the option available are different and we cannot use the standard calculation such as Add or Percentage share, but we can still leverage the Dynamic Calculation.

41. Use the option Rank Number (see Figure 5.29).

Figure 5.29 Workspace with Dynamic Calculation

A new key figure displaying the Rank of the key figure Net Value is being added to your cross tab. You can use the Dynamic Calculation option to add columns such as a Rank or an Average to your cross tab.

Using the custom calculation option (see Figure 5.30), you can create a calculation using a large list of formulas.In this section, we reviewed the different options to add a calculation to your cross tab. In the next section, we will use BEx variables in our workspace with SAP BusinessObjects Analysis, edition for OLAP.

About The Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

Mindmajix - Online global training platform connecting individuals with the best trainers around the globe. With the diverse range of courses, Training Materials, Resume formats and On Job Support, we have it all covered to get into IT Career. Instructor Led Training - Made easy.