computed columns not working

ReportServer (EN)
1

Hi

I am trying to create a computed column like this

EXTRACT(EPOCH FROM (response_timestamp - timestamp))

but I get the following error message:

Could not tokenize: EXTRACT(EPOCH FROM (response_timestamp - timestamp)). Problem occured at EXTRACT(EPOCH FROM (response_timestamp - timestamp))

I tried to find the file computedcolumn.cf but I dont have it anywhere.
However I noticed a couple of tables in reportserver database

rs_computed_column
rs_computed_column_a

Do I need to insert the functions here ? should the function name be in expression column?

Thanks in advance

2

Hi,

the computedcolumn.cf is in the internal filesystem (Administration module) under /etc/dynamiclists.cf. Remember to reload the configuration after changing by using config reload on the terminal.

Cheers,
Thomas

ps. do not try to make any changes on the database level. This will most probably cripple your installation.

3

Thanks Thomas,

for some reason I thought that was a file in my disk filesystem.

i just cant figure out how to execute config reload…
is it a bash script somewhere?

4

in ReportServer you can open a terminal by pressing CTRL+ALT+T. There issue the command.

Cheers,
Thomas