-
currentMember: difference between AS2000 e AS2008
Good morning,
i am migrating from SS2000 / AS2000 to SS2008 / AS2008 and fixing my own olap tool to work correctly within but i am in trouble in time comparison.
In AS2000 when i would to compare a measures (e.g. Quantity) in a time period (e.g. 1st Jan until today in 2009,2010,2011), i execute an mdx like follow:
WITH
MEMBER [measures].[time_quantity] as 'sum({[orderDate].currentmember.[1]:[orderDate].currentmember.[5]},[measures].[quantity])+sum({[orderDate].currentmember.[6].[1]:[orderDate].currentmember.[6].[21]},[measures].[quantity])'
SELECT
{[orderDate].[All orderDate].[2009],[orderDate].[All orderDate].[2010],[orderDate].[All orderDate].[2011]} on columns,
non empty toggledrillstate({[nation].[All nation]},{[nation].[All nation]}) on rows
FROM orders
WHERE ([measures].[time_quantity])
or simplier, just for monthly comparison
WITH
MEMBER [measures].[time_quantity] as 'sum({[orderDate].currentmember.[1].[1]:[orderDate].currentmember.[1].[31]},[measures].[quantity])'
SELECT
{[orderDate].[All orderDate].[2009],[orderDate].[All orderDate].[2010],[orderDate].[All orderDate].[2011]} on columns,
non empty toggledrillstate({[nation].[All nation]},{[nation].[All nation]}) on rows
FROM orders
WHERE ([measures].[time_quantity])
In AS2008 when i run this query, an error occour with the following description.
Parser: Sintassi di '[1]' non corretta. (Parser: incorrect sintax of '[1]')
Where is the issue? Can't i use currentMember in WITH MEMBER?
Thanks for your support,
Cristian
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
|
|