[Mondrian] Aggregation tables and AggPattern

Matt Campbell mcampbell at pentaho.com
Wed Feb 24 08:28:56 EST 2016


A collapsed dimension in an aggregate table will have the set of columns containing level values present in the agg table, rather than the dimension key.  For that you would use a CopyLink instead of the ForeignKeyLink.


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 11:03 AM
To: Mondrian list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Subject: Re: [Mondrian] Aggregation tables and AggPattern

What is that Collapsed attribute?

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

That looks correct, assuming you have key links on your agg table.  If you have the collapsed attribute values you can use <CopyLink>.


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 10:31 AM

To: Mondrian list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Subject: Re: [Mondrian] Aggregation tables and AggPattern

Thanks Matt, i already saw that example and i use him to create the shared dimension.

One lat question, about aggregation tables.

I Have a physical table call 'agg_fat_proc' and i want use him, he have 3 measure and one dimension, then i have to create the MeasureGroup like:
<MeasureGroup table="agg_fat_proc" type="aggregate">
<Measures>
<MeasureRef aggColumn="amount"  name="amount"/>
<MeasureRef aggColumn="price" name="price"/>
<MeasureRef aggColumn="fact_count" name="fact_count"/>
</Measures>
</MeasureGroup>
<DimensionLinks>
<ForeignKeyLink dimension="myDimension" foreignKeyColumn="iddimension"/>
</DimensionLinks>

That's Correct?

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

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



_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian



_______________________________________________
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/20160224/133da3cb/attachment.html 


More information about the Mondrian mailing list