SharePoint Developer Center >
SharePoint Products and Technologies Forums
>
SharePoint - Excel Services
>
Maximum limitation of "Report Filter" values in Excel 2007 pivot table (SSAS Cube as datasource)
Maximum limitation of "Report Filter" values in Excel 2007 pivot table (SSAS Cube as datasource)
- Hi,
With SSAS cubes as Source, I browsed a cube using Excel 2007 pivot tables. A column, lets say "Sales Order number" has more than 62000 rows in cube. When I drag the column into "Report filter" of Excel 2007 pivot tables, when I open it, I can see only first 32000 values. Because the limitation of Filter values in 'Report Filter' is 32000.lI am fine with that.
But when manager tried to open the same cube,same column in Excel 2007, he could see 32000 values but after publishing into Excel Services,he could see only 2000 values.I tried to figure out why it is so, but I am not able to do. Is there any settings, where he might have changed by mistake?....If any of you guys give your ideas, I would be more than happy..
Thanks in advance..- Edited byArchana_tn Friday, October 23, 2009 2:20 PM
- Moved byCharles Wang - MSFTMSFTMonday, October 26, 2009 9:49 AMShould be an issue with Excel Services in Sharepoint (From:SQL Server Analysis Services)
All Replies
On SSAS, did you grant enough access permissions for all data of your cube to your manager's user account? Probably your manager did not have enough permissions to read all of the data.
Granting Custom Access to Cell Data
http://technet.microsoft.com/en-us/library/ms174847.aspx
Please remember to mark the replies as answers if they help and unmark them if they provide no help- Thanks Charles...but he has all the permissions.
The issue is in the Excel sheet 'Report filter' of Pivot table, he could see 32000 values,But after publishing into 'Excel Services' of Sharepoint, he could see only 2000 values and under that he could see 'Not all values are showing'. Why is it so?..'Excel Services' or 'Sharepoint' has any limitation to show the values even though 'Excel sheet' has many filter values in pivot table?...If so, can we increase the number of values? - Archana_tn,
Since you can use Excel sheet to view the cube data correctly, I think that this issue is probably related to Excel Services in Sharepoint. I move this thread to Sharepoint forum for more dedicated assistance.
Please remember to mark the replies as answers if they help and unmark them if they provide no help
