Cockpit parameters not work

Question

I realized a test cockpit, as part of a POC, containing only one document, a simple table. This only contains data from a single Dataset. I added a parameter to my Dataset, as well as a cockpit level. However, whatever the value of the parameter, I always have the same display and the same data, as if the parameter were not taken into account.

I tried to disable the cache (as explained here https://www.knowage-suite.com/qa/1056/data-refresh-of-cockpit-dashboards-does-not-work?show=1056#q1056) but in this case I have a "Unable to load data from DS_ROUTES" error
Please check dataset & widget config "that appears In the log I have a more detailed message (see here :https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=13560539962708368240) 

If I make a preview at the level of my dataset with no parameters I have the values ​​that I expect.

This point is blocking for the realization of our POC which should allow us to position ourselves on the choice of our BI solution.

Answer 1

Hi,

   you have to associate dataset parameters to the document analytical drivers through the 'Data Configuration' GUI.

Plaease read the Knowage6.x_CE_Manual at chapter 4. My First Cockpit | General Configuration - Parametric sources management (the documentation is available on OW2 Forge at https://forge.ow2.org/project/showfiles.php?group_id=442&release_id=5959).

Comments

It's now ok for parameters but I need use cache. If I remove cache flag I got the error message.

---

Hi,

seems that there is a problem with the execution of the query that should be cached. Which databases are you using (both for source dwh that for cache them)?

Please check the query and the datasource configuration ... Just for a test, you can create a simple dataset (for example without accented letters or with aliases that contain spaces) and use it into a cockpit test.