How To get cube dimension in ssas 2008r2

• vigneshbeece

  Mr or Mrs. 500

  Points: 569

  More actions

  September 15, 2020 at 3:33 pm

  #3788580

  How To get number of dimensions from each cube in ssas 2008r2 thorugh MDX query?

• PB_BI

  SSCoach

  Points: 17463

  More actions

  September 16, 2020 at 7:57 am

  #3788759

  Have a look at the DMVs for SSAS. https://bennyaustin.com/2011/03/01/ssas-dmv-queries-cube-metadata/

  That should give you all you need.

   

  ---

  I'm on LinkedIn

• vigneshbeece

  Mr or Mrs. 500

  Points: 569

  More actions

  September 16, 2020 at 11:47 am

  #3788788

  Thank you