Create a default measure in AS2005 cubes

  • Article

In some cases, it is not obvious or easy to create a default measure in AS2005 cubes. In fact, there is no default measure by default, which can lead to long query times for queries that specify no measures. We have seen slow behavior with several query tools that display an initial default query or heavily browse the hierarchies, especially Proclarity.

To add a default measure, you can follow the code below:

1. Generate a new calculated member with NULL value:

CREATE MEMBER [CubeA].[MEASURES].NullMember AS null, VISIBLE = 0 ;

2. Include the new member in the cube as default measure:

ALTER CUBE [CubeA]

UPDATE DIMENSION Measures,

Default_Member = [MEASURES].NullMember;