Search code examples
sql-serverssasbusiness-intelligencesql-server-data-toolsssdt-bi

Reprocess one measure group and browse cube in SSDT?


A user was browsing our sales cube using PowerBi and noticed that measure group Fact Finance was incorrect.

The issue was an incorrect relationship. I added the relationship between FactFinance and DimAccount. Since processing the whole cube takes over an hour, I prefer processing this measure group, check the values in the SSDT browser, and publish the cube if everything's good.

How can I process just one Measure group so that I can browse the cube (ie. this measure) in SSDT and make sure everything's correct?

The reason I ask is that the SSDT browser connects to the actual cube, so I'm not sure how I can just process and deploy one measure group.


Solution

  • You can connect to the Cube and refresh (technically it's called "Processing"), with a variety of tools. The most common for a manual re-processing is SQL Server Management Studio. See Tools and Approaches for Processing (Analysis Services)