Drill mode allows user to analyze the data in a document by breaking it down and view it from different angles and levels of detail.
Hierarchies can be created at Universe
Highest level object of the class is at the top and most detailed at the bottom Read more
Shows the relationship between tables on the basis of the join
Should only be 1 to N (one to many) or 1 to 1 (one to one). It should never be many to many Read more
There are 3 different types of BO connections.
Personal : Can only be used on client
Shared : Can be used by more then 1 user on shared server
Secured : This connection is used when you wish to distribute the completed universe to the user via repository.
Universe Development Process:
1. Prepare : Know your data source
2. Analyze : Identify the need of end user
3. Plan : Design the Universe
In relational database management system (RDBMS), the process of organizing data to minimize redundancy is called normalization. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. Read more
Equi Join: It links two tables on common values.
Ex: Tab.columnID = Tab.columnDI
Usually primary key & foreign key is used in the joins [More…]
Outer Join: It is very similar to Equi Join except it return all values, even if they are unmatched. You can have Left Outer Join and Right Outer Join. In left outer join you’ll have all the values from left table and matching values from right table. In right outer join, you’ll have all the values from right table and matching values from left table.
Theta Join: A Theta join contains an expression that is based on something other than equality: Mostly you user between Operator for this join. A theta join could use any operator other than the “equal” operator.
Ex: Table A
You need Theta join for this type of condition.
Shortcut join: It provides an alternate path represented by dotted line between two tables. It you have 3 tables A,B and C. If A is linked with B and B is linked with C. You need values from A and C, Then apply theta join between A and C on common column. While gerenrating SQL Business Objects will ignore Table B, hence improve in performance.
Self restricting join: It puts some restriction on a table. It’s not a real join. It can use to return values based on some fix value. Ex: ID = 10
List Of Values (LOV) is used for the following reason:
If you want to use @Prompt function and then offer list database values to the users for that object. It contains the data values associated with an object. It can contain values from database file and external files. When you create a dimension or detail object in Designer, Read more
Here is the SAP BO link for the tutorials that have been developed to help you get started using the Business Intelligence Suite products. Read more
Infoview is the portal to the BO’s business intelligence solution where user see all the reports based on their roles. IT’s browser based solution so, It does not reside on the users computer but on a server. Read more
Condition forces a query to retrieve the data that meets specified criteria. Condition is placed on a query to show the specific data. Use WHERE clause to define condition. It is used to fetch selected data from the data source. Read more