Answer Posted / narsi

practical wise:

#Multivalue :- this error will occur in 3ways
1) #multivalue in aggregation
2) #multivalue in breaks header or footer
3) #multivalue in section level.

1:-- the o/p context not include i/p context its situation
this error occurs.
Ex: in a report i have year,city dia's & Revenue measure is
there.
=<revenue> In <year>
The above condition will to run the query getting revenue
column #multivalue error occurs.

solution: cilck the formulabar in view menu
select the error containg cell, edit the formula to
write below condition.
= <revenue> In(<city>,<year>) In <year>
The above formula will run correct data will appear in the
report.
Note: the above condition by default it will take agg "sum"
function.

#syntax:--
the variable in the formula no longer exist in the
condition.

Ex:- <product price> * <quantity sold>
The above condition will run this error will occur.

Solution:- Click edit dataprovider--> new object will be
need --> select error cell --> edit formula --> click ok.

#error:--
the variable in the formula is incorrect. this
error will occur.

solution : go for data menu --> click variable
select the error containing a cell --> copy the formula in
edit menu --> paste it in new cell --> go for formula bar in
view menu --> --> take the first error containg cell
-->edit the formula --> repeat the above steps.

What Is The Difference Between Oltp And Olap?

1166

---

Can more than 1 metric be applied on an analytic in business objects?

2220

---

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1433

---

What is object stores?

1029

---

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4447

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2470

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1931

---

what is the difference b/w the refresh and buffered data?

2402

---

What is the dense rank?

1319

---

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?

2086

---

how to create metric universe ?

2399

---

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

1101

---

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1080

---

How to execute the plsql procedure from the report by clicking with mouse?

1176

---

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1155

---