SSAS dimensions and measures to JSON

• Freefall99

  Mr or Mrs. 500

  Points: 533

  More actions

  August 18, 2020 at 6:41 pm

  #3781389

  Hi,

  I am in a situation where my front end needs names/unique names for all dimensions(levels and members) and also measures/calculations.  What is the best way to go about doing this?

• ktflash

  Default port

  Points: 1400

  More actions

  August 19, 2020 at 6:14 am

  #3781522

  Most likely DMV (Dynamic Managent Views) is what you are looking for.

  By creating a linked server to SSAS you can query SSAS Metadata via SQL

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

• Freefall99

  Mr or Mrs. 500

  Points: 533

  More actions

  August 19, 2020 at 3:57 pm

  #3781682

  Thank you KT