Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. It consists of numeric facts called measures which are categorized by dimensions.
In Star Schema all of the information about a dimension is stored in a single table. Each level of a hierarchy Read more
Error: 401 Unauthorized or Unauthorized”
If during the BO XI 3.1 you get above message than simply check the ports which are in use in this case port 8080
Note: if you did not check the ports are in use and continue to complete the the installation. The installation will complete successfully but you will Read more
A cross join produces a Cartesian product between the two tables, returning all possible combinations of all rows. If table A has 30 rows and table B has 20 rows, a CROSS JOIN will result in 600 rows.. Read more
Business Objects File Extensions:
*.bqy = Business Query Files
*.key = Bomain file
*.lov = List Of Values query
*.lsi = local security information Read more
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