Skip to Content
author's profile photo Former Member
Former Member

Problem in Reporting

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 06, 2012 at 10:11 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 06, 2012 at 10:48 AM

    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 .

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.