BICS Dashboard Prompt Containing Data of Format "Last Name","First Name" Returns NULL Value in the Prompt
Last updated on JULY 11, 2017
Applies to:Oracle Business Intelligence Cloud Service - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 14.1 to 15]
Information in this document applies to any platform.
On Business Intelligence Cloud Services (BICS) Dashboards, on selecting the value in a dashboard prompt containing data of format [<Last Name>, <Title>. <First Name>], the below scenario is noticed:
- The prompt returns blank or null value in the selection
- It breaks the value into two separate values
- For example- If there is a Dashboard Prompt Called "Project Manager" and data in it contains the name in the structure - "Lastname, Mr. Firstname", it breaks the value into two separate values "Lastname" and "Mr. Firstname"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms