[Mondrian] How to dynamically group multiple range on dimension

Tom Barber tom at analytical-labs.com
Tue Mar 15 20:27:06 EDT 2016


Hi

I'd normally create another "bucket" column in my dimension that is
populated by the value you want 20-29 or whatever. Then just create a 2nd
hierarchy in the schema that uses that column instead of the actual year.

Tom
On 16 Mar 2016 00:15, "Selina Tech" <swucareer99 at gmail.com> wrote:

> Dear All:
>   I have a question on "How to dynamically group multiple range on
> dimension".
>
>  I have a dimension called age_dim and a measure called sum_count which is
> sum of all count.  I have following two MDX query and get same result
> listing all the sum_count for different ages.
>
> SELECT
> NON EMPTY {[Measures].[sum_count]} ON COLUMNS,
> NON EMPTY {[age_dim].[count_hiera].[age].Members } ON ROWS
> FROM [my_cube]
>
>
> SELECT
> NON EMPTY {[Measures].[sum_count]} ON COLUMNS,
> NON EMPTY {
> [age_dim].[count_hiera].[age].&[20] : [age_dim].[count_hiera].[age].&[29],
> [age_dim].[count_hiera].[age].&[30] : [age_dim].[count_hiera].[age].&[39],
> [age_dim].[count_hiera].[age].&[40] : [age_dim].[count_hiera].[age].&[49]
>  } ON ROWS
> FROM [my_cube]
>
> age   sum_count
> 21     40
> 25     15
> 27     25
> 35     30
> 38     20
> 45     20
> 47     10
>
>
> ----------------
> However I like to get table below which the sum_count can be grouped by
> range of age dimension. Any Help would be great!
>
> ------------------
> age   sum_count
> 20-29     80
> 30-39     50
> 40-49     30
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160316/fce37176/attachment.html 


More information about the Mondrian mailing list