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 |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2010-06-07 : 14:37:57
|
| The product manager I am working for is looking for a dynamic solution to present a graph on a website. The graph will be multiple bars with range on X axis and counts on Y axis. The graph data can only come from the cube.The fact table sample data could look like this : Student, Age1 52 43 74 15 106 157 88 12Ideally the user could type 2 numbers on the web page : size of the interval and the number of interval. So if he types 5 and 3. The graphs would represent the number of students with age between 1 and 5, 6 and 10, 11+. If he types 3, 3 it would be # of students with age between 1 and 3, 4 and 6, 7+Can it be done by querying the cube with MDX? Ideally we do not want to run ETLs or process any dimension to make it work.Thanks |
|
|
|
|
|
MDX Group by Range of data