Thanks for the reply Nick,

Each user has a id defined so they can log into the cube,
however we do not have any type of row level access to
the data (ie. we do not associate a user with particular
clients). Basically these lists can change frequently
and should be able to be maintained by the end user. Not
sure if what you mentioned below would still be
applicable?

Craig

-----Original Message-----
Craig

On 1), do the users have some kind of ID. If so they
can filter their
customers by setting this ID as a page field. This way
they will be able to
select their ID from the drop-down and see just their
customers.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England



"Craig" wrote in
message
...
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



.