Hi,

 while Login to designer you need to fill three user 
identicative fields 
 1.User Name 
 2.Pass Word
 3.Security Domain

User name and password can we created created by the admins 
in Genaral supervisor with designer privilages.
And in the security domain you need to specify the database 
to which you need to connect it can be reporitory database 
also.

Drilling across: display different data by choosing other 
values from the drop down menu.Drilling across shows totals 
for another value on the same level in the current 
hierarchy.

There is no possibility use stored procedure in webI
WebI Deosnot support Stored procedure.
              Stored procedure can we use in only with 
Desktop intelligence.

That was true in XIR2. As of XI 3.0, you can connect to a
stored procedure with WebI through universes. Simply create
a universe on top of your stored proc with the new data
connector provided in this release.

Yes ...we can use stored procedure in XI R2.....

BCA servers (Broad cast agent)

CMC : Central management console. It manages & maintain all
server groups. It must & should enables all 28 servers or
services. then otherwise webi,cms ..etc products are not
working. at that time only designer & Deski working. so, u
must enables all servers in cmc .

CMs : central management server. It creates users, groups &
server group settings. It also maintain the security levels
also. In xir2 supervisor + BCA combining in CMS. here
distributing & shceduling docs directly.It is just like
admin for all other users or groups. It creates & manages
the folders & Categories.

I think you swapped the difnition

in boxir2 to create the universe by using business view or
Designer.

Thanks Simha
Can u plz tell me thatafter installing business objects do 
we have any available universes already created,if so where

By using Designer we can create Universes in BO XI R2.

Steps for creating universe by using Quick design wizard:
1)Open Designer with propare credensials, then Designer 
window appeares with Quick design wizard.
2)In Universe parameters enter universe name, and connection
(If required connection not exist create New connection)
3)Create intial Classes and Objects by selecting values 
from database tables.
4) Create intial measure objects if required and click on 
next.
5)the next window shows summary of created 
classes,objects,joins,filters then click on finish

Universe will created successfully.

Decode: using for reporting purpose. and it is implemented
by if stmt.
Ex: select decode(job,'CLERK','executive',job) from emp;

Case : implemented by if & elsif condition. it is using
pl/sql equality conditionality.
Ex : select  case job='CLERK' then 'executive' else 'no' end
a from emp;

it is also used for multipul colms & multi conditions.

in above stmt a is reffered alias name.

Decode and Case functionwill work in the same way.the only 
difference is we can write conditions in side the case 
function.
for Ex;
case(if c>d,d...)
decode(job,'clerk'...)

Decode
1.It’s a function
2.can compare only discrete vaules
3.Pl/Sql standards
4.cannot process null 

Case
1.It's an Expression
2.can hande range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null

Decode
The default operator for comparison is '=',
for e.g select deptno,decode
(deptno,10,'dept10',20,dept20,default)

so if the deptno=10 then the value is replaced by dept10 
and so on,

whereas in Case:

we can use any operator other than '=',
for e.g 
select deptno,
case when deptno=10 and sal>1000 then 'dept10'
else
'dept20'

Hope the difference is made clear.

Regards,
Judith

MTD MEANS REPORT FROM THE STARTING DATE OF THE MONTH AND 
CURRENT DATE  EX:I WANT A REPORT FOR THE MTD AUGUST MEANS
The report start date must be august 1st to today date(4 
aug).same for the YTD.


WHERE WE CAN USE MEANS WE CAN USE SALES AND INVENTORY ITS 
DEPENDS UPON U R REQUIREMENT

Eg for the MTD report is

select sal from emp where hiredate between
trunc(sysdate,'mm') and sysdate;
same for the ytd,qtd place yy or q respectively

There is no option to hide the prompts.

i think this is not main answer.i think options is available.

we have the option in BOXIR2,option nane in show/hide
click that option hide the prompt

i think show/hide object will select in designer or report 
level. i think in report level show/hide object by using 
pivot tab,format table dialog box.

in designer level directly select rightclick object select 
show/hide option. selected prompt object automatically done.

yes we can.we can create and generate reports by connecting 
to either universe or other data sources like ms access etc.

in my pc, open the crystal reports there are 2 options are
available 1) choose datasource 2) create a report.

choose datasource is disabled. i selected the other option
only window will appear select business view. choose bv then
after create the reports.

what can i do iwant to enable the first option.plz kind help
me.is there any another installation.