Topic
  • 5 replies
  • Latest Post - ‏2013-03-13T02:37:14Z by CognosSonata
CognosSonata
CognosSonata
10 Posts

Pinned topic Error while transforming Physical Data Model to Cognos Model

‏2013-03-08T06:25:20Z |
Hi everyone,

I have followed this tutorial http://www.ibm.com/developerworks/data/library/techarticle/dm-1107infospheredataarchmodeling1/?ca=drs- . At chapter "Transform the dimensional physical data model to Cubing/Cognos model", when I click run to generate Cognos Model, IDA throwed this message:

Transformation execution status.
org.eclipse.emf.common.util.BasicEList$BasicIndexOutOfBoundsException: index=0, size=0
index=0, size=0
Transform context stack
index=0, size=0
Transform Dimensional-Physical Data Model to Cognos/Cubing Model: Element "MDM Relationship Rule" was executing source "org.eclipse.datatools.modelbase.sql.schema.impl.SchemaImpl@3d173d17 (name: RETAIL_SALES) (description: RETAIL_SALES, label: RETAIL_SALES)"

Please help me to fix this issue.
Thank you.
Updated on 2013-03-13T02:37:14Z at 2013-03-13T02:37:14Z by CognosSonata
  • dtc
    dtc
    63 Posts

    Re: Error while transforming Physical Data Model to Cognos Model

    ‏2013-03-08T16:06:30Z  
    Please attach the physical data model so that we can take a look.
  • CognosSonata
    CognosSonata
    10 Posts

    Re: Error while transforming Physical Data Model to Cognos Model

    ‏2013-03-11T02:01:45Z  
    • dtc
    • ‏2013-03-08T16:06:30Z
    Please attach the physical data model so that we can take a look.
    Hi DTC,

    Thanks for your reply. The project folder is attached. My physical model is named RETAIL_SALES.dbm. Hope this help.

    Regards,
    Khoa
  • CognosSonata
    CognosSonata
    10 Posts

    Re: Error while transforming Physical Data Model to Cognos Model

    ‏2013-03-12T01:14:06Z  
    Hi DTC,

    Thanks for your reply. The project folder is attached. My physical model is named RETAIL_SALES.dbm. Hope this help.

    Regards,
    Khoa
    sorry, this is my dbm file
  • dtc
    dtc
    63 Posts

    Re: Error while transforming Physical Data Model to Cognos Model

    ‏2013-03-12T16:39:09Z  
    sorry, this is my dbm file
    There are 16 errors in the model when 'Analyze Model' is applied on the model. Please fix the errors and re-run the transformation. The transformation is designed to work with valid source models.
  • CognosSonata
    CognosSonata
    10 Posts

    Re: Error while transforming Physical Data Model to Cognos Model

    ‏2013-03-13T02:37:14Z  
    • dtc
    • ‏2013-03-12T16:39:09Z
    There are 16 errors in the model when 'Analyze Model' is applied on the model. Please fix the errors and re-run the transformation. The transformation is designed to work with valid source models.
    Hi, DTC

    Thanks for your help. The problem is now solved.

    Best Regards.