Answer / sami

use where clause in the function bar, or 2nd method is to
create a new variale and put a filter by showing the data
for particular months

Answer / arjunreddy

first we have to create one variable like quarter based on month
Quarter :: if((<month>) inlist ("1","2","3") then "Q1" ElseIf((<month>) inlist ("4","5","6") then "Q2"
ElseIf((<month>) inlist ("7","8","9") then "Q3"
ElseIf((<month>) inlist ("10","11","12") then "Q4" Else <Month>

then we can apply break function on quarter.

Answer / vips

there is value based Break available in webi apply value based break at month no 3

Answer / tim

You need to create a universe based date dimension object
based on the column's date and then apply the Quarter
function (or DBMS vendor equivalent) in order to split the
values of the LOV up into Quarters. Once you can see the
date values in quarters, simply section break the webi
report using your newly created dimension.

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

---

1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers   TCS,

---

how we improve the performance of report and universe?

4 Answers   Accenture, IBM,

---

in sap bi we have wad, then why we go for sap bo

0 Answers  

---

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

---

What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?

3 Answers   Perot Systems,

---

if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

1 Answers   TCS,

---

can i use stored procedure in webi?

4 Answers   CTS, Wipro,

---

What is the difference between absolute and relative div positioning?

0 Answers  

---

how to do Ad-hoc reporting ?

6 Answers   IBM,

---

How would you format some text using css to be verdana and bold?

0 Answers  

---

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

---