Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
#VALUE! error when totaling distinct counts in Front Page
I am not using any explicit MDX. I have built a cube with a measure using the derived distinct count aggregation. I then publish the cube to a web server and access it with Front Page/Excel. However, the PTS web component can not handle distinct count aggregations on a totals calculation so it...- moemike
- Post #5
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
#VALUE! error when totaling distinct counts in Front Page
Thanks for the response. The #VALUE! text shows up in the cell. The following error appears when I mouse-over: "An error occured during attempt to get a cell value. Formula error - aggregations are not supported for the DISTINCT COUNT measure in the aggregation function" I am looking for a way...- moemike
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
#VALUE! error when totaling distinct counts in Front Page
I have created several cubes which use Distinct count as a derived measure. When I publish the cubes via Front Page/Excel I receive a #VALUE! error whenever the user selects multiple members in a page item list. If the user selects only one or all, it works fine. The error also shows up on the... -
#VALUE! error when totaling distinct counts in Front Page
I have created several cubes which use Distinct count as a derived measure. When I publish the cubes via Front Page I receive a #VALUE! error whenever the user selects multiple members in a page item list. If the user selects only one or all, it works fine. The error also shows up on the grand...- moemike
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
