Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: [Mondrian] Default Aggregate Recognizer fails when 2 dimensions aremapped from same table in a schema

  1. #1
    Venkatesh U Guest

    Default [Mondrian] Default Aggregate Recognizer fails when 2 dimensions aremapped from same table in a schema

    Hi all,
    I have a scenario where i have to use 2 columns from the same dimension
    table as 2 different dimensions, I have used the same foreign key to define
    both the dimensions. Though this approach works fine with the Cube fact
    table, when it comes to aggregates,Mondrian recognizes only one dimension
    out of the both. is this a bug or is this case not supported? Please
    clarify.

    Thanks,
    Venkatesh

    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  2. #2
    Julian Hyde Guest

    Default RE: [Mondrian] Default Aggregate Recognizer fails when 2 dimensionsare mapped from same table in a schema

    Can you please log a feature request? Since aggregate tables are mapped at
    the logical level (i.e. columns in the agg table correspond to levels in a
    dimension), it's not clear that there is a simple mapping if two dimensions
    share the same dimension table. But it's definitely a reasonable thing to
    want.

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Venkatesh U
    Sent: Tuesday, March 29, 2011 10:56 PM
    To: Mondrian developer mailing list
    Subject: [Mondrian] Default Aggregate Recognizer fails when 2 dimensions are
    mapped from same table in a schema


    Hi all,
    I have a scenario where i have to use 2 columns from the same dimension
    table as 2 different dimensions, I have used the same foreign key to define
    both the dimensions. Though this approach works fine with the Cube fact
    table, when it comes to aggregates,Mondrian recognizes only one dimension
    out of the both. is this a bug or is this case not supported? Please
    clarify.

    Thanks,
    Venkatesh


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  3. #3
    Joe Barnett Guest

    Default Re: [Mondrian] Default Aggregate Recognizer fails when 2 dimensionsare mapped from same table in a schema

    I believe we've gotten this to work by aliasing the different usages
    of the table, and building the aggregate table and column names based
    on the aliases.

    So we have, for example, N dimensions built off a single table, where
    the schema looks like (we use StringTemplate to parameterize the
    schema, so $it$ gets expanded into each of the N dimensions,
    essentially):
    <Dimension name="Dim_$it$">
    <Hierarchy allMemberName="All Dim_$it$">
    <Table name="dim_table" alias="dim_table_$it$">
    <SQL>dim_key="$it$"</SQL>
    </Table>
    <Level name="level_name" ... />
    </Hierarchy>
    <Dimension>

    and then have aggtables named agg_c_dim$it$_fact, with a column
    "dim_$it$_level_name".

    -Joe

    (Somewhat related is MONDRIAN-812, but that's cause we're using a
    KeyExpression w/in the level, and appears to be fixed in latest trunk)


    On Wed, Mar 30, 2011 at 9:33 AM, Julian Hyde <jhyde (AT) pentaho (DOT) com> wrote:[color=blue]
    > Can you please log a feature request? Since aggregate tables are mapped at
    > the logical level (i.e. columns in the agg table correspond to levels in a
    > dimension), it's not clear that there is a simple mapping if two dimensions
    > share the same dimension table. But it's definitely a reasonable thing to
    > want.
    >
    > Julian
    >
    > ________________________________
    > From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    > Behalf Of Venkatesh U
    > Sent: Tuesday, March 29, 2011 10:56 PM
    > To: Mondrian developer mailing list
    > Subject: [Mondrian] Default Aggregate Recognizer fails when 2 dimensions are
    > mapped from same table in a schema
    >
    > Hi all,
    >

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.