[Mondrian] Aggregation tables and AggPattern

[kevin melo]

Thanks

2016-02-24 10:28 GMT-03:00 Matt Campbell <mcampbell at pentaho.com>:

>
> 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> on behalf of kevin melo <
> kevinmelo92 at gmail.com>
> Reply-To: Mondrian list <mondrian at pentaho.org>
> Date: Tuesday, February 23, 2016 at 11:03 AM
>
> To: Mondrian list <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>:
>
>>
>> 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
>>
>>
>
> _______________________________________________
> 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/20160224/b3172418/attachment-0001.html