<p>about your learning experience to help us improve.</p>

You've completed

cleanFiles/bookmap_S4H420_en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2024-07-29T08:10:24.000Z

Working with Multidimensional Reports

<div id="content"><p tabindex="0"><strong>Multidimensional reports</strong> provide the presentation layer for analytical queries. They are launched by the business user from SAP Fiori tiles and provide a large feature set to explore the query results. With a multidimensional report a business user can sort, filter, drill-down, add totals, and display data hierarchically.</p><ZoomableImage><img tabindex="0" src="/service/media/topic/eee9bac7-b3c1-4f07-b604-38115e4174b2/S4H420_26_en-US_media/S4H420_26_en-US_images/MD report_screenshot.png" alt="example of a multidimensional report for sales data" title="example of a multidimensional report for sales data" class="image 1_1_landscape" style="max-width:900px;max-height:none" /><div class="imageCaption"></div></ZoomableImage><p tabindex="0">A tile launches exactly one multidimensional report. The name of the report appears on the tile surface.</p><p tabindex="0">There are many standard multidimensional reports delivered by SAP covering many lines-of-business. Customers can also create their own multidimensional reports from standard or custom analytical queries. You can search for queries using the tool <i>Query Browser</i> that we described in the previous lesson.</p><p tabindex="0">One of the key use cases for multidimensional reports is <i>unrestricted, exploratory analysis</i>. Large data sets are provided to the business users who apply filters, switch dimensions, pivot the results and drill-down, to generate views that are meaningful to their business area. Quite often, business users don't know what the business question is until they begin exploring the data that often reveals interesting information which they can then focus on.</p><p tabindex="0">It is possible to save navigation states and page layouts to avoid having to re-enter filter values, repeat navigation steps and re-organize the layout of the report each time it is launched. Saved bookmarks and layouts can be shared with other business users.</p><p tabindex="0">Results can be exported to Excel or as a PDF, and you can create a new SAP Fiori tile directly from the report so it is easy to launch with the users' settings.</p><p tabindex="0">A multidimensional report usually presents a very long list of fields. These fields are defined in the analytical query. The developer who created the analytical query often does not know which fields are of interest to the business user, so they usually include most of the fields from the underlying cube. The developer also has to make a choice as to how the fields they have chosen will be displayed (in the rows or columns). This choice may not be what the business user would want. The navigation panel of the multidimensional report allows the business user to decide which fields they need for their analysis and where they should appear. They can add and remove fields from the result and save the new layout.</p><p tabindex="0">One of the most powerful features of the multidimensional report is the ability to navigate directly from the results into another related app without leaving the report. For example, by clicking on a specific employee who appears in a sales performance report, you could jump into another report to explore the employee's bonus plan.</p><p tabindex="0">Launch the following video to learn how to launch a Multidimensional Report.</p><div class="kalturaVideoLessonWrapper"><div id="1_no1ntrjv" data-testid="video" class="kalturaVideoLessonContainer" aria-label=""></div></div><p tabindex="0">Launch the next video to learn more about navigation in a Multidimensional Report.</p><div class="kalturaVideoLessonWrapper"><div id="1_l6aavz1o" data-testid="video" class="kalturaVideoLessonContainer" aria-label=""></div></div><p tabindex="0">Launch the next video to discover advanced features of the Multidimensional Report.</p><div class="kalturaVideoLessonWrapper"><div id="1_ptyglov2" data-testid="video" class="kalturaVideoLessonContainer" aria-label=""></div></div></div>

Multidimensional reports

Discovering SAP S/4HANA embedded analytics

Learn how to build a multi-dimensional report using analytical queries. Discover how to execute queries, save as tiles, and navigate through the report effortlessly. Perfect for SAP users seeking efficient data analysis.<br><br># This description was auto-generated #

MD_Report_Part_1_C26_video.mp4

A multi-dimensional report is built on an analytical query, so it might make sense to begin by looking for a query by clicking on the query browser app. Search for your analytical query, select your analytical query and notice in the bottom right corner you'll see open for analysis. This will actually launch this particular query and execute it in the multi-dimensional report layout. You'll notice nothing happens until I complete the required parameters. Notice the mandatory asterisk means you must enter these before anything can happen. So now let's click on go execute the query with those filter settings. The results now appear. We'll take a look at the detail navigation in the next video but let's Let's just stay with this idea of launching the multi-dimensional report. What we can also do here is if we plan to use this multi-dimensional report again, rather than have to search through those analytical queries again, what we can do is, in fact, save as a tile. Now what this will do is ask me for the name of the tile, and then it will ask me where to put the tile. So the tile will then appear on the Fiori launch pad in one of my tile groups. So that means I don't have to then search for the analytical query each time. It's ready to go with one click on a tile. It means I can also save my own filter selections and personalization. And let's go back to the main Fiori Launchpad. Another way to get started with multi-dimensional reports is to click on the tiles that have been prepared and developed by SAP. There are many different tiles already created by SAP. This one's incoming sales orders. If I click on this one, this opens up a standard delivered multi-dimensional report. Again, it's based on the same analytical query in this case, but there are many analytical queries that do not have tiles. So you can then create your own tile, as I showed you earlier. So let's complete again the parameters. And of course, now we have an option to do some navigation, which we're going to look at in the next video. So getting started with multi-dimensional reports can either start with locate the query, open in the multi-dimensional report layout with the option to save as a tile, or just go and locate one of the ready-made tiles that are delivered by SAP.

Discover how to effectively respond to parameters in a multi-dimensional report using analytical queries. Learn to customize filter options, rearrange report layouts, and utilize various functionalities for enhanced data analysis.<br><br># This description was auto-generated #

MD_Report_Part_2_C26_video.mp4

We have launched a multi-dimensional report and now we need to respond to the parameters. Now the parameters are defined in the underlying analytical query CDS view. They're either mandatory if we see the asterisk or they're optional if there is no asterisk. You can see this one also has a default value provided by the analytical query. So we need to respond with the display currency. Let's put in here US dollars. dollars. We'll leave the other filter values empty so we have plenty of data as there is in our result. Now notice here you can hide the filters. So as a business user, I may want to set my filters once, and then I don't need to see them again, in which case I click on adapt filters. And notice I can switch them off if they are not required. And that simplifies the filter area. We now see the query result appear. Let's hide the filter bar just to give ourselves a little bit more room on the screen. Notice the default layout of the report is defined by the analytical query. But the business user can rearrange this layout. So what they can do here is look over on the left side of the screen, and they can see that there are plenty of fields available. Notice rows, columns, and available fields of the three categories. So what's in the rows at the moment is sales organization, as you can see here, we have of course measures. Notice there are multiple measures in the columns. We don't see those until we expand this little arrow here because these actually go out across horizontally. So let's remove some of these. We only want to see net value, but let's remove these. Now we can either click on remove individual measures or we can just click on the header of the measures And we can just drop down here and select only the one from the selection that we require. Okay, notice over here, we see only net value displayed in bold. We can see how many additional fields there are. Analytical queries provide lots and lots of fields. Remember the analytical query developer doesn't know what the business user necessarily wants to see. So they provide lots and lots of these fields. The business user can now either drag and drop any of these fields, so let's just take business area. Notice how I could drop that in one of these drop zones. I can also just use the buttons to the right side to add to the rows or add to the columns. So let's add something in here. Let's go and get something like the division of the product, add that to the rows. Now things are getting a little bit squashed up here. So what I might do is just collapse the navigation area. area so we have a full screen and now what I can do is just again drag the columns across a little bit like that that's better now within each sales organization we see the divisions other things we can do are to add totals we can also fine-tune measures with formatting the numbers we can change the descriptions length so for example the long short medium descriptions of any of the fields what's also nice is you can click on any of the values and apply further drill down so you could for example add an additional drill down by adding in another field. The idea is that you've clicked on a particular value such as Germany sales organization but you want to keep that as a filter and add a drill down say by customer within that. In the next video we'll have a deeper dive into some of the additional functionality.

Discover the powerful features of the multi-dimensional report, from bookmarking navigational states to customizing layouts and seamlessly jumping into other applications. Enhance your data analysis capabilities with these tools.<br><br># This description was auto-generated #

MD_Report_Part_3_C26_video.mp4

In this final video, we'll take a look at a few more features of the multi-dimensional report. The first one is the ability to bookmark your navigational state. It can take some time for a business user to navigate to a particular state using filters, a particular set of drill down fields, for example. What we can do here is use the drop down and actually save a particular bookmark. So we might want to call this one here by material month, for example. And what we can do here is decide whether to retain the filter values or to start a game with no filter values. If we click on here with the filter values, it means that now if I move away from this navigation state by say drilling down on other fields, I can always return back to this particular navigational state. This is helpful because we can also share these navigational states with other business users. Another feature we can look at is the ability to save the entire page layout. This is called the page variant. We can see here the views, the standard view is default, but what we could do is rearrange the screen. For example, you notice the graphical display at the very top. There's no reason why we can't move that to say, a different part of the screen. So for example, I might drag the graphical display into another position. What I can also do is come up here to the page layout and there are some advanced features where I can actually reorganize the layer to the screen. The screen is made up of two parts. There's section one and section two. So think of those as different layers of the screen. And within those layers, you can put the elements where you like. So for example, in section one, we've got title, graphical display and the filter selection. So these are the elements that you see at the top here. And in the bottom, we see that we've got the actual data analysis and the query information. So if we close this, we can see we're looking at these two tabs here. But we can reorganize the screen quite significantly and then we can save that layout. We can save this layout and also give the layout a name and share it with our colleagues as well. So we can highly customize the multi-dimensional report with filters, navigational states, layouts, et cetera. Now one feature I do want to highlight here as well is the ability to jump into another application. Now this is one of the most powerful features of the multi-dimensional report because a business user will often navigate to a point where they need to leave the multi-dimensional report and investigate further, perhaps with another application. Let me give an example. So let's just focus here on one of the customers here. So if we just right click on this customer, and if we say we'd like to filter, so we'll filter here. And what we might do here is keep a filter value. And then what we can do is in fact, click on this particular customer, and we might want to add another drill down. Let's add the sales order to the drill down. So, let's imagine we want to investigate sales order number 361. What we can do is highlight that cell and then use the option navigate to and here are the related applications. Many of these are transactional. Some of them are analytical. Let's take a look at this one here. Sales order. So, here we see order 361 and all the information about the order, the customer details, the product, we can even further drill down on many of these pieces of information as well, and even click on related apps. And here we can actually navigate to the actual transactions. For example, if I want to change this sales order, I could do so right here. And all this is done without losing your place in the original report, which is still available on another tab. And back to the report, we can see the chart is displayed and we can also make changes to the chart, for example, the chart type. What we can also do here is save this particular report as a tile. So a new tile could appear on your Fiori launch pad. And so to summarize, the multi-dimensional report provides the business user with a powerful set of tools where they can work with their own data and they can provide their own layouts, applying their own filters and saving these layouts and navigational states for reuse.