nitin.guglani
SSC Eights!
Points: 899
More actions
June 7, 2010 at 5:49 am
#157007
Hi
I need to create a Named set (Flag), which will take date from the table (DB_Date) and compare it with the curent date and if DB_Date is less than the current date , it will say "YES" else "NO"
How can i posssibly do this...??
Plz Help....
Thanx...
Raunak Jhawar
SSCoach
Points: 15701
June 8, 2010 at 7:40 am
#1177470
Hello Nitin,
Why do you want to use the Time Dimension Key for such purpose....
Why not get the relevant in the ETL phase itself....
It would be lot easier to handle.
Kindly let me know if I am wrong.
Raunak J
Koen Verbeeck
SSC Guru
Points: 259015
June 9, 2010 at 6:45 am
#1177938
I think the easiest way to do this is in the DSV. Create a new column with a simple CASE statement.
Need an answer? No, you need a question My blog at https://sqlkover.com. MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply