Missing filter expression functions in HANA calculation views

[pfefferf]

Hi Gang,

All of the filter function expressions (like Date and String) are missing from filter expression functions in HANA calculation views - even ones which previously worked! I can execute old views, but not find new expressions to use in filters.

Ultimately, I suspect a Basis problem, but Note search is not providing useful results.

Does anyone know of an SAP Note on point? Or better keywords to use in my search?

Thanks,

John Hawk

[pfefferf]

What tooling you are using HANA Modelling Tools in HANA Studio, Web IDE or BAS? In case of HANA Studio, did you update to the latest version?

What SAP HANA version you are using?

XSA or XSC?

[john_hawk]

We are using Eclipse 2021-03 and HANA Studio. This is not a tools issue. Some process has stopped and I need to tell my Basis guys where to look.

[DotEiserman]

Hi John,

I've only experienced these problems when the HANA DB version/revision was updated but my client tools not. Which HANA DB version/revision are you on?

Thanks

Dot

[john_hawk]

Hi Dot

HANA DB version 2.00.053.1605092543 , approximately.

John Hawk

[DotEiserman]

I like the approximately. 🙂 Check for me that your HANA studio version is one of the green higlighted ones.

[john_hawk]

Hi Dot

Well, that might be the problem. I am using Eclipse 2021-03. Did not know SAP was still pushing HANA Studio.

Thought we were in an Eclipse to SAP Web IDE world.

John Hawk

[DotEiserman]

Yes, that is true, if you're using HANA XS Classic then HANA Studio is still your friend (it's basically Eclipse), if you're running HANA XS Advanced then you have to use the WEB IDE.

[former_member612351]

Hi John,

Did you resolve it? I am also facing same issue. can you please share if you have any information?

[john_hawk]

Sorry, no. Still working around the issue using calculated fields for string manipulation and if statements followed by a a downstream filter. - John Hawk

[yannmiquel]

Hi,

Maybe you should open a ticket? I can see/use them in BAS / HANA sp05 (Europe) right now.

Regards,

Yann