display value for this code is unavailable

Robert -90313

Summary

display value for this code is unavailable

Content

Hello there,

I am using OBIEE 11g and am pulling data from an SQL 2008 Analysis server. I am trying to get a date prompt to work with it, but get a "display value for this code is unavailable" (see screen shot below).

the SSAS is storing the date as a string (this is because there is an 'NA' and a 'empty' date value in the field I'm trying to use, in the RPD I have changed the data type to DATE.

I have tried the following:

in the RPD I've right clicked on the database -> properties then selected the "features" tab and have tried changing the DATE_FORMAT value from the default of yyyy-mm-dd to various formats such as yyyy/mm/dd, dd/mm/yyyy, mm/dd/yyyy all with the same result. (perhaps this is an important detail. I made these changes in online mode, checked in, saved, and reloaded server metadata each time. I have not done this in offline mode and reloaded the RPD)

I did manage to get some default dates to work if I entered the date like this for the default date prompt:

[WO Date - Start].[Time].[Date].&[20170803]

however once I use the date picker to choose a different date then I get this:

I also tried changing the date format in the analysis which had no effect.

Has anyone encountered this before? Is there anything I can try that may sort this out? Also please let me know if maybe this question is best asked in a different space.

Thanks for your help.