Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
CASE statement using DATES
Answers
-
@Gianni Ceresa pretty much said it all and that's why I asked where you were using that formula.
If you just want to manipulate the display of that column then you'll need to use that formula inside the column formula so all records that match that date will display 0 (or null) and all others will display the date.
If you want to exclude that specific date from the reports you need in your report filter to establish a connection between A and B where A is your date and B the values you want to exclude, in this case something like "Agreement Sent Date"."Date" <> 1969-12-12
0 -
I get the sense that your source uses that data in place of a null (column is not nullable) ... if so, then is this date joined to your Time/Date/Calendar dimension?
If true, then just manipulate the Date Name (a text representation of the date) as NULL in your dimensional DW table ... do it once in ETL and never do it again anywhere. Much easier to reuse and maintain.
If false, and it's just an attribute you will show from time to time, then still in the DW drop the constraint on the column and replace the 12/12/1969 with a NULL.
0