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.