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 - 2011-03-14 : 18:03:07
|
| I have a dim Product and a measure that count the # of sold item. I can easily know the number of times a product have been sold.What I was asked to create was a graph that would put on the Y axis the number of product and the X axis the number of time it was sold. Basically we want to know how many products was sold more than once (2,3,4,5...times ) and display it on a graph. It needs to be calculated dynamically as you can filter by dates.I was told to use the scope mdx function within the calculations tab of SSAS dev tools(calculated measure) but could not make it work.Anyone can help me or have a better idea on how to do it. Thanks |
|
|
|
|
|
Count of measure as DIM