COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: snehal on 03 Aug 2008 09:54:39 PM

Title: Need help to implement PARTITION BY statement in Report
Post by: snehal on 03 Aug 2008 09:54:39 PM
Can anyone give me solution for this question.........I have a SQL query like  MAX(NVL(a.DueDate,'01-JAN-00'))Over (PARTITION BY b.StateName,b.CityName,TRUNC(b.ID))Max_DueDate  which is in the Select Statement...Now I want to Implement this in the Report studio By using the Model.So please let me know the solution for this ....


Thanks,
snehal