Please be aware of the following:
- Microstrategy is a Reporting Platform that can connect to different underlying data sources (RDBMS, Hadoop, NoSQL Databaes, ...etc)
- "<function()> OVER ()" are SQL Analytical functions syntax supported by selective Databases and not necessary at the same level of support!
Having said, jrajesh61 will need to investigate the ability of his SQL based data source to support these analytical functions!
Just my 2 cents,
Ahmed