Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Mondrian Error:Duplicate table alias 'dim_person' in cube 'Issues'

  1. #1
    Join Date
    Dec 2007
    Posts
    13

    Default Mondrian Error:Duplicate table alias 'dim_person' in cube 'Issues'

    While testing my install of the bugzilla dashboard I ran the following Analysis Report.
    ISSUE CHANGES - Open vs Closed (NET OPEN) with trend line
    And received this from JBoss:
    mondrian.olap.MondrianException: Mondrian Erroruplicate table alias 'dim_person' in cube 'Issues'
    at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:772)
    at mondrian.rolap.RolapCube.validateRelation(RolapCube.java:542)
    at mondrian.rolap.RolapCube.validate(RolapCube.java:493)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:426)
    at mondrian.rolap.RolapSchema.load(RolapSchema.java:324)
    at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:215)
    at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:79)

    Which leads me to believe there is a problem within the meta-data about the table/view.
    Yet it is defined like this from within pentaho-solutions\software-quality\issues.mondrian.xml:

    <Cube name="Issues">
    <Table name="v_fact_issue"/>
    <DimensionUsage name="Person Assignee" source="Person Assignee" foreignKey="DIM_PERSON_ASSIGNEE_ID"/>
    <DimensionUsage name="Person Reporter" source="Person Reporter" foreignKey="DIM_PERSON_REPORTER_ID"/>
    <DimensionUsage name="Time Created" source="Time Created" foreignKey="DIM_TIME_CREATED_ID"/>
    <DimensionUsage name="Time Released" source="Time Released" foreignKey="DIM_TIME_RELEASED_ID"/>
    <DimensionUsage name="Status" source="Status" foreignKey="DIM_STATUS_ID"/>
    <DimensionUsage name="Priority" source="Priority" foreignKey="DIM_PRIORITY_ID"/>
    <DimensionUsage name="Version" source="Version" foreignKey="DIM_VERSION_ID"/>
    <DimensionUsage name="Product" source="Product" foreignKey="DIM_PRODUCT_ID"/>
    <DimensionUsage name="Issue Type" source="Issue Type" foreignKey="DIM_ISSUE_TYPE_ID"/>
    <Measure name="Issues" column="FACT_ISSUE_CHANGE_ID" aggregator="count" formatString="#,###"/>
    <Measure name="Days Since Creation" column="M_DAYS_SINCE_CREATED" aggregator="avg" formatString="#,###"/>
    </Cube>

    There are two references, yet as foreign keys..

    Needing help getting this resolved, it seems to show up in other
    Analysis Reports. I need this for a dog a pony show to the owners, and If I can't get it up and running soon, we are going a different direction.



  2. #2
    Join Date
    Dec 2007
    Posts
    13

    Default

    Ok... GOT iT..
    Seems as if the Bugzilla DashBoard and it's mondrian.xml is old school and needs to be updated.
    There are not uses of Aliases anyplace within.
    So, I did me some reading and did a little dance and guess what.
    I got it working with the latest pentaho...

    I feel good about this now.
    Yet, now I have to go out and learn what a Dimension/Cube is and how the other API's do so I can get this thing working.

    This is not the last that you will hear from me.
    And it's getting interesting.

  3. #3
    Join Date
    May 2008
    Posts
    1

    Post Need help with the Duplicate Alias issue in SQR for Jira

    Hi,

    I have run into the same problem on the install for Jira. Can you pls elaborate on the steps you took & pointers to the dox that you read to sort this issue out?

    Thanx in advance for the help.

    Regards,
    Dilip

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.