Report Portal

Updating SSAS Dimension and Hierarchy Descriptions from a Database using PoSh

You can use this script to set the descriptions of dimensions and hierarchies in your SSAS DB, without using SSDT.

The script will get the descriptions from a database, using stored procedures, so you will have to modify the script, referring to an existing SSAS instance and DB, and specifying a connection string to a database which contains two stored procedures and two tables.

Read more...

 

Tags: amo, script, powershell

 

2007-2015 VidasSoft Systems Inc.