We are using Pentaho Dashboards (Pentaho v4.8) for a multi-tenant environment. We need to provide SQL list prompts such that they display only the data specific to a particular tenant.

e.g. For User Name prompt, display only the users of the tenant accessing the report.

Any solutions/suggestions.