Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(237)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
How can I define SCOPE in MDX for all but one measures in one measure group?
Nice?
Vote!
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
function
mdx
scope
1 Answer
Nice?
Vote!
You can use function MeasureGroupMeasures() and subtract set of measures that should be excluded.
Example:
SCOPE(MeasureGroupMeasures("Internet Sales") - {[Measures].[Internet Tax Amount]});
This = ...;
END SCOPE;
answered
1 year
ago
by
R
(
19,530
points)
Related questions
Nice?
Vote!
1
answer
How Can I define SCOPE in MDX for all measures in one measure group?
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
mdx
function
scope
Nice?
Vote!
1
answer
How Can I define SCOPE in MDX for all measures in multiple measuregroups?
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
function
mdx
scope
Nice?
Vote!
1
answer
How do you specify SCOPE for a Dimension to include all members after a certain member
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
scope
function
mdx
Nice?
Vote!
1
answer
How do you specify SCOPE for a Dimension to include all members before a certain member
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
mdx
function
scope
Nice?
Vote!
1
answer
MDX query to show year level data for all years except the last one, and month level data for the last year, in SSAS
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
mdx
function