Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
Maya_Shiff
Product and Topic Expert
Product and Topic Expert
0 Kudos
217
Generating report that includes exactly the data you need is highly important and not obvious at all. The Interactive Analysis Report Designer is a reporting and analytical tool based on MS Excel (plugin) that utilizes the SAP Business One Semantic Layer (SAP HANA Views) as data source.

The tool enables you to dynamically retrieve the data you need from your company database. The recent enhancements include time functions that allow you to retrieve dates and financial period codes dynamically as a list based on your available statistics in the database, and to filter your data with the dates and financial period codes it retrieves.

The tool is available for SAP Business One, version for SAP HANA only. The time functions were added in SAP Business One 9.2, version for SAP HANA PL04.

This tip and all the other tips are available on the Tip of the week community page. You can also visit the Implementation Arena for useful implementation tips.