Passing filter condition values dynamically in sql view

Hello Helical Insight,

We are using Helical Insight enterprise edition 4.1 GA. We have have a requirement wherein we need to pass values dynamically to the
SQL where clause, how can we achieve this. Just to give an example we need a top N kind of report, wherein the N will always come as a value from the end user. So basically we want to pass the filter value which user is selecting to view directly. Can this be done?

Thank You,
Jam

Hello Jam,
Yes, it is always possible to pass on the values, this is where dynamic views are helpful.
Please follow this link for reference:

https://www.helicalinsight.com/dynamic-query-view-in-metadata/

Thank You,
Helical Insight