Understanding Loops and its Resolution Technique in Universe

November 7, 2010

In the series of Business Objects Designer Tutorial in this post we will be learning about loops in Universe how to resolve it. What is Loop Loop is a join path problem which causes query to return less records than expected. Loop arises when join between tables forms a closed path. e.g. in below tables, [...]

Read the full article →

List of Values (LOV) in Business Objects Universe

November 7, 2010

List of values or LOV is a distinct list of data values associated with an object. When any dimension of details object is created LOV is assigned to an object automatically. Use of List of values. When user needs to filter data in a query based on specific object values, User can simply view the [...]

Read the full article →

How Measures Affects SQL Query Generation

November 1, 2010

Measure object definition contains aggregate function and a column. When measures are used with dimension or details objects query automatically infers Group by clause in Select statement. As a thumb rule of SQL, if any aggregate function is used in SQL query rest of the attributes should be used in Group by clause. Same applied [...]

Read the full article →

How to Create Objects and Classes

November 1, 2010

Now we have understood how to insert tables and create relationship amongst them. This posts covers how to create different types of objects in Business Objects Universe objects. Classes Classes are nothing but a logical group of objects. Classes are represented as a folder in a universe. Classes are very useful to group related objects [...]

Read the full article →

Types of Joins in Business Objects Universe

October 27, 2010

In Previous post we have covered cardinalities in BO universe. In this post we would be learning types of join in SAP Business Objects Universe and how to set up joins. Following join types are available in Business Objects Universe Designer which can be used to join two tables. Equi-Join Equi-join is join which uses [...]

Read the full article →

How to Define Cardinalities in Business Objects Universe

October 26, 2010

In previous post we have learned how to set up join in BO universe. in this post we will lean what is cardinality and how to define cardinalities in SAP Business Objects Universe. What is cardinality? Cardinality means a relationship between two tables based on a join. Means how many rows of one table will [...]

Read the full article →

How To Define Joins In Universe

October 21, 2010

  Since now we have inserted table in designer pane. We need to define joins between tables. For correct SQL query generation its very important to define joins correctly. There are two different ways to define joins in Business Objects Universe Designer. Define joins manually in schema Using edit join dialog by specifying join properties [...]

Read the full article →

Building Universe Skeleton

October 21, 2010

Building universe structure involves designing schema, creating joins. A schema in universe is a logical representation of underlying database schema. Designing Schema This is the very first step of universe design. Designing schema involves adding table, setting up joins and cardinalities and then assessing schema for possible joins problems and fixing them. To design a [...]

Read the full article →

Getting Started To Build Universe

October 19, 2010

Now we know lot about designer and which is enough to get started on creating universe. From file menu click on “New” (shortcut Ctrl + N) button to create new universe it will open up the universe parameters dialog boxes which have following tabs Definition Summary Strategies Control Links SQL Parameters Let’s discuss about above [...]

Read the full article →

SAP BusinessObjects Name Changes

October 19, 2010

Business Objects is now a SAP product and its well aligned and integrated in SAP world. SAP is planning to release a major Business Objects release in 2011. This release is very important as its going to be a major feature packed release of Business Objects. Along with this release there will name changes in [...]

Read the full article →

← Previous Entries

Next Entries →