How do I trim spaces from a presentation variable, entered by user in a prompt? I know how to use the trim function, but not sure where to use the function. Is there a way to add this to the prompt itself, or would I trim in the filter?
I would use a SQL filter in the analysis like:
"Table"."Column" = TRIM(BOTH ' ' FROM '@{Variable}')
Federico told you where to use it...
For your question about "is there a way to add this to the prompt itself" it depends ...
Do your users write the value of the variable in a text field? If yes you can't really do anything there .... If the users enter the values by selecting in a drop down list you can of course trim the values in the list (but why not trim them in your DB directly?)
That works great. Thanks very much, Federico.
Yes, it's a text field they are using for input. I do not have access to write to the database directly. Fortunately, considering my current level of skill
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
