By default, calculated members are not returned when referencing the measures dimension. The examples below use two different methods to return calculated members.
The query below references the Measures dimension but does not explicitly list the names of calculated members. Therefore, calculated members are not returned.
SELECT {} ON 0,
{[Measures].Members} ON 1
FROM [Sales Summary] The following query uses the AddCalculatedMembers function to return calculated members.
SELECT {} ON 0,
{ADDCALCULATEDMEMBERS([Measures].AllMembers)} ON 1
FROM [Sales Summary] The query below uses the AllMembers function to return calculated members.
SELECT {} ON 0,
{[Measures].AllMembers} ON 1
FROM [Sales Summary]