SQL Server Performance Forum – Threads Archive

Creating the Named Set and an Average

I need to cal the average Loan amount where the Status code not equal to 10, 11
Avg({[Status Code]},[Measures].[Loss Net Amt]) /* Create a Named Set which would exclude the data for The loan Status not in Code 10 & 11 */ WITH SET [Status Code] as
‘{
[LStatus].[12 ],
[LStatus].[15 ],
[LStatus].[18 ],
[LStatus].[3]
}’ This gives me error .. Is this the correct method .. could some one let me know would be great

---

How are you creating this name set and what exact error are you getting? Raulie
Hewlett-Packard Company

---

I am creating the Named set inside the calculated member I get an error saying Syntax error
Token is not valid ^Set^ [Loan Status Code]

---

Try creating the NAMED SET using the named set builder then call the name set in your calculated member. Raulie
Hewlett-Packard Company

---

]]>