MDX Query

[durvalmateus]

hi,

i'm new on this. i've already make some reports, but i have dificulties with MDX

My problem is:


Dimension Time:
Year, Month, Day, Hour, Half-Hour, Quarter-Hour

My Measure
[Measures].[Cable Traffic]

how can i obtain the following:
i need to know by day, the hour that have the biggest average traffic

Can someone give assistance?

Thks in advance.
Durval

 

[benaround]

Sorry, I'm not knowledgeable about the MDX query setup but why not just make a dimension and do a count that way? easier then setting up a on-the-fly query!

 

[justins57]

Durval,

Sounds like you need to break up the time dimension into a date dimension and a time dimension.

Hope this helps,

Justin