[Mondrian] Aggregation tables and AggPattern

Matt Campbell mcampbell at pentaho.com
Tue Feb 23 09:45:58 EST 2016


Yes, you’ll have to create an ‘aggregate’ type MeasureGroup for each agg table you want to use with a cube.

For your dimension usage question, yep, that’s about right, although I don’t think you wrap the shared dimensions in an outer <Dimensions> tag.  You can use the M4 Foodmart schema as an example:  https://github.com/pentaho/mondrian/blob/lagunitas/demo/FoodMart.mondrian.xml


From: <mondrian-bounces at pentaho.org<mailto:mondrian-bounces at pentaho.org>> on behalf of kevin melo <kevinmelo92 at gmail.com<mailto:kevinmelo92 at gmail.com>>
Reply-To: Mondrian list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Date: Tuesday, February 23, 2016 at 9:41 AM
To: Mondrian list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Subject: Re: [Mondrian] Aggregation tables and AggPattern

Hmm i understand.

1. Then i have to create every single agg_table inside my cube as GroupMeasure?

1. And another question, for me to use the 'DimensionUsage' in mondrian 4 i have to create a schema dimension, and then inside my cube i have to reffer this dimension? Something like:
<Schema>
    <Dimension></Dimension>
    <Cube>
        <Dimensions>
            <Dimension source="mydimension"/>
        </Dimensions>

2016-02-23 11:24 GMT-03:00 Matt Campbell <mcampbell at pentaho.com<mailto:mcampbell at pentaho.com>>:

There’s no support for “implicit” recognizing of aggregate tables in Mondrian 4— you do need to explicitly set up your aggregate definitions in your schema.

In M3 the implicit recognizer can be convenient, but it can also be a big source of headaches and complexity since it muddies the waters around which aggregate tables are picked up and why.


From: <mondrian-bounces at pentaho.org<mailto:mondrian-bounces at pentaho.org>> on behalf of kevin melo <kevinmelo92 at gmail.com<mailto:kevinmelo92 at gmail.com>>
Reply-To: Mondrian list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Date: Tuesday, February 23, 2016 at 8:43 AM
To: Mondrian list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Subject: [Mondrian] Aggregation tables and AggPattern

Good day,

I have a question about the mondrian 4.

In Mondrian 3 you can use the 'AggPattern' to get all AggTables without write all theirs attributes in the schema.

But in mondrian 4 how i can do that? I Have to write every single aggregation inside my GroupMeasures?
Or have any way to use the 'AggPattern' in mondrian 4?

I saw the documentation<http://mondrian.pentaho.com/head/documentation/schema.php#Schema_eleme> but it's seeing it is out of date some things.

Can you guys help me?

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto: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/20160223/1031b9ec/attachment.html 


More information about the Mondrian mailing list