I read, therefore I am confused. Sorry, but I just can't understand
the difference between a member, a dimension, a calculated member, a
set, a tuple, a name and a value.

So, I'll ask my dumb question. I have created a dimension on a field
which contains 6 values. Instead of the cube rolling up on each of
those 6 values, I want the cube to roll up 4 of the values in 1 group
(would that be a member?), and 2 of those values into another group
(the 2nd member????). What do I create? A calculated member? A
named set? I seemed to have gotten the syntax right for both of
those, but when I browse the data, it shows errors. If I knew the
right way to proceed, I'd happily trudge thru getting the syntax
correct, but I have a feeling my approach here is all wrong. I think,
in essence, that I want to create a "calculated dimension", but I
don't see anything resembling that.

At this point, I'm tempted to create a bunch of SQL views to
pre-process all my data by performing calculations, but that seems to
defeat the purpose of the cube, I suppose.

I appreciate any help anyone can offer.
Thx
Nakai

Marcus wrote:

I think what you want is to create a group level in your dimension.

For the dimension create a table with two fields, a group field and a
detail field. The table should have 2 levels, a group and a detail
level.

Dimension table:

Detail Group
1 1
2 1
3 1
4 1
5 2
6 2

Hope this helps,

Hans.

Ah, ha, the light bulb finally goes off. I didn't know that
dimensions could contain levels. That opens up lot of possibilities.
Thanks, Hans. (Sorry I posted my original post in the middle of a
thread... didn't realize it at the time).

"Hans van Kruijssen" <hans.vanKruijssen (AT) agilisys (DOT) com> wrote