0 votes
1 view
Hi,

I have 2 parameter in my cockpit, where

First parameter has 3 value: Report by Inventory Analyst, Report by Item No, Report by Business Unit.

Second parameter has a value depends on First parameter, so if user selects Inventory Analyst it will show them all Report by Inventory Analysts, if user selects Report by Item No it will show them all Item no in second parameter list, same for 3rd option.

Is it possible this type of parameters with analytical drivers and LOV?

It will be appreciated if somebody will help me to solve the issue.

Thank You
Environment Knowage 6.0, Windows 10
asked Mar 1, 2018 in Analytical Driver by priteshgondalia (490 points) | 1 view

1 Answer

0 votes
Hi,
in Knowage it is possible to correlate two parameters.
This means that, given two parameters, the values of the second one are filtered according to the values of the first one.
To do this the two LOVs associated to the two Analytical Drivers (Parameters) need to share at least one column. That column is
the one used for defining the correlation.

Suppose, for example to have these two parameters:

Product Category = {Food, Drink}
Product type ={(Food, Apple),(Food,Bread),(Drink, Water), (Drink, Beer)}

When defining the second parameter ("Product type") in Knowage you can say that the first element (column) of "Product type"
is equal to "Product Category". In this way the user can select only "Apple" and "Bread".

How to do this in practice in Knowage is described in the Knowage Manual (http://download.forge.ow2.org/knowage/Knowage_6.x_CE_Manual.pdf) at pages
109,110.

Regards,
answered Apr 17, 2018 by iiennaco (600 points)
1,554 questions
1,017 answers
2,037 comments
2,568 users