Hi Mark, I know it is a year later, but I ahve the same issue , install type and environment and stalled install at same point. Did you find the problem, or what did you end up doing? Thanks for any pointers to save me 12 retries. Niamh

A dedicated DATE dimension table would bring a lot of value in this case, all date fields you need relative to a day come ready made into queries, and be worth the development and RPD modeling. Using star schema rules will get the best result out of OBIEE. Very good luck exploring a solution!

The below is based on my source Oracle database NLS date format as DD-MON-RR (Query on database- SELECT * > FROM nls_database_parameters WHERE PARAMETER = 'NLS_DATE_FORMAT'). Note this is not altered by the RPD connection pool, which is common. So the date I assemble for Substrings and Casts has to match that before it can…

fyi: these have identical formulas inside!

Hi Kavya Can you try with a brand new column with no special/custom data formatting? (use an existing string type column and change the formula) If this doesn't fix, troubleshoot in the RPD: What is the physical data column type of this field? Is it an Oracle table? It has to be a DATE type for the above to work. And…

Hi there, Is this something you can add to your date dimension table? For example, in my date dimension, ever row has a column called: PYE_DATE_CHAR so that I can easily grab Previous Year End (eg '31 Dec 2015') in the desired format, on every row for a year it has the same value. Make your database do the work here…