Create Detailed Dashboards with Design Studio and BusinessObjects Analysis, Edition for Office

  • by Sunil Mehta, Solution Architect, SAP
  • Biswajit Biswas, Subject Matter Expert in SAP Analytics, SAP GD
  • June 19, 2013
/Mobile
Learn how integration between SAP BusinessObjects Design Studio and SAP BusinessObjects Analysis, edition for Microsoft Office enables you to create data sources using methods that are not available in Design Studio alone. You then can use the changed data source in Design Studio for creating dashboards and mobile apps.
Key Concept

Smart Copy is a feature that has been introduced to SAP BusinessObjects Analysis, edition for Microsoft Office 1.3 Service Pack 3 onward. Smart Copy lets you export data sources from Analysis, edition of Office to SAP Design Studio. 

A business scenario from the aviation industry shows what you can accomplish by integrating SAP BusinessObjects Design Studio with SAP BusinessObjects Analysis, edition for Microsoft Office. In our example, you have a BEx query that fetches data on flight booking details. You have the flight name (shown as the airline), flight number, airfare, and the booking total details for that flight for the current year. This BEx query is the source for several other BusinessObjects reports and, therefore, you cannot modify it. 

A user has asked you to create a dashboard app showing the percent contribution per flight for top N flights. You can fulfill this requirement without any complex development by using Analysis, edition for Microsoft Office to fetch data from SAP NetWeaver BW with a BEx query. You then can consume the data within BusinesssObjects Design Studio.

Analysis, edition for Office allows you to create data sources using methods that are not available in Design Studio. For example, you can use calculations, conditional formatting, and exceptions to change a data source and then can consume the changed data source in Design Studio to create dashboards and mobile apps.

Following are the steps you need to take to meet the requirements to create the dashboard:

Sunil Mehta

Sunil Mehta is a solution architect at SAP. He received his master’s degree in Computer Management from Symbiosis in Pune, India. He is a certified SAP FI/CO/BOBJ consultant, working in analytics. During his career he has been associated with Accenture, IBM, Capgemini, and KPMG, and has worked in various roles, including as a consultant solution architect and a project manager.

See more by this author

Biswajit Biswas

Biswajit Biswas works at SAP GD and is a subject matter expert in SAP analytics. He has five years’ experience. He is proficient in the SAP BusinessObjects suite of reporting tools and SAP Data Services. He has been associated with development of Rapid Deployment Solutions for analytics on SAP HANA, focusing on the utilities industry.

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.