COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: BenziD on 26 Nov 2015 01:47:05 PM

Title: lag or analytics function in FM
Post by: BenziD on 26 Nov 2015 01:47:05 PM
Hi
my data has three columns product id, version, start date (number-yyyymmdd)
i need to find the version end date.
i dont see how to use oracle-lag, oracle-analytic function or cognos-running_ XX  in FM, all of them work on sorted the data, and FM isn't sorting the data.

thank you
B:-[