Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deployX
Starting Member
2 Posts |
 Posted - 2012-01-24 : 05:23:58
|
| I have a cube in which there are following values:Dimension 1: Time Taken Size Product Error ValueMeasure available is [Measures].[Dimension 1 Count], which is basically the number of users. I want to have data in groups/buckets like following example for :Users who took 0-5 seconds while installing Product1 = 10Users who took 5- 10 secs while installing Product1 = 15Users who took 10-15 secs while installing Product1 = 3Users who took more than 15 secs while installing Product1 = 5Can someone tell me how to write a single MDX query for doing this. |
|
|
deployX
Starting Member
2 Posts |
Posted - 2012-01-24 : 08:01:24
|
| Also, if there are 3 Dimensions with following HierarchiesTime Taken, Size, Product, Error Valueand Measures available are [Measures].[Dimension 1 Count], [Measures].[Dimension 2 Count] and [Measures].[Dimension 3 Count]Is it possible to calculate top 10 error values across the 3 dimensions? |
 |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2012-01-25 : 06:58:46
|
| You need to create a hierarchy on the Dimension that groups the time taken into buckets for you. This will entail grouping it in your sql table already and making use of this attribute in your Dimension design. Not really easy to answer this one with a text example, but read up on attributes and hierarchies in Dimension design.Duane. |
|
|
|
|
|
|
MDX query to group data.