OTBI Presentation Variable Date Prompt no Longer Functions Properly
Summary:
Recently all our absence reports within our Production environment that use a Date Presentation variable as a prompt have stopped producing the required results. The Date prompts are being ignored. Ironically the issue doesnt happen in Dev2. Both environments are the same version and we have taken the working analytic from Dev2 archived it across to PROD but still the same results. We tried logging an SR with Oracle but have been told to log the issue here first.
What should happen and what happens in dev2 is we put in a start and end date prompt and it brings back all records that pass through these dates. In PROD the date prompts are being ignored completely and are bringing back all absence records regardless of their dates.