[Mondrian] Help MDX Query - CurrentMember

Kleyson Rios kleyson.rios at saude.go.gov.br
Thu Jan 16 06:37:21 EST 2014


Hi

 

What I need to do is calculate a measure based on a week range of each year.


I’ve already spent a lot of time trying to figure out how to solve the
problem.

 

I’m trying the following MDX query.

 

 

 

with

 

// For each year ON ROWS calculate a subtotal of Cases from Week 1 to Week 4

set [Range Weeks] as '{[YearWeek].[Year].CurrentMember.[1] :
[YearWeek].[Year].CurrentMember.[4]}'   

 

member [Measures].[Partial Cases] as 'Sum([Range Weeks],
[Measures].[Cases])'

 

select NON EMPTY {[Measures].[Partial Cases]} ON COLUMNS,

             NON EMPTY {[YearWeek].[Year].Members} ON ROWS

 

from [SRAG]

 

 

But I’m getting the error: MondrianException: Mondrian Error:No function
matches signature '1(<Member>)'

 

 

My dimension structure:

 

- YearWeek

--- Year

--- Week

 

Thanks in advance.

 

-- 

Kleyson Rios

Gestor de TI

Coordenador de BI / Banco de Dados

Gerência de Tecnologia da Informação

Secretaria de Estado da Saúde de Goiás

(62) 3201-3707

 

Se não pode vencer pelo talento, vença pelo esforço. (Dave Weinbaum)

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140116/7fb445a1/attachment.html 


More information about the Mondrian mailing list