June 7, 2010 at 5:49 am
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...
June 8, 2010 at 7:40 am
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
June 9, 2010 at 6:45 am
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