Skip to Content
Former Member
Oct 13, 2014 at 04:18 AM

SAP BW : query result display need to manipulated/clubed as of same text


hi gurus,

please have a look of my requirement that seems tough in BI/BW may be possible by using APD or ABAP logic at CMOD

Case Details:

Problem Scenario ;

  1. 1. If query field that is in row level festival days are different in different years as per indian hindu festivals Example. 10 days of RAM NAVAMI period in 2012& 9 days RAM NAVAMI in 2013 then the problem occurs .
  2. 2. Our Requirement is to club both festive days 9& 10 together in the query for example in 2012 there should be one row instead of two in query result for any year for any combination of such festive days having either of 1 days span or 2 or more.

Is there any way to combine result 9& 10 since its description RAM NAVAMI based on some text comparison as is same thing and representing same type of data. In the screen shot query result shown and marked is it possible at Bex level either by CMOD or other way we can do so , we cannot go changes at cube ETL level, query is based on Cube?

Thanks & Regards

satish singh