Setting pivot table page filter values through ssas filter web parts

Hot Topic

Data Transfer Objects and Lazy Load
Client Access
best practices for moving a WSS site from test to production
Custom view in site defination
MOSS 2007 Records Center
wss3.0 how to create first website with or without using templates
Accessing a SQL Server table using sql authentication as opposed to windows authentication
MOSS 2007 Stand-Alone upgrade/migration to Web Farm
Video Streaming..
Architecture for full text search on sql 2005

SharePoint Products

Templates Missing in SharePoint Designer 2007
Modify Left Navigation Bar in MOSS 2007
Error when trying to add a web part containing ActiveX markup
How to avoid getting prompted to install name.dll or to allow it's execution (IE 7.0 only)
CSF for Windows XP
Add aspx page developed in Visual Studio to sharepoint
Modeling for the Home Programmer
Data Auditing Techniques in SQL Server
Sharepoint Timer Jobs
MCSF Installation problem

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 !!!




Answer this question

Setting pivot table page filter values through ssas filter web parts

  • saba86047

    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



  • Sebastian Möller

    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 !!



  • malkie

    Hi,

    Can you paste the exact error message you are seeing please

    s



  • Idanle

    Actually I've got the same problem and this answer hasn't fixed it. Is there anything else that could be causing this to happen


  • Setting pivot table page filter values through ssas filter web parts
Answer this question