I want to replicate the logic of Oracle analytical functions in Cognos FM 10.2.2. I was able to figure out that I can use the "FOR" function to do the "partition by" piece. Now how do I implement "order by" part of it in that expression?
Example oracle function: min(date) over (partition by field1, field2 order by field 3 asc)
Cognos version of oracle function: min(date for field1,field2)
How should I implement the bolded "Order by field3" in Cognos FM?
Thanks for your help.