we recently went though an upgrade from Denodo 6 to Denodo 7. We followed the migration guide provided by Denodo. All seemed to have worked. Data was flowing and users logging in. However, some users started placing queries that worked just fine in denodo 6 and they don't work in Denodo 7. Analyzing them, we found they were not pushing down to the source the analytical functions they were using. Rank was the first one we found and it was giving us an error. We also found queries timing out for the same reason, the "SUM", "AVG" and other aggregations were being performed in denodo and it would timeout. So, they were not being pushed down either. We checked our data sources both in 6 and in 7 and they look the same; which means that they migrated as expected. We had not made any changes in the data sources of denodo 6 for the push down to work. They worked pretty much on Default mode; as they were created. So, we did not make any changes in denodo 7 either. So, I find very odd that this feature now does not work and our queries are failing.
Any ideas? Any one else has experienced this?