Skip to Content

Nearest greatest date from the date field based on the date given in the selection screen in BW

Jul 27, 2017 at 12:31 PM


avatar image
Former Member

scn.pngHello All,

For example :

For one Security field there will be multiple dates but in the report I need to show only the nearest greatest date which is closer to the date given in the selection screen. For clear clarity please look at the screenshots provided in the attachment.

On top of cube ,I built BEX Report and WEBI Report .

So to show the data according to my requirement , how should I get it ?

Should I go for CMOD in BW ,If yes , HOW ? (or)

Can I do in WEBI , If yes , HOW ?

scn.png (24.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers