How to create the parameter in knowage 7.0.0

Question

How to create the parameters in knowage 7.0.0 for MySQL or MySQL, please share small examples

Answer 1

Dear rahuldevne,

do you mean how to create Analytical Drivers and LOVs? If so you can find all the informations about it at this link:

https://knowage-suite.readthedocs.io/en/7.0/functionalities-guide/behavioural-model/index.html#analytical-drivers

The synthax to use a parameter in a query is then $P{parameter} and it is independent from the DB used.

I hope you find this information useful, but if you were looking for something different, please answer again!

Comments

Hi,

     can u please help with default value as  'ALL' in LOV??

---

Dear lucky,

if you have a default value equal to 'ALL' in your LOV resultset you can use a syntax like this in the query: where (column=$P{parameter} or $P{parameter}='ALL').

A second solution could be to use the script section available for each Knowage dataset of type query where you can add Javascript or Groovy code.

I hope this will answer to your question, if not please answer again.