June 24, 2004 at 7:27 am
Hi!
I have an integer column with serial numbers. There are about 30 000 of them. The actual values are from 1 to 1 000 000. These 30 000 are spread not very even on the 1 000 000. To reduce the length of the dimension level, I would like to make a two level hierarchy. I need to have 1000 members on each group. The top level should be the range. The name of each group should show the range. So I am trying to create something like this:
1 - 83 127 - the first thousand of serial numbers
83 128 - 127 833 - the second thousand
...
937 667 - 993 000 - the last 835 numbers
If possible, I would like these ranges to change as a new number is created, so I always have 1 000 numbers in each range (except the last, that will have a smaller number).
Is it possible to achive without creating additional columns on the table, perhaps using advanced dimension options like Custom Rollap Formula, Level Type, using MDX, functions of Hierarchy, Level type etc.?
Thanks.
June 24, 2004 at 10:43 am
Not exactly.
You need to add an additional column in the dimension table and populate it using left(col,1)+000 or likewise to achieve your goal in the normal way.
However, you can create a calculated member derived from the column and slice the data that way.
I know of no other method available.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply