In my Point of view 

Complex reports is 

I have created many reports using VB macro like 

I had created one control report which is defined many Sales
ares, Plants, Sales repcode..... like i have created control
reports and based these refer to created another report
which is refer to control report and run the each area or ,
sales repcode.... like that i have created and these reports
will be published individually on webi.

I thought that these type of reports are called Complex reports.

Thanks,

Complex reports are the reports which pull up data from 
different sources. Complexity also depends on the data 
model and the critical way the report data is going to be 
generated.

In Designer

This is a useful feature to show you a sample of the data
in your tables as you build objects in the universe. As a
default, Designer will present
you with the first 100 values in your database

I think ur expecting this one.

Regards,

Sreeivas

you seltect the particular field of table and then right 
click you get options thereno of rows in table you click 
that u get the table values

you can able to face user level and group level rights

1)5.1 stored datas frm repository level boxi u stored in 
folder type of options

2)provide RLS level in 5.1 supervisor will provide in boxi 
developer provided

Hi,

complex reports:

I have created many reports using VB macro like 

I had created one control report which is defined many Sales
ares, Plants, Sales repcode..... like i have created control
reports and based these refer to created another report
which is refer to control report and run the each area or ,
sales repcode.... like that i have created and these reports
will be published individually on webi.

I thought that these type of reports are called Complex reports

In my senario i have create a complex report for 
insurances is in my product create a report for client 
details basically one persons having n number of policyies 
i will find out the persons partiular report

IN UNIVERSE DESIGNER RIGHT CLICK -CREATE DERIVED TABLE -
GIVE NAME FOR DERIVED TABLE.

IT'S DISPLAYED IN THE UNIVERSE DESIGNER PANNEL.

MAINLY DERIVED TABLE USED FOR WE CAN CREATE OUR OWN QUERY.

LIKE WE CAN  SELECT ONLY THE PARTICULAR TABLES IN THE DESKI
 WHILE TRACKING THE DERIVED TABLE(IT'S BASED ON THE OUR   
QUERY)

compatible and incompatible objects will be defined when 
you create aggregate awareness. This is one of the 
performance improvement technique at the universe level.

a derived table is dynamic,virtual table that you create
within universe structure.it consists of set of sql
statements that you create in designer and you can use it as
a logical table to create objects.

in the derived table sql set,you can put a select statement
in place of table name in the from clause.sql set can also
contain embeded prompts and you can create joins between
embeded physical tables ,just as you can with other tables.

derived tables can be used in place of database
views,aggregate tables,lookup tables.

by using derived table we are processing load from the
report server to the database.

views are also virtual tables which are created in database
level and can make use in universe.but we can not create
them in universe structure.

Pre-defined filters are created in Business Objects 
Designer where we create/edit/append Universe. In the 
universe window, in the right hand pane is classes and 
objects, by default the view selected is of dimensions, 
measures and details, to create filters, the view must be 
changed to filters and use add object and select the 
required where clause.

Create it in Universe with or without prompt option as per your requirements.

In general the same index theory applies to DW as it is for 
any RDBMS. So we can have one clustered index and several 
non-clustered indexes on a table. defininng the index 
depends on the need for the particular SQL. We usually 
define them on the columns used in the join clause and in 
the where clause to fecilitate the faster fetch.

I thing, the plm is in universe, there is only one table is 
used in the universe and all other is derived tables. where 
you get objects? if you get objects from derived tables 
alone pls check the join condiion in derived table's sql 
query, else if you are pulling objects from derived table 
and db table, definitly you would get duplicate rows.

This can be solved in a simple manner.. In Report just 
double click your table or right click for Table 
properties.. In the General Tab just uncheck the 
option "Avoid duplicate rows Aggregation". Hope you will 
get the desired results..

--Senthilmurugan.S

Adhoc report is nothing but an user friendly report. The 
end user can create thier own report like drag and drop the 
objects what they wants in report based on the business 
perspective.

This reports are the once which are just created at that 
time for user's specific needs.

These are the user-friendly reports

simple reports r also called as ad-hoc reports

ADHOC reports are developed by business users for data 
analysis purpose where it can be saved or may not saved 
some times.

hi,

this is srinivas 

In BO 6.5 windows level,command level and row level these 
are securities

and XIr2
Folder level and user level 

create in central management console