Hi, Folks!
I've recently upgraded my Knowage from 7.2 to 8.1.
When I tried to execute my Analysis and dashboards, no data was being retrieved. There was no error in the logs. When I opened my datasets, i realized that knowage was not recognizing the profile attributes (and almost all of my datasets use those profile attributes, and all of them were working ok on Knowage 7.2). I'm using the correct syntax for them, as for example: Select count(*) from base where sigla = '${base}'
As a side note, when the user click the help icon for the "Edit Query" text area, the following content is shown (and I guess it's wrong)
"In a datasets the user can insert parameters or profile attributes, single or multi value.
The correct syntax to insert a parameter is $P{parameter_name}.
The correct syntax to insert a profile attribute is $P{attribute_name}.
Remember that for any parameter added to your dataset, you need to add this parameter in the parameters table."
I've ever used the syntax ${profile_attribute_name} for profile attributes in older Knowage versions, but the help text explains differently (Did the syntax change? I guess it didn't, cause I tested with both syntaxes and nothing worked)
Any help or workaround?
Thank you, very much!!
Giovanni
