Answer / prakash

Hi,
While creating the Reports mainly we face
syntax/Computation/multivalue/Objects are not compatible
related errors.

Answer / babu

when creating reports mainly we faced
multivalue,#context,Datasync error and incompatability
errors also

multivalue : it means passing more than one value into
single measure object then it will occur
Sol:goto object properties set Sum in the list box and
export the universe.

Answer / raj

when we creating reports mainly we faced this type of errors..

#Multivalve: Occurs when you place a formula that returns more than one value in a cell that outputs. Or if a single cell is trying to display multiple values. Or occurs when you don’t set sql aggregate functions for a measure object in universe designer.

#Syntax: Occurs when a formula references an object that no longer exists in the report.

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

#Incompatible and #Context: Occurs if you try to include objects from 2 Queries/contexts which does not have any relationship or tables which are not linked then #Context appears in case of measures and #Incompatible appears in case of dimensions because it has a non-existent calculation context.

#Data Sync: Occurs if the dimensions from different data providers are not synchronized or merged through a merged dimension. It also occurs when you place a dimension from a different data provider in a block containing dimensions from another data provider and 2 data providers are not synchronized through a merge dimension.

Explain the difference between compatible and incompatible objects?

0 Answers  

---

When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,

---

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 Answers  

---

why less number of records in loop? why more number of records in traps?

1 Answers   Wipro,

---

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  

---

---

why we use aggregation in lower level

1 Answers   TCS,

---

Difference between scope of analysis in webi and in deski?

1 Answers   CA,

---

what is diff between Decode and case ? Give some Example?

2 Answers  

---

can i use stored procedure in webi?

4 Answers   CTS, Wipro,

---

Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers  

---

Can Bo generates the Report from the cubical data Explain?

0 Answers   Wipro,

---

Why do we need metrics and sets?

1 Answers  

---