I only want to display the date of '12-12-1969' as 0 or empty. 

Unfortunately that's not working

Here are the screenshots! I am using the CASE in a column filter

Hi Pedro, Thank you for your response. This is the error I get: Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near <'>: Syntax error [nQSError: 26012]…

Do I need to cast anything?

hmm.. Not sure if I follow. I'm fairly new to OBI and data warehousing. My users want the most most accurate information, so if there are agreements or service requests that have been deleted out of Siebel, they don't want reports showing those records. I don't know what would be the best route to go about doing so.

thank you for your reply. I've decided to run a FULL load ETL weekly so OBI will be updated with the deleted records from Siebel.

I'm not sure what your asking. Can you clarify?

BTW I changed the dates to 01/01/2015 - 01/31/2015

That's working a little bit better but I'm still getting some dates that are not between the 2 dates pick. Any suggestions? See image for date results.

Thank you for that. that was an easy fix. It's now working but not working like I need it to. It's just using <= one date and not between the 2 dates. It's doing greater than open date but not 'and less than close date' What would we the syntax to take into account greater than open date and less than close date? I'm…

Hi Srini I'm having difficulty with creating the 2 different date prompts. Here's the Prompts and Filters I have set up currently. Filters: CAST("Service Request Secondary Dates"."Open Date" AS DATE) >= date '@{OpenDate}{2016-1-1}' CAST("Service Request Secondary Dates"."Close Date" AS DATE) >= date…

Gotcha! Thank you for that information, Srini! Have a good weekend

Thank you for your reply Srini. I don't think that's what I'm wanting.. Instead of having 1 date column and having an 'in between' operator on that 1 date column, I have 2 different date columns(open date and close date) and I'm trying to do an 'in between' 2 different date columns. So the user will select a value from…

I don't have access to it I need a support identifier

Ebin, can you point me where to find the data lineage document that you have?

Thank you Ebin. So I was able to find the source table for the Fact_W_AGREE_F.Global_Total_Amt, It is W_AGREEITEM_F.NET_PRI_DOC_AMT, so is that the exact name of the Siebel column?

Thank you Christian for that information. If I may follow up with some questions. In the Mapping Designer I was able to trace it back to the Source Definition. Since I was able to do that, what would be my next step to find out what the column in Siebel is because it's still referring to a Warehouse table or is that the…