in SSAS, you are looking at members of a dimension and if you want to use <= operator as in SQL, you have to add up all values from the...

If the two hierarchies are essentially the same, you should not have to define another parent-child relationship. Just create another hierarchy on the same dimension with a different name

You are on the right track, and to get values for a particular time period, you have to crossjoin using the current context. Also, use DistinctCount instead of Count...

Here is...

Maybe I am missing something, but you are asking for the week 33 SUM from the cube, and that result is the same value as reported by the SQL query...

The 'link' between the fact and the dimension should be an integer, so the time dimension in your case should have a integer key in the format YYYYMMDD

What is the hierarchy structure defined on DimDate?

What does '33' refer to in the Hierarchy slice?

Great article - can you add the fact table as a resource to the example?

thanks

Thanks for sharing your story with us. I feel I am in the same position as you, except my coworker has the boss' ears and is 'senior' to me in...

Definitely, an interesting spin would have been:

declare @str varchar(max)

select @str = replicate('#',10000) + replicate(cast('#' as varchar(max)),10000)+ '#' + '#' + '#'

select len(@str)

To demonstrate the fact that replicate(cast('#' as varchar(max)),10000)...