SAP HANA Cloud – Incremental Refresh is not workin...

mrgr · ‎03-17-2021

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 adapting our datasets to access HANA without MDX and, for some cases, we use incremental refresh.

We are using HDBODBC:

And the connection works perfectly:

Then we query one view (Calculation View) and it works ok:

And we check the “Native query” to be sure the query folding is properly working and yes, it is:

So then we add a filter on a date field preparing what will be part of the incremental refresh:

And when we check again the “Native query” it’s not working any more. So there is no query folding (nor Incremental Refresh).

We are using this same functionality in HANA 1.0 (HANA Service on Neo) and it works ok but in HANA 2.0 (HANA Cloud on Cloud Foundry) it doesn’t.

Our HANA Client (ODBC) is updated to version 2.06.61 and it works ok for any other type of access that doesn’t require query folding.

As soon as we add a filter the “Native query” disappears.

Do you know if there is any other way to avoid loosing the query folding in HANA 2.0 when adding a filter (so it can be setup the incremental refresh)?

Thank you,

Fernando

Icey · ‎04-05-2021

Hi @mrgr ,

Have you found a solution?

Best Regards,

Icey

Icey · ‎03-19-2021

Hi @mrgr ,

What's the data type of your date column? Is it "Date"? Please try to set as "Date/Time".

In addition, does this issue occur with all data from SAP HANA?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mrgr · ‎03-23-2021

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