Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX Sum values of lower level

Status
Not open for further replies.
woezelmann

woezelmann

Programmer
Oct 31, 2012
1
DE
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!
 
Sort by date Sort by votes
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

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PerlIsGood
  • Locked
  • Question
MDX Dynamic Set not showing up in cube
Replies
0
Views
182
PerlIsGood
PerlIsGood
josmi
  • Locked
  • Question
How to design a fact table to keep track of active dimensions?
Replies
7
Views
432
johnherman
johnherman
amypham
  • Locked
  • Question
MDX Query, binning results together
Replies
0
Views
166
amypham
amypham
pilcher85
  • Locked
  • Question
MDX - Skipping levels in the hierarchy
Replies
3
Views
293
MDXer
MDXer
Jony77
  • Locked
  • Question
MDX Query
Replies
0
Views
183
Jony77
Jony77

Part and Inventory Search

Sponsor

Back
Top