I have created a WebI report (SAP Business Objects BI Platform 4.0 Client Tools (version 184.108.40.2064)), on top of a BEx query which was built on top of one multiprovider in SAP BW. Within the report, I am pulling 3 different dates (Date1, Date2, and Date3). Date2 and Date3 are from two separate InfoCubes with Date1 in BOTH of the InfoCubes. Therefore, I was planning to use Date1 as the key identifier to tie Date2 and Date3 together.
Essentially, I want to do the following:
Find the Maxdate of Date1 for each corresponding Date2 fields in InfoCube1. (MaxDate1 =Max(Date1) where InfoCube = InfoCube1)
Find the list of Date3 where the MaxDate1 from InfoCube1 is equal to the Date1 in InfoCube2.
(InfoCube2Date1 = Date1 where InfoCube = InfoCube2)
(Date3List = Date3 where MaxDate1 = InfoCube2Date1)
Find the Max Date3 within Date3List where Date3 < Date2
(MaxDate3 = Max(Date3List) where Date3List < Date2)
The steps above did not work at all. Ultimately, I need to find the max Date3 where Date3 is less than Date2.
Can anyone help?