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
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 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
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,
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!
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
The difference column is a calculation, and I would like to average that row.
We are trying to convert our OAS reports to OAC and one of the parameters in the where clause of the report is what I am trying to make in OAC. I created a calculation as follows and I am trying to put it into a filter . The code validates EVALUATE('GREATEST ( TRUNC ( NVL (%1, TO_DATE (''1/1/2013'', ''mm/dd/yyyy'') ) ),…
Hi , I am calling one parameter in another parameter and it is not working. 1st parameter is showing values, while calling the 1st parameter in second it is not showing any values. Regards, Sree Hari M
