1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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:)

Question Posted / mysticbo

Answers were Sorted based on User's Feedback



I need to select the rows based on the latest 'Payment_due_date' column value. Let'..

Answer / rajitha praburam

You can get the required results by using RANK function.

Create an object 'Rank' with Number Data type and the below
select option.

RANK() OVER (PARTITION BY CUST_NAME ORDER BY
PAYMENT_DUE_DATE DESC)

In the report, use report level filter add Rank = 1
condition.

Is This Answer Correct ?    1 Yes 0 No

I need to select the rows based on the latest 'Payment_due_date' column value. Let'..

Answer / rahul

You can achieve this by having a condition.
i.e put payment_date in condition panel-->select operator
as "equal to"-->operand "calculation"-->follow the
steps"select object(payement_date)"-->select function
(maximum)-->Globally-->for each value of one or more objects
(cust name)--finish

Is This Answer Correct ?    0 Yes 0 No

I need to select the rows based on the latest 'Payment_due_date' column value. Let'..

Answer / gs2kumar@gmail.com

Max(Payment_due_date) use this in report level create a variable or in cell.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples

2 Answers   NTT Data,

how can u find the granularity in fact table

1 Answers   iGate,

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  

How will you know the version of Bo using designer?

4 Answers   Tavant Technologies,

Can we do the slice and dice in webintellegence?

5 Answers   IBM,




Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers   Cap Gemini, Infinity, TCS,

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

1 Answers   Accenture,

IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

3 Answers   Accenture,

is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 Answers  

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

0 Answers   Wipro,

wha is the difference b/w merge dimension and combining two different data providers?

1 Answers  

For more Business Objects Interview Questions Click Here
Categories