I use SQL 2000 and Excel to view OLAP Cubes.
1.) Is it posible to group different items with one query.

example:
we have a table with text and numbers
1100 160,--
2300 230,--
2400 110,--
2500 400,--
8100 150,--
8300 250,--
8500 220,-- etc

now in excel i can filter 8100, 8300,8500 etc

me use would sum
8100 and 8500 detail sum
2400 and 2500 detail sum

2.) how can I show a desciption of a filter-field (listbox). example
8100 = building
8300 = inventory

I think the only way is to join tables a show only the description (example:
building, inventory) or we take msaccess for evaluation.

Please excuse my for bad english!

For question #2, for each level of a dimension, you can specify both a
"member key" column and a "member name" column. By default, these are
the same column, but in the properties area, you can make them
different -- in your case, the column with 8100, etc. as the key, and
the column with "building", etc. as the label. You can also specify
whether the sort should be performed on the label or the key.

For question #1, I'm not sure what you're asking. You want a subtotal
by several items? The best thing to do would be to define the
dimension so structurally what needs to be grouped together is grouped
together. Subtotaling arbitrary dimension element combinations is
difficult in most reporting tools.


"Franz Chernjak" <f.ch (AT) gmx (DOT) at> wrote