Named Set

• 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

  More actions

  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

  More actions

  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