Answer / babisri

There was a report for me in which I had to show 10 measures in a pie chart.

Solution- I have created a structure in Bex Query and by using the structure I made a new variable in BO which are the 10 sum of 10 measure and used the variable in report to show the 10 measure in pie chart.

Answer / vikram kumar

In my last project for my client, there were few reports which were highly complex since i have used almost all the components of the WEBI in that.
Starting from the FILTERS, i have applied them at the report level to hide some of the data and along with that i have also used Prompt for the end users.
Moving further i have used variables which were hard coded in the report and created few more variables in the report with the help of WEBI formulas. further i have to add Ranking of the objects and then also created sub reports. In the sub reports i have converted the data to graphical form to represent the data. In the charts i have applied filters and linked the sub reports with the master reports with help of hyper link.
i had also written few free hand SQL in the report. Other then this i had set hierarchies and did some complex calculations. I have applied breaks in few reports and in some i have applied sections. I have used sections much with the charts.
It was a Payroll and HR domain project.

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,

---

4.what is repository? types

8 Answers   TCS,

---

how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?

2 Answers   TCS,

---

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

0 Answers   Polaris,

---

How to Analyise 'Join' problem and which method is the best to resolve that ?

3 Answers  

---

Which versions are used in the bo dashboard work?

0 Answers  

---

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

0 Answers   TCS,

---

difference between web intelligence,crystal reports and desktop intelligents

4 Answers  

---

Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....

1 Answers  

---

how do we apply sql query on selected variables?

3 Answers  

---

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

0 Answers   Infosys,

---

GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?

4 Answers  

---