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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.