- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
I have problem - to avoid separately computed aggregates calculated on some level and joining them back I want to use windowing functions which are now implemented by many database vendors.
I have tried in AC using expression like
max(@eff_dt , PartitionBy(@col1,@col2,@col3))
which parses well but unfortunately it was converted to something like
max(W0.tsEff_dt , PARTITION BY W0.dCol1 , W0.sCol2 , W0.sCol3)
which of course result in error
and it should be like
max(W0.tsEff_dt) over PARTITION BY W0.dCol1 , W0.sCol2 , W0.sCol3)
is any way to get this ?
regards
Solved! Go to Solution.
Views
Replies
0 Likes
Total Likes