SSAS question - way to query metadata?

  • I'd like to drop a dimension table, but want to see if it is being used by any cubes first. Is there a way to query for that?

  • I'd really like to avoid opening each of the 50 or so cubes we have, and looking at the data source view by eye. Guess I could rename the table, process every cube, and see if anything fails. Figured there's gotta be a better way though.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply