Dimension: Calendar.Year.Period

User filters on 2005 and 2006

How do we use mdx to count the number of years filtered on?

The answer should = 2

Depends on the version of Analysis Services and the client tool -
assuming AS 2005 and Excel 2003, this entry from Mosha's blog should
help. Something like Count(Existing [Time].[Year].[Year].Members):

http://sqljunkies.com/WebLog/mosha/a...005/11/18.aspx
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks Deepak! Why is Year 2x in the mdx expression when the hierarchy is
Time.Year.Period ?

I am new to mdx.

p

"Deepak Puri" wrote:

Could you clarify the context in which "Year 2x" appears - I couldn't
find it in the referenced blog entry?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

From your example:

Count(Existing [Time].[Year].[Year].Members):

"Deepak Puri" wrote:

OK - that's typical for attribute hierarchies in AS 2005. For example,
in the Adventure Works Date dimension, the year level of the [Calendar
Year] attribute is:

[Date].[Calendar Year].[Calendar Year]


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***