Hi Mates,
I created an analytic view on top of table VBAK and kept a filter on a column SPART. After adding this column into output structure along with other attributes and when i go for the data preview it doesn't return any output. However, if i remove the filter in the view and try - it gives me all the records.
Don't know what's going wrong..even the SQLcode doesn't show the filter with where clause :-(
Secondly, without keeping a filter in the analytic view, if i just show the all output and then adding filter it works. However, when am trying to see the SQL query..dont see the where clause there as well.
Please help.
Hello tilak,
It's working fine from my end. Could you please check the view might be you have done something wrong.
Secondly, when you are applying filter on either is static r dynamic, it will not show you in the SQL query.
Regards,Neha
that seems to be a "feature"... will probably solved in a support package
Hi MIshra,
The filters you apply in views are static. Even though you didn't add the column to output structure(on what you have given filter). The filter should apply to your data preview.
Please activate the analytic view and check the data preview.
Regards,
Venkatesh.