Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Dashboard variable
What am I missing here? This works if I enter one number (e.g., 101), but not a list of numbers. Or is this a limitation of BI?
Thanks!
Ron
Best Answer
-
Possibly try using a 'Choice List' for User Input (instead of 'Text Field').
Be sure to leave the 'Enable user to type values' checkbox checked.
This will still allow users to enter values, but will also give the added functionality for users to search/select from a list of values -- and hopefully alleviate your problem.
Answers
-
Have you looked at the physical query this produces? Go have a look.
-
The physical query? Do you mean the SQL?
"INCIDENT DETAIL DIMENSION"."INCIDENT_NO" IN ('Numbers')
-
Possibly try using a 'Choice List' for User Input (instead of 'Text Field').
Be sure to leave the 'Enable user to type values' checkbox checked.
This will still allow users to enter values, but will also give the added functionality for users to search/select from a list of values -- and hopefully alleviate your problem.
-
why semi-colon and not comma separating the values?
-
As far as I know, you always have to use a semicolon to separate your different values in a dashboard prompt.
As I test it right now (just as a sanity check), that is the case.
For a 'State' prompt on my dashboard, if I enter:
NY,CA
I get no rows
But if I enter:
NY;CA
I get rows for New York and California
-
I was - obviously totally unsuccessfully - trying to make a subtle point of passing a STRING into for an attribute called NUMBER into a column called INCIDENT_NO.
Pardon the screaming but querying WHERE NOSERIOUSLYTHISISNUMERICAL = "Fish" is somewhat <<enteradjectivehere>>
-
Update:
Logical:
SET VARIABLE QUERY_SRC_CD='Report',SAW_DASHBOARD='/users/demo1/_portal',SAW_DASHBOARD_PG='page 1',SAW_SRC_PATH='/users/demo1/00002';SELECT 0 s_0, "PC2"."Time"."Year" s_1, "PC2"."Payment Metrics"."# of Customers" s_2FROM "PC2"WHERE("Time"."Year" IN ('2013;2014'))ORDER BY 2 ASC NULLS LASTFETCH FIRST 65001 ROWS ONLYPhysical:
WITHSAWITH0 AS (select count(distinct T3056."CUST_NUMBER") as c1, T3067."PER_NAME_YEAR" as c2from "CLOUD_TIME_SMALL" T3067, "CLOUD_F_PAID_REV" T3056where ( T3056."TIME_PAID_DT" = T3067."DAY_DT" and T3067."PER_NAME_YEAR" = '2013;2014' )group by T3067."PER_NAME_YEAR")select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3 from ( select 0 as c1, D1.c2 as c2, D1.c1 as c3from SAWITH0 D1order by c2 ) D1 where rownum <= 65001
See it now?
T3067."PER_NAME_YEAR" = '2013;2014' <--- This doesn't make sense
-
Chris,
Technically, the Choice List would work. However, if I had a list of say, 100 numbers, it would tedious to add them in one at a time.
Any idea why it works at the analysis level, but not in the panel?
Thanks,
Ron
-
3153063 wrote:Any idea why it works at the analysis level, but not in the panel?
???
Have you at least once looked at the physical statements and tried to understand what's actually happening?
-
You can enter the 100 numbers quite easily. Just click on the 'search' feature of your prompt dropdown.
Take a look at my screenshots below:
(1)
(2)
(3) You can paste your values in here (no semicolons between values):
Hopefully this helps!
