time across columns AND down rows

Question

time across columns AND down rows

Richard Polichetti

Old Hand

Points: 325
More actions
May 13, 2005 at 12:49 pm

#110136

I'd like a report with days across the top and 24 hours down the rows so management can compare call data performance hour to hour across days.
select
{ [TimeByMinute].[All TimeByMinute].[2005].[May].[1] : [TimeByMinute].[All TimeByMinute].[2005].[May].[10] } on columns ,
{ [TimeByMinute].[Hour].members } on rows
from ACD_Calls2
where [Measures].[Calls]
I get the "duplicate dimensions across (independant) axes" message.
Any ideas?
Richard

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

kenno_rules SSC-Addicted Points: 453 More actions · Answer 1

Yeah, it's annoying, isn't it? To get around it, I am afraid you'll need another dimension, which is pretty much the same as your 'TimeByMinute' dimension, and use that in conjuction with your existing dimension. Or, you could create a flat 'hour' dimension and use that.

If there is another way around this, PLEASE POST IT!! My cubes each have about 5 'time' dimensions to get around these problems, and that is NOT a great solution, I'm sure you'll agree.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 2

Hey KennofromOz, Yukon help with this for a little (multi-role dims) but that doesn't help now does it

Steve.

kenno_rules SSC-Addicted Points: 453 More actions · Answer 3

StevefromOzbutwannabeUS , Yukon helps with a LOT of problems we have at this client, particularly multi-role dims and especially properly 'heirarchy aware' dimensions (ie sharing aggregations etc). But, no, none of this helps now.

KennoFromOzbutsoontobeUK.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 4

You're not looking to implement it now rather than later? You'll miss out on all the fun. Think of it as the last job you'll do in sunny weather :p

Steve.

Richard Polichetti Old Hand Points: 325 More actions · Answer 5

Thanks all! At least I know now that it wasn't just because I didn't know enough mdx. I think that's the toughest part of learning this.

Anyway, thanks for talking the time to answer.

I've got another new problem to post now...