Ok..seriously..what's wrong with this syntax:
MIN([FM].[Package_name].[date_column_in_fact] FOR [another_column_in_fact])
This is giving me this error:
QE-DEF-0459 CCLException
QE-DEF-0260 Parsing error before or near position: 74 of : MIN([FM].[Package_name].[date_column_in_fact] FOR [another_column_in_fact])
QE-DEF-0261 QFWP -Parsing Text: MIN([FM].[Package_name].[date_column_in_fact] FOR [another_column_in_fact])
Something so straightforward has taken 3 hours of research now.
I am trying to implement : min(date_column_in_fact) over (partition by another_column_in_fact)
Ok, I need coffee. I was using MIN, whereas the function is MINIMUM. It works now!!!
This is resolved.