nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Dashboard variable

3153063

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

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Have you looked at the physical query this produces? Go have a look.

3153063

The physical query? Do you mean the SQL?

"INCIDENT DETAIL DIMENSION"."INCIDENT_NO" IN ('Numbers')

Chris Arnold

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.

Thomas Dodds

why semi-colon and not comma separating the values?

Chris Arnold

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

[Deleted User]

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>>

[Deleted User]

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 ONLY

Physical:

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

3153063

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

[Deleted User]

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?

Chris Arnold

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!

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders