Calculated Measure show infinite in Excel

Last Post 11 Jan 2005 06:53 AM by james.hull. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
james.hull
New Member
New Member

--
11 Jan 2005 06:53 AM
I am using a virtual cube through Excel that divides one measure in one cube with another in a second cube as a calculated measure. In some cases, this results in an infinite result in an Excel PivotTable in certain cells, which do not appear when browsing the cube through the Analysis Services Manager. E.g. a piece of data which should return 0.10% if you calculate it manually, and does so in the AS browser, appears infinite (or 1.7+E308) in Excel.

Drilling down reveals no underlying problem, and changing the dimensions arounds just reveals more infinite cells.

Is this a problem with my data, the data cube, Excel, Analysis Services or something else?

Thanks

James Hull


Acceptable Use Policy
---