CODEWITHSUNDEEP
hana-studio
SimonB
SimonB

Reputation: 1055

HANA Calculation View Filter

Ok so I feel like a numpty asking this, but ..
How do I apply a filter within a calculation view ?

My view has 1 source table, an Attribute View.
I have added the attrib view to a Projection.

Then I've been searching everywhere to apply a simple filter. How can this be so hard to do work out ? I must be missing something.

UPDATE ok, so according to someone else (not in my company), I should be able to simply goto to projection node, right click on a column and 'Apply Filter'.

Unfortunately that option does not appear in my context menu when I right-click.

Any ideas why this might be ??

Upvotes: 1

Views: 4836

Answers (2)

Prasanth Kumar Diddi
Prasanth Kumar Diddi

Reputation: 277

You could click on the projection node And on the Output pane to the right, scroll down to the Filters > Expression node.

Double-click on the Expression node to write a complex expression based on the columns of the projection node's context.

Upvotes: 0

SimonB
SimonB

Reputation: 1055

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.

Upvotes: 2

Related Questions