Skip to Content
avatar image
Former Member

How to derive the two column values in a single row in SAP BI BEx report

Hi Experts,

I have requirement to create BEx query as below, please help me on this.

Current report:

Notification | Local date | System date | Total

01111 28/03/2017 27/03/2017 2

Desired/required report:

Notification | Date | Total

01111 28/03/2017 2

27/03/2017

Both local and system dates should be in a single column for the notification.

Regards,

Vijay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 28, 2017 at 10:14 AM

    Hi Experts,

    I have requirement to create BEx query as below, please help me on this.

    Current report:

    Notification | Local date | System date | Total

    01111 28/03/2017 27/03/2017 2

    Desired/required report:

    Notification | Date | Total

    01111 28/03/2017 2

    27/03/2017

    Both local and system dates should be in a single column for the notification.

    Regards,

    Vijay

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02, 2017 at 01:44 AM

    Hi,

    What should be the total value under the SYSTEM DATE? I think you can do this in transformation level.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded