Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: help with schema design mondrian 4

  1. #1
    Join Date
    Aug 2017
    Posts
    1

    Red face help with schema design mondrian 4

    Hi, im having some issues with this schema and i cant figure out how to make it work.

    pats(fact table)
    idVersion time sales
    1 20080301 6
    2 20080301 44
    1 20080302 3

    Equipment
    idVersion transmisión(idEquipmentValue) fuel(idEquipmentValue)
    1 33 5
    2 34 6


    EquipmentValues
    idEquipmentValue Value
    33 automatic
    34 manual
    5 diesel
    6 gasoline


    transmision and fuel are attributes from Motor dimension.


    my schema:
    Code:
    <?xml version="1.0" encoding="UTF-8"?><Schema name="Sales" metamodelVersion="4.0">
        <PhysicalSchema>
            <Table name="pats" />
            <Table name="atributosKVPDesnorm" />
        </PhysicalSchema>
        <Cube name="Sales">
            <Dimensions>
                <Dimension name="Motor" table="atributosKVPDesnorm" key="Id">
                    <Attributes>
                        <Attribute name="transmision" keyColumn="transmision"/>
                        <Attribute name='Id' keyColumn='idVersion' visible="false"/>
                    </Attributes>
                </Dimension>            
            </Dimensions>
            <MeasureGroups>
                <MeasureGroup name="Sumas" table="pats">
                    <Measures>
                        <Measure name="Suma Patentamientos" column="patentamientos" aggregator="sum" formatString="#,###.00" />
                    </Measures>
                    <DimensionLinks>
                        <ForeignKeyLink dimension="Motor" foreignKeyColumn="idVersion"/>
                    </DimensionLinks>
                </MeasureGroup>
            </MeasureGroups>
        </Cube>
    </Schema>
    With that, i can get the sum of sale by transmisión id(idEquipmentValues), but i want to use the value write in table EquipmentValues instead of id.
    Last edited by krone; 08-16-2017 at 04:00 PM.

Tags for this Thread

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 - 2017 Pentaho Corporation. All Rights Reserved.