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