[Mondrian] How to identify selected Dimensions and how to definedifferent aggregation function for different Dimensions ?
jhyde at pentaho.com
Fri May 13 15:00:24 EDT 2011
The AXIS(n) function is a standard MDX function but Mondrian does not
(Mondrian implements the syntax 'SELECT [Measures] ON AXIS(0) ... FROM
[Sales]' -- that is, 'AXIS(0) as a synonym for '0' or 'COLUMNS' but that is
a different thing.)
Can you please log a jira case to request this feature:
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of El Mehdi LAHLOU
Sent: Thursday, May 12, 2011 1:06 AM
To: Mondrian developer mailing list
Subject: [Mondrian] How to identify selected Dimensions and how to
definedifferent aggregation function for different Dimensions ?
to identify selected Dimensions i tried this :
WITH MEMBER [MEASURES].[AXISDEMO] AS
SELECT [MEASURES].[AXISDEMO] ON COLUMN,
[STORE].[ALL STOREs] ON ROWS
but i got this error message:
Syntax error at[3:15,3:17], token 'AXIS'
can someone help me and suggest me a good way to identify the selected
An other question :I would to declare a measure which use a different
aggregation function for some dimensions.
I try to better explain my situation.
I have a measure stock_level and dimensions (product, customer and time)
the aggregation functions according to each Dimension , are:
product = PK
time = avg(sum(PK))
what is the right way to declare in a Mondrian scheme a situation as this?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian