1

I am having same problem as in below link:

SQL Analysis Services OLAP TIME dimension

Can I get steps to add new calculate member for date dimension in OLAP cube?

Community
  • 1
  • 1
user1765609
  • 35
  • 5

1 Answers1

0

Rather than adding new calculated member for date dimension in OLAP cube, you can convert your datetime field in fact to be only date to match dimension. For eg:

SELECT convert(datetime, '10/23/2016', 101) -- mm/dd/yyyy
Prabhash Jha
  • 330
  • 2
  • 12