RE: Pivot Table services

Tech-Archive recommends: Speed Up your PC by fixing your registry

anonymous_at_discussions.microsoft.com
Date: 01/19/05 

Date: Wed, 19 Jan 2005 10:03:19 -0800

Thanks for the response Gary.

Your suggestions seem to provide the desired
functionality however I have a couple other questions, i
was wondering if you might have quick answers for me.
The cubes are going to be rebuilt on a nightly basis. So
I assume if data changes then all that would need to be
done is a refresh data in the Pivot Table services.
However it is also possible that a strucutre may change
(ie. a hierarchy). If this situation occurs does this
mean that the list would have to be regenerated? Would
the same reasoning apply if new data needs to be added to
the report?

Thanks
Craig
>-----Original Message-----
>For question 1) try selecting the fifty customers you
want and group them and
>then save the spread*** and use the spread*** to
open the OLAP cube. For
>question 2) try saving the OLAP cube file in a
spread*** 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 are:
>> 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
>>
>>
>.
>

Quantcast