-
help.. MDX in Analysis Services
hi..
I am trying to create a calculated members using select statement in the AS.
This is my statement.
Select SUM([Measures].[Amount])
FROM SMAFinancial
WHERE [GLGroup].[Gl Group].[300000-399999]
What I am trying to do is just to SUM the Amount for GLGroup in [300000-399999] from SMAFinancial cube.
But I got error saying that there is formula syntax error - token invalid.
Can anyone please help?
Thanks a lot.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|