on 09-08-2014 2:32 PM
I have a Calculation View like
and Flag=1 in Projection_1 and Flag=2 in Projection_2 (both introduced in the Projection as a Calculated Column).
What I now want to add is some filter for result, e.g. Flag=1 .But somehow I don't find a mean to create a filter. On the Aggregation Level there is no item:
nor in the Union. Since I have seen screenshot with applying Filter-Expression on the Aggregation Level, I wonder how this is done. I'm using SPS08 - perhaps this was possible in prior versions, and now not?
NOTE: I'm not looking for the SQL-script, I'm curious how this could be done on the graphical level. With the search here I wasn't neither successful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
On the projection nodes this was never the problem. My question was about if the filtering is possible on the aggregation level? On the Union level not. And on the Aggregation level it seems that this could be done only, if the Aggregation Node is not the last before the Semantics. (That's what I figured out up till now, although I have no clue, why on the last this isn't possible.)
Noteworthy is additional that on the Aggregation Node I cannot access to the same Filter Dialog as you have shown. If I double click on the Aggregation Node on the Filters everything therein is read-only cannot be changed. Only in the Apply Filter-Dialog.
Any ideas, why there are these two limitations? (Tested with SP08.)
Hi Roland / Fernando,
One thing about last node is that it's a representation of output, it's node a real aggregation or a real projection but a representation similar to make easy to manipulate/rename before went out on semantic. Is also the only one that you can switch between projection / aggregation.
This last one wasn't here since SP3 or SP4 if I remind well...
About the beauty visualization of filtering against the box to direct edit expression is the same since ever. Initially you can do it beaty but if you want one time to edit without the wizard Studio alert you that after you confirm the only way to maintain is manually through expression.
Of course, if you start directly on expression you will not see the option to filtering with wizard.
Regards, Fernando Da Rós
Hi Roland,
About the where you put the filters, Fernando have the correct mind set to filter as earlier as possible, because as a rule of tumb you are reducing the size of datasets which is less memory and less CPU to carry on payload.
* One observation is that HANA does a good work to take a filter on upper nodes to lower nodes but this will not happens always... depends on your model.
Regards, Fernando Da Rós
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.