OLAP Advanced custom filters date

1 vote

0 answers

505 views

                          How do i filter, in a Mondrian MDX Query, just the FACTS that have ocurred in a Range of Months over last 3 years?

I need to make it dynamic so i can use parameters latter, so i need the following:

Month Range over last 3 years, Where StartMonth and EndMonth is given by user by parameters.

    .[January],  .[February], .[March]
    .[January],  .[February], .[March]
    .[January],  .[February], .[March]

Time dim have Year, Half Year, Quarter, Month, Week and Day level.

I have tryed this, but i get an error Mondrian Error:Cannot deduce type of set

    WITH set [MesesFiltrados] as 
    DESCENDANTS(
        FILTER(LastPeriods (3,
            StrToMember("[Data].[" || TRIM(Str(Int(YEAR(NOW())))) || "]")
        ),
          [Data].[Mes].currentmember in ([Data].Mes.[${StartMonth}]:[Data].Mes.[${StartMonth}])
      )
    )
      
    Select {[Escritorio]} on columns,
    {
      MesesFiltrados  
    }
    on  rows 
    
    From 
    Desempenho

Tks

                        

Asked by lucassig (41 rep)

Feb 5, 2014, 06:22 PM
Last activity: Feb 6, 2014, 04:25 PM

OLAP Advanced custom filters date

Related Questions