Is there a way to add calculated fields in excel 2007 to a pivot table, connected to a SSAS cube?
Meaning that is calculated on the fly automatically while drilling up/down...
I do not think so. The formulas button is disabled. Formulas have to be server side MDX calculated members. Same in Excel 2003
You will also note some other diffences like Grouping may require security access to cube metadata in order to work.
Philippe
|||This is quite a disadvantage! Hopefully the kpi wizard and the set selector of ProClarity will be integrated into excel!
No comments:
Post a Comment