how to use cube in normal queries

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  February 5, 2010 at 10:25 am

  #144763

  hi,

  I am using SQL SERVER 2008 , and I have created a cube in Analysis services.Is it possible to use this Cube in normal T-SQL Queries(like join with the other queries).

  Thanks

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  February 5, 2010 at 10:26 am

  #1114607

  you will need to use MDX to query the cube

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  February 5, 2010 at 12:45 pm

  #1114720

  Thanks for your reply,Can I combine it with normal TSQL?

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  February 5, 2010 at 1:31 pm

  #1114749

  Technically, yes, would you want to? probably not.

  An old article on distributed queries, am sure there are newer ones out there --> http://support.microsoft.com/default.aspx/kb/218592

  Steve.