This ability is also available for variables which have been created in the report with datatypes of вЂdateвЂ™: Fig 2: Right click a date variable Once you have run a query, any dimensions defined as dates will have this option on a right-click menu in the available objects list: Fig 1: Right click a date dimension

With this new release Web Intelligence is granted the same ability, a welcome relief for report builders! SAP Lumira Discovery and SAP Analytics Cloud already allow you to automate the creation of date and time hierarchies and add fiscal year definitions. New objects need to be created with SQL in the universe for every date you want to aggregate or, if you donвЂ™t have access to the universe, then creating them afresh every time in individual reports is even worse.

If you are working with transactional data, or if the data-mart youвЂ™re accessing hasnвЂ™t had years, months and weeks added as fields, then there is repetitive work to be done. Date HierarchiesД¬reation of date-hierarchies in reporting has been a time-consuming task in previous versions of SAP BusinessObjects. In this blog post I will be taking a closer look at some of the new functionality that SAP has brought to Web Intelligence: the introduction of automatic date hierarchies, hyperlinking within documents, and the auto-refresh option in the Fiori interactive viewer.

SAP BusinessObjects 4.2 SP6 was released two weeks ago and we have been testing and exploring its new capabilities since then. NB: This blog has been superseded by Upgrading to SAP BusinessObjects BI 4.2 Service Pack 7? DSCallards can help.

Sap lumira designer division in chart