Problem setting the dataset parameters

Question

Hi, 

I've a large database with almost 500 million of records and in the dataset i'm trying to set some parameters to make this more specific and avoid all the records.

The problem is that when i hit PREVIEW on the dataset top bar it doesn't show any results so i don't know where is the error 

My parameters are:

And this is my query:

SELECT * FROM "public"."dashboard_energy_tuc_001" as "tuc"
WHERE 
tuc.name in ($P{param_name}) and 
tuc.pop_nuts_level in ($P{param_pop_nuts_level}) and
tuc.topic_type in ($P{param_topic_type})

FYI: i have followed all the documentation carefully, so i think i'm not missing anything from there

Some help would be great!!

Thanks a lot.

Comments

In addition to this,

I'm wondering how in the cockpit i would be able to change the values of the parameters. 

For example, if i set the defalut value of 'param_pop_nuts_level' to 5 but later i want to show different data, how this would be done??, can the user change this parameter?? . 

I've tried to change the values of the parameters in the 'Data Cockpit Settings/ Datasets' but always shows an error saying unable to load data from the dataset in the widget. 

Sorry, in the documentation this is not specified.

---

FYI: I've just set a LIMIT of 1000000 on the query but it DOESN'T load the data neither. I don't know what else to try

---

PLEASE, CAN SOMEBODY GIVE ME AN ANSWER OR HELP ME WITH THIS???

IT IS VERY VERY IMPORTANT FOR MY WORK 

Answer 1

Hi @kmorabul,

I got the same problem with the preview on the dataset due to the resolution of the screen. I solved it zooming out. Doing this, I could get the list of parameters on the right, modify them if needed and execute the query.

Regarding the usage of the parameter in the cockpit, I am doing it through Analytical Drivers (I think it is explained in here https://knowage-suite.readthedocs.io/en/7.2/functionalities-guide/analytical-document/index.html?highlight=parameter#association-with-analytical-drivers).

Comments

Hi shrndz,

Thanks a lot for your answer first of all.

I've tried to use the analitycal drivers but i'm very lost when trying to make this work in my cockpit.

The problem is that in the documentation the process is explined in different parts so is not easy to follow. I can't understand how to create a LOVs from a dataset with parameters, etc. Is so confusing.

Can you please explain me which process did you follow to be able to choose the parameters inside the cockpit?

At the end, what i'm looking for is that the user can select the parameter in the cockpit.

Regards.

---

Hi kmorabut,

First of all, I create a LOV as specified in here: https://knowage-suite.readthedocs.io/en/7.2/functionalities-guide/behavioural-model/index.html?highlight=analytical%20driver#creating-a-list-of-value

If I need to parametrize the LOV, I set a query-type LOV, not a dataset-type (see https://knowage-suite.readthedocs.io/en/7.2/functionalities-guide/behavioural-model/index.html?highlight=analytical%20driver#parametrizing-lovs).

After that, I configure the Analytical Driver as in here https://knowage-suite.readthedocs.io/en/7.2/functionalities-guide/behavioural-model/index.html?highlight=analytical%20driver#creating-an-analytical-driver.

Finally, inside the cockpit, I configure the driver on the cockpit (see https://knowage-suite.readthedocs.io/en/7.2/functionalities-guide/analytical-document/index.html?highlight=parameter#association-with-analytical-drivers).

Regards,