Evgeny Shvarov · Jan 9, 2017

How to find dependencies of Dimension or Measure to the pivots?


I want to optimize the cube and delete the measure. Is there any easy way to find pivots which use it?

Does anyone have any snippet regarding this?

Would be great to have "out of the box" dashboards which will show the dependencies of pivots vs measures and dimensions.

0 214
Discussion (1)0
Log in or sign up to continue

You can search for the references in studio:

  1. Open Studio
  2. Menu -> Edit -> Search in files
    • Find: Dimension/Measure (for example [DateOfSale].[Actual].[DaySold])
    • File type: *.dfi

It should find relevant entities.