Problem in Reporting

[Former Member]

Dear Gurus,

I got a requirement like below.

My Cube has the data like below

TRANSACTION PARTNER NO STATUS DATE

10000 P1 SUBMI 1/1/2012

10000 P1 RESUBMI 1/2/2012

10000 P1 REJECT 4/1/2012

10000 P1 APPROV 3/2/2012.

MY CLIENT WANT THE REPORT OUTPUT AS

TRANSACTION PARTNER NO STATUS DATE1 DATE2

10000 P1 SUBMI 1/2/2012 3/2/2012

10000 P1 RESUBMI 1/2/2012 3/2/2012

10000 P1 REJECT 1/2/2012 3/2/2012

10000 P1 APPROV 1/2/2012 3/2/2012

LOGIC FOR DATE1: LATEST OF SUBMITTED & RESUBMITTED DATE.

LOGIC FOR DATE2: LATEST OF REJECTED & APPROVED DATE.

Thanks& Regards

Rams Thota

[Former Member]

Hi,

If date is defined as key figure then u can work out this way. Create four RKFs restricted with each of the status types. Then Create two formulas. In formula use if else as perrequirements on the RKFs defined .

[Former Member]

Hi,

As per ur requirment ,

Use selection in query structure

under the selection select date1 and restrict status = RESUBMI, SUBMI

Again create 1 selection for date2 and restrict status= APPROV, REJECT

hope it ll help u.

Regards,

Kavita C.