Skip to Content
0
Former Member
Nov 08, 2006 at 07:45 PM

InfoPackage selection offset with OLAP variable

234 Views

Hi Bw Gurus,

I have a requirement to load ODS with full upload everytime but in order to reduce repeated loads I am trying to use a DATE field which is not part of communication str. as a selection critera in InfoPacakge.

I changed DS to include this field avaialable for selection and It's working fine when I input date to and from values hard coded in InfoPackage.

Further I am trying to automate this InfoPackage scheduled weekly and I need to include date offset value for this DATE field to load for additional last 2 weeks every time to capture changes for already loaded data.

I have created OLAP customer exit variable having Date interval for Date starting from last 3 weeks to Current DAte and included in InfoPackage selection for DATE field but it's not working. By the way if someone can explain what's meaning for two columns there for TYPE(Variable change to selection.....) and detail for type.

Any clue for reason or any other way to accomplish this requirement?

Thanks in advance,