Question Re: Missing filter expression functions in HANA calculation views in Technology Q&A

Missing filter expression functions in HANA calculation views

john_hawk — Mon, 09 Aug 2021 15:21:42 GMT

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

Re: Missing filter expression functions in HANA calculation views

yannmiquel — Mon, 09 Aug 2021 16:01:18 GMT

Hi,

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

Regards,

Yann

Re: Missing filter expression functions in HANA calculation views

pfefferf — Mon, 09 Aug 2021 18:44:42 GMT

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?

Re: Missing filter expression functions in HANA calculation views

john_hawk — Mon, 09 Aug 2021 20:12:26 GMT

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.

Re: Missing filter expression functions in HANA calculation views

former_member612351 — Sat, 23 Oct 2021 04:36:55 GMT

Hi John,

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

Re: Missing filter expression functions in HANA calculation views

john_hawk — Mon, 25 Oct 2021 21:06:28 GMT

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

Re: Missing filter expression functions in HANA calculation views

DotEiserman — Thu, 11 Nov 2021 18:33:13 GMT

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

Re: Missing filter expression functions in HANA calculation views

john_hawk — Thu, 11 Nov 2021 18:55:41 GMT

Hi Dot

HANA DB version 2.00.053.1605092543 , approximately.

John Hawk

Re: Missing filter expression functions in HANA calculation views

DotEiserman — Fri, 12 Nov 2021 05:53:11 GMT

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

Re: Missing filter expression functions in HANA calculation views

john_hawk — Fri, 12 Nov 2021 21:24:48 GMT

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

Re: Missing filter expression functions in HANA calculation views

DotEiserman — Sat, 13 Nov 2021 07:02:19 GMT

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.