Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OAC Answers Prompt Passing Truncated String — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OAC Answers Prompt Passing Truncated String

Received Response
15
Views
2
Comments
edited Nov 13, 2019 7:44PM in Oracle Analytics 2 comments

Summary

Prompt is trimming values from a column and passing them, causing Dashboard failure

Content

Has anyone else encountered an issue where values in a Dashboard prompt are truncated, which then causes the Dashboard to fail?
For example, in the column that the prompt is built from I have the value, "Provost & Vice Chancellor for Academic Affairs."
The prompt shows, "Provost & Vice Chancellor for Acad" which I thought was just a display adjustment for the drop-down;
however, after my dashboard kept failing, I reviewed the SQL log and it is actually passing the truncated value. The drop-down is dynamic and not a fixed pixel width. The shortened string also appears in graphs and legends if, for example, I select (All Column Values) and the Dashboard can successfully generate.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!