Decreasing number of Values in Pivot Tables Value List
Hye Friends,
Few days back I created a cube in SQL 2005 Analysis
Service, which I am accessing using Excel's Pivot table. Unfortunately the
Cube contains large number of Dimensions & so the Field List which is getting
displayed in Excel is quiet huge.
I wanted to know if there is a way I can prevent the user
from seeing all the Dimensions in the Field List & only show him a selected
few which might be important.
Thanks in advance,
Regards,
Rohan !
|