I have an "Age" dimension that contains the age (float) value of customers. I want to break it up into ranges instead of listing all existing values so the dimension would look something like below

Ag
0-1
..
10-2
..
20-3
..

What would be a good way to create the dimension level? Any suggestions will be greatly appreciated

Use Grouping

1. In the dimention Editor, add two levels to the dimension, both based on the "age" colum
2. In the top level "age1", put your formula in the Member Key Column & Member Name Column to extract ages under each age grou


----- Tony wrote: ----

I have an "Age" dimension that contains the age (float) value of customers. I want to break it up into ranges instead of listing all existing values so the dimension would look something like below

Ag
0-1
..
10-2
..
20-3
..

What would be a good way to create the dimension level? Any suggestions will be greatly appreciated

How would that formula look ?

\Michael Vardinghus

anna <anonymous (AT) discussions (DOT) microsoft.com> wrote

existing values so the dimension would look something like below.

Interesting.

How would such a formula look....?

anna <anonymous (AT) discussions (DOT) microsoft.com> wrote

existing values so the dimension would look something like below.

case when age > 30 then '30+' when age > 20 then '21 - 30' when age > 10 then '11 - 20' else '0-10' en

----- Michael Vardinghus wrote: ----

Interesting

How would such a formula look....

anna <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:0AC5EBD1-43B2-4BEF-8A7C-D85D921B9707 (AT) microsoft (DOT) com..
existing values so the dimension would look something like below

I finally got it working, however now I can't drillthrough the data. The error message, "Data Source provider error. Incorrect error near the keyword 'from'.; 42000" is displayed. If I change the age dimension back to the old one level age dimension, the drillthough works fine. Here is what I have for the Age dimension

* Age

Member key:
case when "dbo"."tblTempPatient"."AGE" > 30 then '30+' when "dbo"."tblTempPatient"."AGE" > 20 then '21 - 30' when "dbo"."tblTempPatient"."AGE" > 10 then '11 - 20' else '0-10' en

Member name
case when "dbo"."tblTempPatient"."AGE" > 30 then '30+' when "dbo"."tblTempPatient"."AGE" > 20 then '21 - 30' when "dbo"."tblTempPatient"."AGE" > 10 then '11 - 20' else '0-10' en

** Age1

Member key
"dbo"."tblTempPatient"."AGE

Member name
"dbo"."tblTempPatient"."AGE

Any help will be greatly appreciated.