[Mondrian] Aggregation tables and AggPattern

kevin melo kevinmelo92 at gmail.com
Tue Feb 23 11:03:04 EST 2016


What is that Collapsed attribute?

2016-02-23 12:59 GMT-03:00 Matt Campbell <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> on behalf of kevin melo <
> kevinmelo92 at gmail.com>
> Reply-To: Mondrian list <mondrian at pentaho.org>
> Date: Tuesday, February 23, 2016 at 10:31 AM
>
> To: Mondrian list <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>:
>
>>
>> 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> on behalf of kevin melo <
>> kevinmelo92 at gmail.com>
>> Reply-To: Mondrian list <mondrian at pentaho.org>
>> Date: Tuesday, February 23, 2016 at 9:41 AM
>> To: Mondrian list <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>:
>>
>>>
>>> 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> on behalf of kevin melo <
>>> kevinmelo92 at gmail.com>
>>> Reply-To: Mondrian list <mondrian at pentaho.org>
>>> Date: Tuesday, February 23, 2016 at 8:43 AM
>>> To: Mondrian list <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
>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>>
>>>
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>
> _______________________________________________
> 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/20160223/fab6814e/attachment-0001.html 


More information about the Mondrian mailing list