I just did a quick test on mondrian(3.3 version)-redshift connection. I have been able to get my cube working so far. Redshift is based on postgre 8.0...and mondrian already has support for postgres dialects, so this is as expected. But I have seen some commits in the mondrian master branch @ github, re redshift, like a new calss "RedshiftDialect.java".
So I am just wondering, what sort of unseen issues should I expect from using mondrian 3.3? I know, redshift has many unsupported postgres types and features, so they could be bottleneck at some time. But I really need to know if mondrian needs any tweak, or I can just use the existing version or I need to build the master branch source?
Note: Pentaho EE latest claims to have full support for Redshift. I check the mondrian version @ 4.8.1 GA release, it uses mondrian 3.5.6 which lacks the RedshiftDialect class.
So, could you please put some more light over this?