The summary function I want for my cube data is unavailable.
When you use the OLAP Cube Wizard to create a cube from records in a relational database, the only summary functions available to calculate values for the data fields are Sum, Count, Min, and Max.
Create the report directly from the database records If you can refine your query sufficiently so that the amount of data it returns is not larger than your system can handle, and you don't need to create an OLAP cube for the data, try to return the records in the query to Microsoft Excel instead of creating a cube.
In Excel, when you create a PivotTable or PivotChart report that's based directly on your relational database query instead of being based on a cube, you'll have access to more summary functions: Sum, Count, Average, Max, Min, Product, CountNums, StDev, StDevp, Var, and Varp. For more information about how these summary functions work and how to use them, see Excel Help.
Consider setting up an OLAP server for the database The Microsoft OLAP server product, Microsoft SQL Server OLAP Services, lets you set up a wider range of summary fields than the OLAP client software included in Microsoft Office.