Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Counting members.
- Thread starter Grif
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
WITH
MEMBER
[measures].[count]
As ' Descendants ( [Store].CurrentMember,
[Store].[Store Name] )
.count '
SELECT
{ [measures].[count] } ON COLUMNS,
{ [Store].members } ON ROWS
FROM
[Budget]
MEMBER
[measures].[count]
As ' Descendants ( [Store].CurrentMember,
[Store].[Store Name] )
.count '
SELECT
{ [measures].[count] } ON COLUMNS,
{ [Store].members } ON ROWS
FROM
[Budget]
- Status