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)
Can you use the Filter function in a SCOPE statement, in MDX query?
Nice?
Vote!
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
mdx
function
1 Answer
Nice?
Vote!
Yes you can. Filter function is allowed inside SCOPE function. Example of how you can use FILTER function inside SCOPE function provided below:
SCOPE ( Filter([Date].[Calendar].[Month].MEMBERS, [Date].[Calendar].Properties("Month of Year") = "January") );
Measures.[Amount] = 10;
END SCOPE;
answered
1 year
ago
by
R
(
19,530
points)
Related questions
Nice?
Vote!
1
answer
How do you get Last month in the time dimension, SSAS MDX function
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
mdx
function
Nice?
Vote!
1
answer
How do you write MDX query that uses execution date/time as a parameter, in SSAS?
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
mdx
function
Nice?
Vote!
1
answer
I need an MDX statement to get the first month of the last year loaded into a cube, in SSAS
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
mdx
function
Nice?
Vote!
1
answer
I need an MDX statement to get the last Month loaded into a cube, in SSAS
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
mdx
function
Nice?
Vote!
1
answer
Can you create a SCOPE based on the Member property?
asked
1 year
ago
in
SSAS Interview Questions and Answers
by
R
(
19,530
points)
ssas-interview-question
function
mdx
scope