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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by irjones
-
Calculaetd Measure Problem
I'm not so familiar with MSAS 2005 but it looks like you have a divide by zero error you could try the following:- CREATE MEMBER CURRENTCUBE.[MEASURES].RatioVal AS iif( SUM({[Tbl Acc Codes].[Tbl Acc Lvl1].&[OUR],[Tbl Acc Codes].[Tbl Acc Lvl2].&[CORE],[Tbl Acc Codes].[Tbl Acc Lvl3 - Lvl 3...- irjones
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
