Taking a Test Drive of SAP Analytics Cloud Report Design

When I talk about SAP Analytics Cloud (SAC), one question that I am asked quite often is “How do I get my Web Intelligence reports into SAC?” My answer is typically that you can’t. SAP Analytics Cloud is a very broad product with a plethora of capabilities. While modernized data visualizations are one of the strengths of the platform, paginated transactional report development is not. Due to this limitation, we have always suggested the hybrid approach between SAP BusinessObjects and SAP Analytics Cloud. This makes it possible to keep existing Web Intelligence and Crystal Reports hosted in the SAP BusinessObjects platform and then augment those transactional reports with modern data visualizations in SAP Analytics Cloud Systems (i.e., SAP Analytics Hub) to help seamlessly move between the two. 

In 2021, the roadmap for SAP Analytics Cloud states that classic transaction reporting design is coming.  Some elements are already availablesuch as paginated reporting at view time and exported/printed paginated reportingI had an opportunity to test this out on our Protiviti SAP Analytics Cloud tenant, and I can honestly say that I am looking forward to the growth and development of this capability. 

Paginated Reporting in SAP Analytics Cloud 

With the Q3 2020 release, SAP Analytics Cloud gained the ability to automatically grow tables to the size of the screen. If the table data scrolls off the allocated space for the table, the height of the table will extend to display as many rows as possible. A new table pagination feature was added version 2021.1 and works in conjunction with the table grow feature previously mentioned. When more data exists than the expanded table can display, a pagination control appears at the bottom of the pageallowing the user to select which page of data should be displayed, go to the last page, first page or jump to a specific page directly. This all takes place at run time based on the design time size of the canvas. 

This table growth and pagination feature allows for the beginning of transactional reporting in SAP Analytics Cloud. A report can be designed such that the canvas size is set to a portrait orientation at letter sizeand to allow for a header and a paginated table. Once the report is designed, it can be exported or printed with the multiple pages intact. 

While this provides a great capability in transactional reporting, there are some areas that will be enhanced. Currently, we cannot use a footer that will display at the end of the multipage report. Attempting to add a graphic or text footer below the table at design time will cause the footer to be overwritten by the expanding table. It will not be dynamically placed at the end of the report. Additionally, page numbers cannot be used. While these features do not currently exist, they are coming in future releases. 

Building a Paginated Report in SAP Analytics Cloud 

Building a report that is paginated in the SAP Analytics Cloud platform is easy. We begin with a data set that will span multiple pages. In other words, we need at least 50+ rows in the tabular data set. Next, we need a model based on this data. Finally, we will create a report based on the tabular data. 

In this example, I use a dataset with approximately 1,000 records. The dataset is related to a fictitious insurance company that tracks fraudulent claims. I will build a report that displays dimensions of claim city, claim state and date of claim. It will include measures for total, injury, property, and vehicle claims. The model creation is outside of the scope of this blog. 

To better communicate the processes involved in creating a paginated report, a video has been created that explains the process, step by stepThe outcome of the process is a report containing multiple pages. The pages can be seen at view time in the browser and can also be exported to a PDF. When the export completes, each individual page is shown as expected.   

Going Forward 

It is exciting to now have the capability to produce paginated reports in the SAP Analytics Cloud platform. We are beginning to move towards a single platform that can handle not just data wrangling, modeling, visualization, planning, predicting and discovery but can also handle traditional transactional reporting. It would be nice to have repeating headers, dynamic page numbers, repeating footers and other traditional elements that SAP Web Intelligence and Crystal Reports currently provide and the good news is that these items and more are coming in future releases. 

Currently running a tenant on version 2021.1 or higher? Please have a look at these capabilities. Those who have not yet received this update should review the product updates and release cycle FAQ to determine when the update will be available. 

To learn more about our SAP capabilities, contact us or visit Protiviti’s SAP consulting services. 

Chris Hickman

Chris Hickman

Associate Director
Enterprise Application Solutions

Subscribe to Topics

Learn how a worldwide leader in providing cleaner, softer water successfully effected a major global finance and IT transformation in 2020 http://ow.ly/nORb50EmU5t #ClientStory #ITtransformation #financialtranformation

We're on @FortuneMagazine's 100 Best Companies list for the 7th time! Thank you to our employees who say @Protiviti offered them a consistently great workplace experience & support during Covid. We appreciate your confidence in us – and we have confidence in you! #100BestCos

What can be gained from upgrading to SAP HANA 2.0? Our 2-part series explores the factors organizations should consider before making the decision to upgrade http://ow.ly/ofrL50EcsyV #SAPblog #SAPHANA

Understand the key principles, requirements & parallels between data privacy & ethics: join our experts on April 27 as they discuss the privacy & ethics implications of emerging technologies. From our #TechInsights series, more at http://ow.ly/DldP50E5H3x #PROTech #PROwebinar

"Enterprise technologists must determine which protocol will be best for their organizations based on the unique circumstances of their planned IoT deployments," said Protiviti managing director Scott Laliberte. Read more: http://ow.ly/35uA50EhJSj

Load More...