How can we restrict a user to write only numbers in the text fields in obiee 12c reports?
What do you mean?
Are you talking about BI Publisher reports? About OBI Answers analysis?
What is a text field in your mind?
its regarding BI Publisher report
a) You didn't answer Gianni's other question.
b) With a "problem description" like that you won't get much in terms of usable answers. What do you mean "write only numbers"? Input validation? For what? A prompt?
force the prompt to be a searchable lookup and selection instead of free-form text ... if you have too many values, then you need additional restricting prompts to narrow down the scope of the final list
example:
if you have 600,00 customers maybe you need a City prompt to narrow the search down to 100,000 then you need an additional one to maybe filter by ZIP Code and now you get 30-50,000 in a zip code and then maybe filtering those by sales rep to get the 10-15 to pick from...
free-form is ungoverned (free of any form)...
And, to keep it simple - i have an Employee ID prompt - which is text field prompt.
I cannot use drop down or choice list as i have millions of employees.
And, employee id values in database are numeric. (which is good)
However, we have few users - who may enter some string values unknowingly in the text field prompt.
Can we have integrate any customization - so, that when users enter any characters other than numeric it should say - enter only numeric values.
My solution to this is to set a presentation variable in the employee ID prompt, say "varID".Then, in the filter of the query, insert: UPPER('@{varID}')=LOWER('@{varID}').In the 'No Results' view, type the custom message "Invalid Employee ID - Numbers Only!"
This only works as a test for unwanted alpha characters, (and maybe only in English?)
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
