Filter not in MQL

[tgrahl]

Hallo,

thanks for the great work on Saiku Adhoc.
Have a question, so will post it here as an "issue", but its just a question.

If I add a filter(Country=US) in the Adhoc UI, the executed mql and sql does not contain the filter. But at the same time the result report is filtered, so assuming the filtering is happening in Saiku.

What is the reason why the filter is not passed to the mql? As with big data values the database is taking some strain, even thought the actual filtered report is only a few rows.

Thanks,
Thorsten

[Mgiepz]

Hi!
The filtering is done through a parameter that is passed from the report
to the data-access layer (CDA).
The mql should contain a parameter (placeholder) for that value. There
is no filtering on the result done
in saiku, it all happens in the database.

Am 06.02.2013 13:01, schrieb tgrahl:

Hallo,

thanks for the great work on Saiku Adhoc.
Have a question, so will post it here as an "issue", but its just a
question.

If I add a filter(Country=US) in the Adhoc UI, the executed mql and
sql does not contain the filter. But at the same time the result
report is filtered, so assuming the filtering is happening in Saiku.

What is the reason why the filter is not passed to the mql? As with
big data values the database is taking some strain, even thought the
actual filtered report is only a few rows.

Thanks,
Thorsten

—
Reply to this email directly or view it on GitHub
#177.

[tgrahl]

Hi,
thank for quick reply.
Did some further debugging, and it does filter the SQL if the filter is of STRING type, but when INT the filter is not in the mql or in the sql.
So not sure if the issue with CDA or Saiku, but issue is probably related to #165 so could close this issue.