Quick Tip: How to Configure and Explore Date-Based Data Within Explorer 4.1 Information Spaces

  • by Adam Getz, Manager – Business Intelligence, CGI Federal
  • April 11, 2016

Learn basic concepts of SAP BusinessObjects Explorer 4.1. With these easy to follow step-by-step instructions, learn how to configure date-based data within an Explorer 4.1 information space so that date-based data can be displayed and analyzed. Also learn how to configure date-based data fields for analysis.

By reading this article, you will learn how to:

  • Configure date-based data fields (e.g., days of the week, months of the year) within an SAP BusinessObjects Explorer 4.1 information space
  • Use Explorer 4.1 date-based fields for analysis

I demonstrate, using step-by-step instructions, how to configure date-based data within an SAP BusinessObjects Explorer 4.1 information space so that the date-based data, including days of the week and months of the year, can be displayed and analyzed within an information space chronologically, rather than alphabetically. An alphabetical sort of days or months does not show the user the values in the order that they have actually occurred and makes it difficult to conduct analysis over consecutive periods of time. On the other hand, chronologically sorting days or months does show the user the values in the order that they have actually occurred, and allows for analysis over consecutive periods of time.

This article is intended for SAP BusinessObjects developers and administrators who are responsible for developing and managing SAP BusinessObjects Explorer 4.1 applications and for the configuration of Explorer 4.1 information spaces.

There are four steps to this process:

  1. Connect to SAP BusinessObjects Explorer 4.1
  2. Explore an existing information space
  3. Modify an existing information space
  4. Explore the modified information space

Step 1. Connect to SAP BusinessObjects Explorer 4.1

In order to configure and use the date- or time-based data functionality within Explorer 4.1, you must have the following prerequisites in place:

  • Access to the SAP BusinessObjects BI launch pad application
  • Access to the SAP BusinessObjects 4.1 Explorer application
  • View rights to information spaces

Adam Getz

Adam Getz currently serves as a Manager, Business Intelligence for CGI Federal. In this position, he is leading a large business intelligence and data warehousing implementation for a federal client.  He is a thought leader in the field of information technology and an expert in the deployment of leading business intelligence, database management, and data integration products. He has presented at a variety of local, national, and international events, including the 2006 BusinessObjects International Conference, 2007 Oracle BIWA Summit, 2008 Oracle Open World, and 2010 and 2011 ASUG SAP BusinessObjects User Conferences. In addition, Adam is the creator and main author of bi-insider.com, a website, portfolio, and blog that provides rich technical and functional content to business intelligence and data warehousing professionals. He has also published numerous technology white papers that have focused on various topics within business intelligence and data warehousing. Adam currently serves as the chairperson of the Washington DC Business Objects User Group.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.