Hello everyone,
I have a problem with my data import.
I receive the error “SQL query was cancelled because it was running too long (query_timeout 600 seconds)” even if I’ve put in the advanced settings the following lines:
[mondrian.rolap]
queryTimeout = 1200
I don’t think the SQL is the problem because if I execute it inside my DB Editor I receive the results after 4-5 seconds.
What can I do to resolve this problem or maybe do a better analysis?