Hello knowage users..i want to test knowage as open source tool and using it in my research . after installing knowage communtiy 7.4, I plan for :
1- importing csv file with 32 columns and more than 10000 rows as my data input
2- presence this dataset in the integert mariadb 10.2 because i want to make sql querys to analyse the data using subquerys and analytical functions
3- creating metrics and charts with allowed funktionalities dashboard.
so i hope to get answers to the following quetsion's:
1- wich is the best approach to creat hierarcheal from my input data in order to apply drill finctionality (if possible in community version of knowage) inside the dashboard?
2- is it better to seperate this data inside knowage into different tables and creating schema and Association inside it? and how to make this?
3- As i know common table expression (cte) querys are not existed inside this mariadb version, how to handle this problem?
i thank u all for your answer.
