4 Replies Latest reply: Feb 18, 2013 5:05 AM by Dhar RSS

    Not able to import date column as Date time(SQL server) in OBIEE

    user652652
      Hi,

      We have created cube in sql server.

      We have two date column in cube i.e. created date(datetime) joining date(datetime)

      Once I import joining date (Data type: Datetime) and created date(Datetime) by default it import as varchar.

      problems:

      1. I need to calculate difference of two date at OBIEE level. But it is varchar and I am not able to calculate the difference of two dates i.e. created date-joining date.

      I tried evaluate function also but not able to do in OBIEE 10.1.3.4.

      Any help pls