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


      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.


      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

      Any help pls