Using Derived Table in SAP Business Objects Universe

July 13, 2011

What are Derived table and its use? Derived table is not a physical in database however its logical table created in Business Objects Universe using SQL. Derived table can be considered like views in database where its structure is defined using SELECT statement. Advantages of Derived Table: Derived table in Universe lets you create a [...]

Read the full article →

Using Data Restriction Techniques in Business Objects Universe

June 16, 2011

Data restriction is a condition which would restrict the data to be returned to user. There are multiple ways and type of restrictions in universe which you can use. Forced Restrictions. Forced restriction are those who gets applied whenever particular objects is used in reporting query. User does not have to choose any condition for [...]

Read the full article →

Using @Functions with Universe Objects

June 14, 2011

@Functions are available in Universe designer and are available in the edit select box of an object. Following @functions are available in Designer. @Select() @Variable() @Where() @Script @Prompt @Agreegate_Aware Let learn them one by one. @Prompt This function is very useful to create an interactive object which would force user to enter some value for [...]

Read the full article →

Hierarchies in Business Objects Universe

June 12, 2011

Hierarchy is an ordered sequence of dimensions which is very helpful for multi-dimensional analysis of data. e.g. time hierarchy. Day->Week->Month->Quarter->Year Multidimensional analysis enables user to see data from different perspective which uncovers the various pattern in data which would be very helpful in taking tactful business decision. Hierarchies can be natural/Default or logical based on [...]

Read the full article →

How to solve Fan Trap in Business Objects Universe

June 9, 2011

Apart from CHASM trap, fan trap is another kind of trap that may occur in universe causing wrong results in reports. A fan trap can occur in universe when there is a one-to-many join between two tables which again joins to another table having one-to-many join relationship. However having one-many-many relation in universe does not [...]

Read the full article →

SQL Traps in Business Objects Universe : How to Solve CHASM Trap

June 7, 2011

A Chasm trap is a join path type problem between three tables where two many-to-one join path converge on a single table and there is no context to separate the converging path. However even if we have above type of joins in universe we experience chasm trap problem only when There is many-to-one-to-many relationship between [...]

Read the full article →

Top 5 SAP Business Objects Blogs

April 21, 2011

http://www.dagira.com/ This blog is authored by Dave, He is expert in Business Objects and widely followed by Business Objects professional across the world. Here you should find very helpful topics related to Business Objects. http://www.businessobjectstips.com/blog/ This blogs also covers lots of topic related to Business Objects and you will also find very useful tips on [...]

Read the full article →

Data Warehousing Interview Questions

April 14, 2011

Following are the list of data warehousing question which are asked in most of the interview. Do wait for more Data warehouse interview questions and answers. 1 WHAT DO YOU MEAN BY DATA WAREHOUSE OR DATA WAREHOUSING? 2 WHAT IS THE DIFFERENCE BETWEEN DATA WAREHOUSE AND TRANSACTIONAL SYSTEM? 3 WHAT IS DIMENSIONAL MODEL HOW IT [...]

Read the full article →

Shortcut Join and Its use in Business Objects Universe

November 7, 2010

In this SAP Business Objects Universe Designer Tutorial we will learn about shortcut joins, How to use shortcut join to generate performance optimized query and use of shortcut join to resolve loops. What is shortcut join? Shortcut join is a join that joins tables by bypassing middle table that exist in the universe. Generally shortcut [...]

Read the full article →

Understanding context and its use in Business Objects Universe

November 7, 2010

What is a context? A context is a group of path that defines a specific path for a query. Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts. When objects from two or more contexts are used, separate SQL is generated and [...]

Read the full article →