This discussion is archived
4 Replies Latest reply: Feb 18, 2013 3:05 AM by Dhar RSS

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

user652652 Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points