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.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Dimenstion on measure

Author  Topic  jmamedov Starting Member 1 Post Posted - 2005-12-02 : 10:49:22 There is count measure in the cube. I need to create a dimension that should list the range of values based on that count values: Exp: 0-99 100-199 200-399 ... .... .. and so on. User wants to pick the any range level in the dimension and cube should show corresponding cell values of count measure which would fall into range of the dimension level value. For example: if user picks up level 100-199 then cube would filter cell values of measure that has a value between 100 and 199 within 12 month range. So, it would be year to date value of the measure. My problem is how go about creating Dimension that based on measure in the cube and dimension should have level with range of measure values. Any hint would be greatly appreciated. Thank You