Passing filter condition values dynamically in sql view

Technical queries
, , , , ,
#1

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

#2

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