Home      Functions     Common Solutions      Contact     






MDX Functions:
 
MDX Functions

 
Common Solutions

Common Solutions
 
Resource Links

MDX Books
MDX Related Software
MDX Related Blogs
 
Other Links

Contact Us
 

View calculated members when querying the measures dimension.

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]



 

 
Copyright 2008 by MDXpert.com.
 
Terms of Use                              Privacy Statement
 
Site Powered By - WinHost.Com