Friday, September 4, 2020

Business Objects Step by Step Tutorial


Business Objects is the reporting tool from SAP Company (2010).
As Business Objects is the reporting tool from SAP Company, it is called as SAP BO
Current Version of BO is: BO-XI R/3
BO: Business Objects.
XI: Version 11(in rowman characters)
R/3: Release 3.    ------à     BO Version Release 3.
BO-XI R/3 = BO-XI R/2 + SAP Integrations (It is available from 2008 onwards)
                                      SAP BW/BI Integration services
                                                (SAP BW and BI are ETL tools from SAP Company)
                                      VOYAGER connection
                                      Dashboard Manager
                                      Live Office
BO-XI R/2: It is the reporting tool from Business Objects.
          BO-XI R/2 = BO 6.5 + Crystal Reports (2001)
          BO 6.5 = BO 5.0 + WEBI (Web reporting) (1998)
          B0 5.0 = BO Local Reports (4.5) + Universe + DESKI (local reports) (1995)

Universe is interface between database environment and reporting environment.
Universe is a file created with extension “.unv”. It has source database connection information and source business information in the form of Tables to be used by Reporting Environment.
To create Universe following are the main Steps:
1.    Universe Parameters                                    6. Create Classes
2.    Insert Tables                                                         7. Create Objects
3.    Insert Joins                                                 8. Create Hierarchies
4.    Detect Loops                                                          9. Export Universe
5.    Resolve Loop
Universe Parameters:
Creating the Universe with required Database connectivity is called as Universe. Here universe is the file created with extension “.unv”.
Insert Tables:
Adding required business Tables from Database Environment into Universe structure panel is called as Insert Table. Whenever a table is added into Universe, only table Metadata is added but not the table with data. As universe is used to support SQL Query development, for preparing SQL Queries table Metadata is enough.
Insert Joins:
Using this step we apply the relation between the Tables in Universe Structure Panel.
To apply relation between Two Tables we need to use following Two Concepts:
1.    Type of Join
2.    Type of Cardinality.
Type of Join:
It specifies how data to be merged between two Tables. In Universe following are the type of joins to specify which type data to be merged.
a.    Inner Join. [Returns common data between two tables.]
b.    Left Outer Join. [Returns common data between two tables and all extra records in Left Table.]
c.    Right Outer Join. [Returns common data between two tables and all extra records in Right Table.]
Note: Universe does not support FULL Outer Join.

FAQ: In what cases data in Database table can be duplicated?
Ans: if there is no primary key in the table or using Composit Key also there is possibility of data duplications in the column.
Composite Keys: If the Primary key is assigned to more than one table column then it is called as Composit key.
Cardinality: It defines data relation between the Tables as
1.    One –to- One
2.    One –to- Many
3.    Many –to- One
4.    Many –to- Many
FAQ: In the database technically how many One –to- One relations are possible?

Ans: In this example One record in Table-1 can have exactly One record in Table-2. This relation is called as One –to- One Relation.
FAQ: How many One-to-Many or Many-to-One relations are possible?
Ans: If one table has Primary key and another table has Foriegn key relation, from First Table is One-to-Many relation and from second Table is Many-to-One relation.
FAQ: How many Many-to-Many relations is possible?
Ans: If the Tables are related between Two non key columns or Two Composit key columns then there is a possibility of Many-to-Many relations.

          Time taken between Query Request and Query Response is called Time Slash.
If there are N Tables with N Relations applied with each other, it is called as LOOP.
Loop is a Drawback in reporting. Because of Loop, reports will display the data in Time Slash.
Finding the possible loops in Universe structure panel is called as Detecting Loops.
(Detect Loop is the option used in Universe to find possible Loops)
To resolve the Loops we can use 4 techniques in Business Objects.
Note: if the loops are deleted from structure panel, the report output is displayed with high efficiency.
To resolve the LOOPS:
1)    Delete Unnecessary Joins
2)    Create Alias Tables
3)    Create Shortcut Joins
4)    Create Context
Delete Unnecessary Joins:

As per reporting rules, for N tables we need N-1 Joins for SQL Queries.

In Industries most of the reports are created using Transaction based master data. As order_details is the Transaction Table and sales_branch and sales_staff are master tables J1 and Jj2 are commonly used joins. By deleting J3, if business requirements can be satisfied then delete J3 join.
Second Solution: In a Loop, if there is Many-Many Cardinality joins existing then Many-Many joins can be deleted directly.

Create Alias Table:
* Generate a report to display orders collected by staff in which branch (J1 and J2)
*Generate a report to display orders of Branch (J1)
* Generate a report to display orders collected by Staff (J2)
* Generate a report to display list of employees working for Branch

Context is another resolving solution for LOOPS in Business Objects, which creates memory block in BO Repository with set of join results. As the memory is already created in BO Repository Data retrieval, is possible.
BO Repository is the Database of Business Objects. This is divided in to 3 areas as:
1)    Security Domain Area
2)    Universe Domain Area  and
3)    Document Domain  Area
Security Domain Area:
Security Domain Area has the users and user groups to control Authentication of BO Repository.
Universe Domain Area:
Universe Domain Area is the part of BO Repository to hold all the universes which are exported from BO Designer to be accessed by reporting environment like WEBI,DESKI and etc.,
Document Domain Area:
Document Domain Area is the area where created documents are saved to be accessed by client environment with corresponding Authentications.
In 2001, in BO XI R2 Shortcut Joining are introduced. Using this property BO assigns secondary level priority for the joins in the LOOP. If all Tables are used in Reports then OLAP Engines uses the Main Joins and ignores the Secondary Join. If main Joins are not used then we use Secondary Level Joins in Reporting.
***Best Resolving techniques for LOOPS in BO are:
1)    Delete Unnecessary Joins
2)    Use Shortcut Joins.

          A class is the presenting Object in Universe to present Business Information to the reporting Environment.
          A class is assigned with one or more Tables information to be presented to the Reporting layer.
          A class represents Schema in Universe.
A class is a collection of Objects.
Objects represent a table column for reporting.
Simply, reporting columns in Business Objects are called as Objects.
*Basesd on type of data to be displayed in reporting, Objects are classified as 3 types.
* Dimension Object
* Detail Objects
* Measure Objects
Dimension Object: It is the default property applied for every database column added inside the class. This property can be assigned with all data types of source database to display source business data as it is.
Detail Objects: Depedent Objects in Business Objects are called as Detail Objects. Using this property we need to select a parent Dimension Object. While reporting detail object is also added with parent dimension object automatically.
Measure Objects:  This property is appled only for Numeric Columns added with corresponding Aggregated functions to display summary information in the reporting.

          Hierarchy is collection of Dimension objects arrangement to support Drill Down and Drill Up functionalities.
In hierarchies we can find two options as
1)   Default Hierarchies.
2)   Custom Hierarchies.
All objects added under the class panel are displayed as Default Hierarchies.
Based on these default hierarchies we can create required Custom hierarchies to support RRI Concepts.
RRI: Report to Report Interactions.
----àCommunicating TOP Level hierarchy to next level hierarchy is called as Drill Down.
----àCommunicating from Bottom level hierarchy to Previous level hierarchy is called as Drill Up.
*Export Universe: Using this option, the .unv file is send from local system into BO Server System (BO Repository) Universe Domain Area to make universe accessed by reporting authors.

Source NON BW/BI Systems                           Source BW/BI Systems
1)    Universe Parameters                       1)Universe Parameters
2)    Insert Tables                                             2) Insert Tables      
3)    Insert Joins                                     3) Insert Joins       
4)    Detect Loops                                              4) Detect Loops       [not allowed]
5)    Resolve Loops                                  5) Resolve Loops    
6)    Create Classes                                 6) Create Classes   
7)    Create Objects                                 7) Create Objects   
8)    Create Hierarchies                           8) Create Hierarchies
9)    Export Universe                               9) Export Universe

NON-SAP, whenever Business Objects is loaded there is sample Database loaded as“efashion.mdb”.


  1. very Informative

  2. Really Nice Article

  3. it's a Nice article, very helpful for us and thank's for sharing. we are providing SAP BO online training

  4. Too good Nice article ,very helpful

  5. Really good piece of knowledge, I had come back to understand regarding your website from my friend Sumit, Hyderabad And it is very useful for who is looking for SAP BO.

  6. Envelope Paper - High quality Enveloper papers : Coloured, Coated, uncoated, PE coated and recycled envelope paper supplier in United Kingdom. Trusted Envelope papers manufacturing company that believes in client’s satisfaction.

  7. back pressure turbines - Kessels is a leading manufacturerof Single Stage and Multi Stage Back Pressure Steam Turbines. Our state of the art manufacturing facilities and comprehensive product range makes us the preferred choice of industry leaders and consultants for over 25 years.

  8. Thanks, Very nice and easy to understand tutorial.
    Is it possible to write direct query to database while generating reports or some alternate approach?
    Like we can do in Oracle BI Publisher. Don't know you are familiar with it or not.

  9. great work really thank you for the info about sap .a free live demo on all sap Exp trainers
    SAP Business Objects Trainer

  10. excellent post thanks for sharing from Kajal

  11. Are you sitting comfortably? Many an afternoon has been enjoyed by a family, bonding over the discussion of Business Security. While it is becoming a hot topic for debate, there are just not enough blues songs written about Business Security. Inevitably Business Security is often misunderstood by the over 50, many of whom fail to comprehend the full scope of Business Security.

  12. Are you sitting comfortably? Many an afternoon has been enjoyed by a family, bonding over the discussion of Business Security. While it is becoming a hot topic for debate, there are just not enough blues songs written about Business Security. Inevitably Business Security is often misunderstood by the over 50, many of whom fail to comprehend the full scope of Business Security.

  13. It was really a nice article and I was really impressed by reading this article We are also giving all software Course Online Training. The Sap BO Online Training is one of the leading Online Training institute in the world.

  14. Thank you sir,It is nice and more informative. We are providing online training on & for more info: sap wm online training it gives the career plan. It is in simple language and understandable to all freshers.

  15. Great article for Business Objects for online training. Thank you so much such a presentation.
    Here are some more points i brought for you. You will really like itRead more...
    Check this site mindmajix for indepth sapbo blogs.
    Go here if you’re looking for information on sapbo tutorials.

  16. Good Article. interesting tutorial point about example diagrams, so, nice tutorial in SAP BO subject.
    we are provide the SAP BO training.

  17. Well, Good information you have placed and useful too. Just now I saw your blog and it is nice and good maybe we can see more on this. Are you aware of any other websites on this .
    Hamsini Technologies is provide Best SAP BO Training by TOP Industry Experts in Hyderabad with 100% Job Oriented & Placement Record.we teach all SAP Modules.and
    we can provide recorded sessions also.

    Free 1st Demo Class,
    Contact us :

    SAP BO Online training

  18. This comment has been removed by the author.

  19. This comment has been removed by the author.

  20. This comment has been removed by the author.

  21. Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy in SAPGTS. Thanks a lot.It is uaefull to me and my training Hyderabasysonlinetraining center.

  22. Thanks for giving Good Example.
    Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy in Sap Bo. Thanks a lot.It is uaefull to me and my training Ithubonlinetraining center.

    1. Ever heard of C J Date? I guess not.

  23. Interactive Property Solution iBrouchure with numerous exceptional capacity to make your undertaking intriguing. It tells the story and interactive.

  24. Thanks for providing these information. We are providing on line training classes.

  25. Thanks for a marvelous posting!the information about Sap Training I quite enjoyed reading it, you’re a great author.
    I will remember to bookmark your blog and will often come back sometime soon.
    Sap Online Tutorials | SAP Training Tutorials

  26. Hi,

    A small correction. XI is SAP BO not refferes the roman letter,when Business Objects and Crystal Decisions merged BOBJ was on version 6.5, Crystal had version 10. the first common product was Business Objects Enterprise XI (Extreme Insight) that internally was coded with r. 11
    We then had version 11.5 (XIR2) then 12 (XI3.0) and after the SAP acquisition the number remained internally as 14 for BI4.0

  27. Somebody necessarily help to make severely posts I might state. This is the first time I frequented your website page and to this point? I surprised with the research you made to create this particular post extraordinary. Well done admin..

    Linux Training in Chennai Velachery

  28. Thanks for writing in such an encouraging post. I had a glimpse of it and couldn’t stop reading till I finished. I have already bookmarked you. seo services in jalandhar | website designing in jalandhar | web designing in jalandhar | it company in jalandhar

  29. thank you for posting such a useful information.we are very of the recommended blog for learners.keep on posting such a articles also visit

    SAP BO online training in hyderabad

  30. This blog is excellent thanks for giving the information about the sap bo
    sap bo online training

  31. Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

    iOS Training in Chennai

  32. Very nice post here thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.

    Digital Marketing Course in Chennai

  33. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    PTE Coaching in Chennai

  34. I just see the post i am so happy to the communication science post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be replay for your great thinks and I hope you post again soon.

    Fresher Jobs in Chennai
    Fresher Jobs in Delhi
    Fresher Jobs in Bangalore
    Fresher Jobs in Kolkata