SAP is one of the leading IT companies in the market. SAP BusinessObjects is a powerful Business Intelligence tool that help you to discover hidden insight in your data. SAP BO has many modules for reporting like SAP BO web intellignece, crystal reports, dashboards, design studio and lumira. ALL these tools access data sources through SAP BO semantic layer known as Universe. Web Intelligence is the main reporting tool under SAP BO portfolio and it can be used to create classical as well as modern reports. It is very simple and easy to learn tools and so it can be used by end business users to create their own reports (Self-Service).
This is an Introduction about creating reports with SAP BusinessObjects Webi. In this course we will earn how to create interactive, data driven and outstanding web intelligence report which can help to take the right decision on the right time.
The i will introduce our course Agenda and talk about the main topics that we are going to cover in this course, Finally we will discuss the best and expected target students for this course.
So what you are waiting for...
In this lecture we will learn how to login to the system. You need to know your SAP BO server URL which usually http://<Server Name>:8080/BOE/BI
You will need a user name and password in order to be able to login to the system. The logd in user should have perivilage to create and edit Webi reports
In this lecture you will see some sample reports. These reports will give you an idea about the main featuers that we are going to learn is this course. You can also get an idea about what we are going to create by completeing this course.
In the 2nd set of sample reports we will see how fold unfold feature works
Formatting reports is one of the main featuer that we will learn in this course
Final Conclusion on section # 1
Quiz on Section # 1
Creating a query is the first step to create a report. We need to select a Universe first and then we have to select dimensions and measures that we want to include in our analysis.
Business layer is the main output of Universe which is the semantic layer of SAP BO. We can use business layer to access information using a business meaning of the information rather than the technical / physical database name. In this leacture we will learn about:
To build a query you need to decide objects to be added to the result set. these objects will be available to be used in the report to do the required analysis. We need also to define our where condision to restrict our data set results.
Prompts can be used to prompt end user to specify a filter value
List of values can help end users to select filter value instead of writing it.
Learn how to run a Query
This Quiz will cover section 2
Learn how to format your report
Learn how to create break and sections
Learn how to create filters
Learn how to use sort and rank featuers
Learn how to use Drill featuer
Learn how to share your report
Covering Section 5
Taha M. Mahmoud (PMP, TOGAF, ITIL, and CSM) is a senior BI consultant, BI project manager, and solution architect. He has a BS degree in computer science and automatic control from Alexandria University, Egypt. He has a great passion for new technologies, especially those related to business intelligence. Taha has more than 9 years of experience in working on, consulting for, and deploying successful BusinessObjects projects in the banking and telecom industries. He is the author of "Creating Universes with SAP BusinessObjects" and "Learning SAP BusinessObjects Dashboards".
Book: Creating Universes with SAP BusinessObjects (ISBN: 978-1782170907 )
Book: Learning SAP BusinessObjects Dashboards (ISBN: 978-1785286629 )
Article: Creating Informative Desktop and Mobile Dashboards with SAP BusinessObjects Solutions (BIEXPERT)
Article: How to Solve Loops, Fan, and Chasm Traps in SAP BusinessObjects Universes (BIEXPERT)