Finally I have solved the problem. Causing a problem was protected filter for OpCo is not null which was passed from Performance Tile. When I have removed protection, everything is working fine. Looks like in such case protected filter is passed as only one to target report, and is overwriting is prompted and variable in…

Finally I have solved the problem. Causing a problem was protected filter for OpCo is not null which was passed from Performance Tile. When I have removed protection, everything is working fine. Looks like in such case protected filter is passed as only one to target report, and is overwriting is prompted and variable in…

Date from CAST variable and concatenating was not recognized when used in Filter section. BTW, problem is not in the date. Update: I have created additional analysis, where I have removed all date filters using to_datetime, changed KPI from Standard to YTD, and still same error. Which confirms that something is wrong with…

You need to explicitly convert the result to a datetime, ensuring that you concatenate hard coded elements for all of the datetime that are not present in the original.If this is further converted to a date then again make sure the conversion is done explicitly not implicitly.I have done this with cast, rather than…

I guess Date.Month (YYYY / MM) is a text. To have a date for it we are using to_datetime hidden function. Filter section is not displayed when there is error in the target report. Unless I should add it to the report from which we are opening Action Link. But I guess this one will not tell too much.

Date.Month is in format: YYYY / MM There is nothing to examine, as in Administration -> Sessions, there is no this report if error persists. Not sure what do you mean in last point, as all reports on the dashboard are working fine with Prompt selection. Only problem is with passing OpCo as variable to report from action…

Hi, Dashboard is created that way, that we have main page with dashboard prompt, and other tabs which has reports filtered based on prompt. Mandatory fields are Month and OpCo. Month is default to previous month, and OpCo need to be selected by user. So user, is selecting filter values, pressing Apply and click Tab which…

Clearing cache didn't help

But this Bypass option can't be saved, right? How to implement it correctly?

Thank you. I guess that in first suggestion WHEN for All Column Values is not needed, as null will handle this. In second option I think that THEN is missing in case What I have found, CASE is not needed. But also tutorials are wrong. Filter can look like this: "CC - Business Unit"."Business Unit - OpCo" IN…

Hi, Not removed but not filtering the results, asking for all entries. Still not sure if I understand your suggestion. How would you like to modify CASE? I do not see option to check Null/Not Null in case.

What do you mean?

2. Yes, it is SQL filter. 1. I have checked in other reports SQL from Monitor. If in prompt you will select All Column Values for "CC - Business Unit"."Business Unit - OpCo", dimension is not included in SQL send to database, which means that it is not filtered and is asking for all entries. Based on That I do not see an…

Syntax was not fully correct. Below is corrected: "CC - Business Unit"."Business Unit - OpCo" IN (CASE '@{PV_SELECTEDOPCO}' WHEN '(All Column Values)' THEN '(A,B,C,D)' ELSE (@{PV_SELECTEDOPCO}['@']{A}) END) Anyway, if we select All Column Values in the prompt, then it is not filtered at all (not added to the SQL). Not sure…

Works for default/ error for default - I meant Results tab in report itself. Works from dashboard for single and multiple selection - I meant single and multiple selection in the dashboard prompt for testing I can't check SQL for All Column Values, as it is not generated, and error is generated before sensing SQL. I also…

I have tried different options. ('@{PV_SELECTEDOPCO}['@']{A}') - works for default, but no data from dashboard as too many speech marks ('@{PV_SELECTEDOPCO}[@]{A}') - works for default, but no data from dashboard as value will be empty (@{PV_SELECTEDOPCO}['@']{A}) - error for default, Nonexistent column: A, but works from…

I set it the same as it was mentioned in the article which you have linked. I have updated it with your suggestion: "CC - Business Unit"."Business Unit - OpCo" IN ('@{PV_SELECTEDOPCO}['@']{A}') but now there is two much speech marks in SQL: ("CC - Business Unit"."Business Unit - OpCo" IN ('''A'',''B'''))

I have tried this using SQL in Filters: Works when we check Results, but executed from Action link returns this error:

@Robert First things first. How to set scope of presentation variable? Is it based on the dashboard prompt scope? You are right, I can set it '@{PV_NAME}{Default}', but it will pass only single value or string will be concatenated into 'A,B,C' which do not exist in data, and I would like to have it as 'A', 'B', 'C'. I'm…

@Robert, Could you please provide some more details? I'm not familiar with Go URL option (does it mean to create link using go to web page and use parameters in it?).