In this course, we will Install SAP BusinessObjects programs, namely Information Design Tool (IDT) and Web Intelligence (WebI) - for free.
We will create a sample database in Access 2010 (although you may already have your own database that you want to use), and then create a database connection to it.
We will then create a "universe" in IDT, with a database Relational Connection, Data Foundation and Business Layer.
We will then export this universe from IDT and open it in WebI.
We will then create some tables and graphs.
This is a quick overview of these two programs, following which you will have the programs on your machine, and can experiment for yourself.
I'll introduce the course objectives.
We'll be going on to SAP's website and downloading the programmes we need for this course - for free.
We'll be using Microsoft Access 2010 to create a sample database, which I will call "Southwind".
We'll be creating a DSN (database connection) to our sample database, ready for our SAP program to use.
We'll then open the Information Designer Tool (IDT) and connect to our database.
We'll be adding a data foundation layer, so that SAP can see what tables we want to use, and information about those tables. We'll be adding joins and primary keys.
We'll start creating a business layer, so that we control what the end user has access to.
We'll be refining our business layer, and then saving it to our hard drive.
We will open our universe in WebI. It's harder than you think!
We'll now add a table and some graphs, based on our previous query.
Let's have a look at the various options you can use in WebI, starting with the File and Properties menu.
We'll now go onto the Report Elements menu.
Let's investigate the Format and Data Access menus
Let's look into the Analysis menu.
We'll finish with looking at the Page Setup menu, the context menus, and a brief look at all the formulas.
Well done for completing this course. Let me give you a little present.
Thank you for watching this course. I hope you have enjoyed it.
Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.
He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.