Answer / shamanth

1. what are the differences between prompt at universe level
and prompt at report level ?
A)Prompts at UNV level are called Predefined Prompts which
can be used across all the reports where ever required.
Report prompt will work on in that report,hence local to
that report.
2. what are the connection types in BOXI ?
A)personal .LSI
Shared .SSI
Secured BOmain.key
3. how do we give the security in universe level ? and
report level ? and objects level ?
A)UNV -> Tools -> Manage Security
Report level & Object level security will be given by Admins
4. what will happen if we check the 'MULTIPLE SQL STATEMENTS
FOR EACH MEASURE' option in Universe SQL parameters
A)We will check this option for Chasm and Fan traps,this
option will generate multiple SQL stmts for each measure
included in a Query........let me know if any modifications
for above ans..

Answer / bhaskar

Need more information about following
personal.LSI,
shared.SSI,
secured.KEY FILES

how u restrict the values?to display 5 values insted of 10 values?

4 Answers  

---

what is tuning of business reports ?

5 Answers   Business Intelligence Analytics, Oracle, TCS,

---

how we transport universes from business objects 6.5 to BOXI R2?

3 Answers  

---

Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both

2 Answers   Hexaware,

---

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

---

What is the dense rank?

0 Answers  

---

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

0 Answers   Infosys,

---

Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers  

---

Explain when we use aggregate awareness function in designer?

0 Answers  

---

what is the difference b/w star and snowflack schema in dataware house?

8 Answers  

---

How to create predefined filters in B.O.

2 Answers   TCS,

---

Explain about derived tables?

2 Answers   Cap Gemini,

---