Skip to Content
0

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

Mar 28, 2017 at 10:07 AM

95

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

HI,

is the requirement to show only the max date?

grtz

Koen

0
Loed Despuig Apr 02, 2017 at 01:44 AM
0

Hi,

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

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded