Portfolio Analyzer - PivotTable Field List 'Dimensions' Grayed Out

[Alika Victor]

To whom it may concern:

I ran the cube successfully. Details

- PWA using on the Server because I am still waiting for a fix on my desktop
for ActiveX Control problem.
- Cube ran successfully
- Open up Create a Portfolio Analyzer view
- PivotTable Field List appears with Measures & Dimensions
- Dimensions are "grayed" out and unable to add any of them to the Pivot
Table to any of the following
+ Data Area
+ Row Area
+ Column Area
+ Filter Area
+ Detail Area
- When I go to Browse the Data on Analysis Services I noticed that many of
the Dimension come up with a "Have a Zero Count and will need to assign a
count automatically" message "Do you want to proceed" YES or NO

Can anyone tell me why this is occurring. Until I solve this problem, I can
build a View that is worth anything for analysis purposes

 

[Samer Beano]

Alika,

This happened to me once, I installed Office 2003 on my machine, deleted the
protfolio analyzer views, deleted the cube, built the cube again, built the
protfolio views again and it worked
I'm sure there is much simpler solution, but hey this worked for me

 

[Alika Victor]

Problem solved. I moved to a machine with Office, Web Componets and PWA
access and was able to access the PivotTable dimensions.

Thanks for the feedback.