Setting pivot table page filter values through ssas filter web parts
Hi !
I created a workbook that have a pivot table with page filters against an SSAS cube .
Then I published it in Excel Services setting those page filter (by naming the cell with the page filter value) as parameters.
In MOSS I exposed the workbook through an Excel services web part and also inserted a SSAS 2005 filters web part so as to allow user to change the pivot dynamically.
But when running MOSS says cannot write parameters in Excel.
Any idea ?
thanks !!!
Hi Shahar,
When filtering I see the following error (it′s translated from spanish):
"Cannot set one or more parameters"
"Error when trying to set one or more parameters of this workbook"
"Click OK to open the workbook with saved values"
Thanks
Leandro
Hi Shahar,
I′ve just have found what the problem is.
When configuring SSAS 2005 filter web part, "Code selected values as a set" check box must be unchecked, otherwise it sends the selection between braces, while pivot table page filters expect only a list of members selected without the braces.
Thanks anyway !!