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.

Explain what are the steps to be taken to schedule the report?

1057

---

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4265

---

What is difference between custom hierarchy and report based hierarchy?

955

---

Explain how we drill up week to month?

1048

---

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3026

---

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2399

---

Explain what are the measure objects?

940

---

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

978

---

Explain when to use local filter and when to use global filter?

1309

---

Explain how many universes can be created in a project?

1019

---

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3417

---

What would you consider as your biggest achievement and why?

969

---

When we use aggregate awareness function in designer?

911

---

Explain what task is 98% of the required work of a business analyst?

1028

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1062

---