CODEWITHSUNDEEP
ssasmdxolap
David542
David542

Reputation: 110123

Bracket requirement on MDX

Why are brackets around the COUNT required in the below?

SELECT
    Measures.[Count] on COLUMNS,
    (
     Conference.Conference.members,
    {Division.Division.&North, Division.Division.&South}
  )
     on ROWS
FROM Avails

The query works removing the brackets on every word except for the .[Count] in the above. I thought brackets were only required if there's a space in the name?

Upvotes: 0

Views: 109

Answers (1)

MoazRub
MoazRub

Reputation: 2911

They are needed cause count is a function. Try renaming it to count123 and use it without []

Upvotes: 1

Related Questions