Answer / 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.

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 Answers  

---

Explain what three things do you consider to be the most important factors for a manager?

0 Answers  

---

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers  

---

Hi, How to navigate one report to another report in webi? Thanks in Advance

3 Answers  

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

2 Answers   Accenture, Rolta, TCS,

---

what is variable ?

3 Answers   Tech Mahindra,

---

What is self join

2 Answers   Blue Star, IBM,

---

What are the data types present in bo? What happens if we implement view in the designer and report?

0 Answers  

---

What are different types of saving options in web intelligence?

7 Answers  

---

what is Scope of Analysis

8 Answers   TCS,

---

1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?

3 Answers   Oracle,

---

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

0 Answers   Arkema pte Ltd,

---