PWA Refresh

[BillG_SD]

I've updated the values of ProjectEnterpriseText1 column in the
msp_view_Proj_Projects_ent table. One of the PWA views filtering/sorting on
this field. After verifying that the new values populate the field, the
display of the view has not changed. I made sure to rebuild the cube after my
changes.

Did I miss a step?

 

[Gary L. Chefetz [MVP]]

Bill:

Did you republish your projects?

 

[BillG_SD]

Gary,

True, opening/closing the project seems to work. Is there a way to
'Republish All'?

If not, I found that MSP_TEXT_FIELDS contains all of the 'old values',
can I simply run a SQL Script to replace the text?

 

[Gary L. Chefetz [MVP]]

Bill:

You might try downloading the Views Populator tool from Microsoft.