SSAS cube

• miriyalasrihari

  Ten Centuries

  Points: 1225

  More actions

  January 11, 2011 at 10:45 pm

  #148193

  I created a cube using SQL Server Analysis Services 2008, and I'm viewing the results in the Browser window and MDX code(manual MDX code) that generates the Browser window results

  Is it possible to generate MDX Query's automatically from browser?

  Thanks.

  [font="Verdana"]SRIHARI(:~[/font]

• amit_gupta01

  SSChasing Mays

  Points: 605

  More actions

  January 12, 2011 at 4:59 am

  #1272288

  You can capture MDX queries in profiler window.

  If you are browsing data using excel then you can install OLAP plug-in which will help you to get MDX code.

  http://www.msbiconcepts.com/2010/11/olap-pivottable-extensions-for-excel.html

  Thanks,
  Amit G
  http://www.msbiconcepts.com

• miriyalasrihari

  Ten Centuries

  Points: 1225

  More actions

  January 12, 2011 at 9:35 pm

  #1272789

  Thank you....for giving valuable replay

  i am new to some features of Sql server.

  can you please explain step by step process in Profiler

  [font="Verdana"]SRIHARI(:~[/font]