MDX Sum values of lower level

[woezelmann]

I am new to OLAP, I just designed my first cube and now I am trying to make some simple analyses. I have a simple time dimension that looks like this:

- Year
--- Month
----- DayOfWeek

Now I would like to sum all measures for e. g. Monday. I don't want to know the measure for Monday for every month of every year seperated (I am able to do this) but for all Mondays ever. Just one value.

Is it possible and if, how?

Thanks!

 

[blom0344]

Day of week is non-unique. This usually poses problems, cause you need the higher levels in the hierarchy to create uniqueness. The way you set up the time dimension should work in favor for your demand. Fact data should be rolled up to just 7 members (1 - 7; Sunday - Saterday)

Ties Blom