Skip to Content
0
Former Member
Feb 11, 2011 at 01:18 PM

Query offset variable issue

22 Views

Hello,

We have an issue with a query with offset variables that abends in the web or Xcelsius (where it ultimately is targeted for) but runs o.k. in Analyzer. The original query displays KFs with two years of data by month with offsets on the date ranging from -1 to -24. I tried a query with only one KF and changed the offset and had mixed results, sometimes it would run and other times it would abend. With offset -24 and -20 it ran o.k. with -21 through -23 it cancelled.

Any thoughts or recommendations would be appreciated.

Thanks,

Rick