One other thing... can we create a group that spans
mutilple level in our hierarchy?

For example, if we have a heirarchy that represents
different cars, so Level one would be Ford, That would
break into level 2 which would be Windstar, FreeStar,
Focus, Contour then level three would break down into the
different years 200, 2001, 2002, etc...

Can I create a group that selects all of the 2002 data
for each of the different level1 names?

I currently get a warning saying it cannot create that
selection.

Thanks,
Craig
-----Original Message-----
For question 1) try selecting the fifty customers you
want and group them and
then save the spreadsheet and use the spreadsheet to
open the OLAP cube. For
question 2) try saving the OLAP cube file in a
spreadsheet with the
dimensions opened and see if that preserves the format.

"Craig" wrote:

I was wondering
if anyone may have some suggestions for a couple of
user
issues I am trying to solve with Excel's Pivot Table
Services.

I have built a couple of OLAP cubes in which Pivot
table
services has been mandated as the front tool. There
are
two sets of functionality users are asking for that I
have not been able to provide answers too. I know
this
funtionality exists in other front end tools (ie. such
as
business objects query md), however right now other
tools
are not an option.

The tools pieces of functionality or work arounds I am
looking for a
1) The ability for a user to formulate a predefined
list
of dimension members that they report on. For example
if
i have a customer dimension that contains a million
customers, but i report on the same 50 customers
everyday, can i save this list of customers some how
and
customize the table view to only show my customers on
my
list. I do not want to have to select each customer
everyday.

2) Is it possible to open a dimension in the pivot
table
at a particular level. For example if I have a
dimension
that has three levels (starting at level 1 - the
highest
level). Pivot table services will always open the
dimension at level one. Is there a way that when i
drop
the dimension into the pivot table it will open at
level
2 or 3?

If I am not clear on something please let me know.
Any
assistance would be greatly appreciated.

Thanks


.