Calculated fields not exporting to pivot table correctly

[JenStover]

I'm using MSPS 07 through April CU.

I'm creating Data Analysis views with calculated fields. When I export to a
pivot table, the calculated fields are not making it to the pivot table.

What am I doing wrong?

 

[Marc Soester [MVP]]

Jen, does the field come through to Excel or is not even displayed?

 

[JenStover]

Hi Marc - nothing comes through for the calculated field. Since Saved Links
is gone we thought we'd be fine just creating the pivot tables the one time
and re-using them. If we can't create them with the calculated fields we're
kind of hosed!

Help.

 

[Gary Chefetz]

Jen:

Out of curiosity, are you creating the calculated measures within the views
themselves, or are you adding calculated measures through cube
configuration. Does it make a difference when you do it one way or the
other?

 

[Gary Chefetz]

I meant to add, that I think that adding them to the cube configuration
would allow them to persist in the spreadsheets, whereas creating them in
the view itself would not. Note, I haven't tried this either way.

 

[JenStover]

Great question!

We are building them in the view (not through Server Settings) but just in
Data Analysis and then hitting export to Pivot table.

Would it behave differently if we were doing it the other way??

 

[Marc Soester [MVP]]

HI Jen,

yes it would, 2 things will happen if you actually create the formula in
the cube settings. Firstly ( depening on the amount of data) it would be much
faster, since the cube pre-calcualtes the formulas and it would appear in
excel when you export it to excel. The reason why it doesnt do this in the
view is because the export to excel hooks straight to the cube and doesnt
know anything about the "real time" calculation of your value.
As Gary already said, I think you should generally try to manage caculated
formulas in the cube not the view if possible.
Hope this helps
--
Marc Soester [MVP]
http://www.i-pmo.com.au

Great question!

We are building them in the view (not through Server Settings) but just in
Data Analysis and then hitting export to Pivot table.

Would it behave differently if we were doing it the other way??