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.

I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?

4 Answers  

---

How we drill up week to month?

0 Answers  

---

when we go for snow flake schema rather than star schema ?

5 Answers   TCS,

---

How can you access your repository with different user profiles?

2 Answers   TCS,

---

How do u get requirement from the client? in what format?

1 Answers   TCS, Wipro,

---

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,

---

what is Scope of Analysis

8 Answers   TCS,

---

how to do Ad-hoc reporting ?

6 Answers   IBM,

---

what will be the contents for a functional requirements specifications

0 Answers  

---

Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

2 Answers   iFlex,

---

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  

---

what is meant by scorecards?

2 Answers   TCS,

---