Report Portal

MDX-How do you make calculated measure to be default cube measure

Q: How to setup calculated measure as default measure for a cube?

A: Use ALTER Cube statement on measures dimension. Example:

ALTER CUBE CURRENTCUBE UPDATE DIMENSION Measures, DEFAULT_MEMBER=[Measures].[Profit]

Based on MS KB article.

Tags: mdx, faq

 

2007-2015 VidasSoft Systems Inc.