SAP HANA Cloud – Incremental Refresh is not working

Hello, We migrated our HANA database from HANA Service (HANA 1.0 in Neo) to HANA Cloud (HANA 2.0 in Cloud Foundry) and from this version it's not possible to use MDX any more. So, we are adap...

Need Help

mrgr

New Member

5 years ago

Hi Icey,

I'm sorry, I replied but seem it didn't get published (my bad for not checking).

The data type is Date/Time and the incremental refresh is working ok in this same way in HANA Service (Neo). But it doesn't work in HANA Cloud (Cloud Foundry).

This week I had a call with some technical people from SAP in the HANA Cloud area and they told me to check this with Microsoft people because from SAP they didn't find anything that could explain this problem.

But I'm not sure, because we are using a new HANA ODBC driver (version 2.06.61) and maybe there is the problem. But, in part is Microsoft's team responsability to assure compatibility if we assume there are no error from the ODBC driver.

I think this could be a quite technical problem that won't be solved easily. Meanwhile I will have to evaluate other possiblities (using SAC instead of Power BI, using other db instead of HANA, etc).

Thank you,
Fernando