Question { 5501 }

How do I prevent overlapping of the tables in webi?

Answer

Right click and adjust the position of the second table with respect of the first table. That way they do not overlap even when the data of the first table increases.

Question { 2827 }

What is a section in a business objects report?

Answer

Large blocks of data can be split into sections by using master/detail report. Repeating values can be avoided by using this and also the subtotals can be displayed.

Question { 2324 }

How do you implement row level security and where do you implement?

Answer

Select the Universe in the Supervisor. Right click and open property of that Universe, go to rows tab
Click on Add button and select the tables on which you want to apply row level security.

Question { 3177 }

What is a derived table in data warehousing?

Answer

Using SQL queries in the database level, Derived tables are created in the universe.
The column of the derived tables will be the column selected in the query. Derived tables
Is used to complex calculations which are difficult to be achieved in the report levels. Using DB link,
Tables can be accessed from a different schema, is another use of different schema.