Calculation View Filters

[Former Member]

Given that my Googling so far has not provided the answer I've been looking for ... the chances are that I'l trying to do something that should not be done !

(I'm a SQL Server developer trying to get used to the HANA world)

But let's see....

I have created an Attribute view - all good.

Now I want to create several Views ontop of that.

Each new view will have different filters to produce specific results.

So I created a Graphical Calculation View.

Added my AV to the Projection.

Added my output columns.

But for the life of me .... I cannot figure out how to apply a filter !?

I've googled 'HANA Calculation View Filter' and such variants;  but nothing relevant in results !

I have right clicked everything in sight to find a context menu option; but nothing.

What I have found are references to 'Parameters'.

Some of these references indicated that they produce a user prompt - and that is no use in my situation.

What I have managed to do, is apply a filter via the 'Semantics' component of the Designer.

This successfully filters results when viewed in the 'Open In Data Preview" ;  however....

when I call the data from SAP Information Steward .... the data is NOT filtered.

I am obviously missing some basic concept in my understanding.

Yet after hours & hours of reading guides and articles ... noone seems to explain from a high level what the options are.

Any advice, pointers, references  welcome !

Many Thanks

[former_member182302 · Accepted solution]

Hi There,

You have 2 options :

1) Variables -- These can be added at the semantic level on the attribute as you mentioned alredy

2) Input parameters ( Filters at projection level using Expression )

Example you can see in the below blog:

Have a look on this as well:

As you are mentioning the filtering is happening from Data priview in HANA and when you are calling from SAP Information steward it is not happening.

What you might want to check is if variables are supported or Input parameters can be mapped from this tool.

Also in this are you are getting any prompt for you to enter values?

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Hi Krishna,

Thanks for the references.

Whilst I read them, I can answer some of your questions....

The client tool (that is going to read the data) does not support parameters or suchlike.

It is performing a simple 'Select f1,f2 from tablename'.

This is why I need 'hardcoded' filters on the calculation view.

[former_member182302 · Accepted solution]

If you wanted hard coded static filters. In the projection node, you can right click on the column and choose "apply filter" and apply it

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

That would be nice ... but that option is not shown.

Let me see if I can get a screenshot....

[former_member182302 · Accepted solution]

It would look something like this.

1) Goto projection node

2) Right click on the column you want to apply filter

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Thanks.

However, if you look at my screenshot....

I am in the projection node.

I have right-clicked, and the context menu is shown in the screen-shot.

There is no option to 'Apply Filter'.

Any Ideas ?

[former_member182302 · Accepted solution]

Which version are you using? Also can you check in the data foundation level of your view itself.  You should find that option there atleast

[Former Member · Accepted solution]

Version: 1.0.7300

Build id:  389160

And yes, I can Apply a Filter in this fashion within an attribute view.

I don't want to do it at that level though  !

Many thanks for your support !

At least now I know what I 'should' be able to do

[RashmiAcharya · Accepted solution]

Hi Simon,

The projection node immediately below Semantics will not give you Apply filter option in context menu. Please add one more Projection node and add your table in that and then try to Apply Filter from context menu option.

Regards,

Rashmi

[Former Member · Accepted solution]

Ahhhhhhhhhhhh !!!!!!

So simple.

End of my nightmare.

Thank you SO much 

[Former Member · Accepted solution]

Rasmi found the answer.... but I still appreciate your help and for engaging with my problem.

Thank you for your time and efforts

[former_member182302 · Accepted solution]

as Rashmi already mentioned below .. small miss

[former_member229185 · Accepted solution]

What is the logic behind this? I don't understand why this option wouldn't be available in the first projection node.