Answer / chris

Backup your cms and audit db direct in the db you are using.
Copy also your FileStore away. This should be done when
your SIA is stopped to have a clean status.

or use the import wizard to create a biar file from you
hold cms db.

what is a Micro cube?

5 Answers   TCS,

---

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  

---

how to overcome overflow of data in a report

6 Answers  

---

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

0 Answers  

---

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

2 Answers   Patni,

---

Can any one tell me for business objects what we need to study means some body tole me that we need DW,ETL,SQL.... is this is necessary..?

2 Answers  

---

How to delete the duplicate colums in a sql table ?

3 Answers   IBM,

---

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

0 Answers  

---

What is diff between InfoView and Zero BOAdmin (ZABO)?

2 Answers   Nucleus Software,

---

Explain about alerts in bos, under what situation we need to use alerts?

0 Answers  

---

Can anybody tell me what are the tuning problems?

0 Answers  

---

what is the core universe and what is the active universe?

1 Answers  

---