SQL Server Performance

Creating the Named Set and an Average

Discussion in 'Analysis Services/Data Warehousing' started by Mds203, Dec 17, 2004.

  1. Mds203 New Member

    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
  2. Raulie New Member

    How are you creating this name set and what exact error are you getting?

    Raulie
    Hewlett-Packard Company
  3. Mds203 New Member

    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]



    quote:Originally posted by Raulie

    How are you creating this name set and what exact error are you getting?

    Raulie
    Hewlett-Packard Company
  4. Raulie New Member

    Try creating the NAMED SET using the named set builder then call the name set in your calculated member.

    Raulie
    Hewlett-Packard Company

Share This Page