Recent questions and answers in SSAS Interview Questions and Answers

Recent questions and answers in SSAS Interview Questions and Answers

Nice?Vote!

2 answers

Explain the purpose of synchronization feature provided in Analysis Services 2005

answered 1 month ago by anonymous

Nice?Vote!

1 answer

How can I define SCOPE in MDX for all but one measures in one measure group?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How do you specify SCOPE for a Dimension to include all members after a certain member

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Can you create a SCOPE based on the Member property?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How Can I define SCOPE in MDX for all measures in multiple measuregroups?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How Can I define SCOPE in MDX for all measures in one measure group?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How do you specify SCOPE for a Dimension to include all members before a certain member

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Can you use the Filter function in a SCOPE statement, in MDX query?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How do you calculate monthly average of a year including empty months, by SSAS MDX?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

MDX query to get count of months with sales amount > 0 in defined period, in SSAS

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How do I calculate sales for 12 Month to date in MDX, in SSAS?

answered 1 year ago by R (19,530 points)

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

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

I need an MDX statement to get the first month of the last year loaded into a cube, in SSAS

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How in the report can I order date dimension members in descending order, by MDX?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Need a MDX query that returns list of months from start of year up to specified month.

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How do you calculate monthly average of a year, by MDX?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How can I get Last (Previous) Year to Date (YTD) values, by MDX?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How to create calculated member for AVG sales over last 3 years based on NOW(), using MDX?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Need MDX Query to get latest months and previous years same months data, in SSAS

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

How do you write MDX query that uses execution date/time as a parameter, in SSAS?

answered 1 year ago by R (19,530 points)

To see more, click for all the questions in this category.