Tracking changes to measure expressions in a SSAS multi-dimensional model

Copper Contributor

Hello, all!

 

I have a stakeholder for whom we have built a SSAS multi-dimensional model. I recently built a Power BI report to document the model (tables, fields, measures) using SSAS Dynamic Management Views (DMVs). This data dictionary report has been extremely helpful for stakeholders who build reports against the model (de-centralized BI structure where users can build their own reports).

 

We've recently run into a challenge when the naming convention or definition (expression) of measures within the model change. Our stakeholders want visibility into that process and would like a history of those changes in the dictionary. My data dictionary report relies on the DMVs, which capture current state metadata from the SSAS cube.

 

My question then is, what is the best way to track changes to a table (specifically, the measures table) within the model so that the data dictionary reflects when and how a measure definition (expression) was changed? Is there a way, using DMVs or another route, to track what the measure was, when it changed, and what it now is?

 

Thanks in advance for your input!

1 Reply

 


@DDavenport1409 wrote:

Is there a way, using DMVs or another route, to track what the measure was, when it changed, and what it now is?


@DDavenport1409 , no.

You have to persist the informations in a relational database -tbale to get the history.