importable/exportable - newbie question

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

importable/exportable - newbie question

ameil
Hello,

  I'm trying to link 2 datasets using the "importable/exportable"
mecanism. I want to display in "dataset 2" attributes
from "dataset 1". Nothing happens when I run martView: the 2 marts act
totally independantly. I think I missed one important step or concept.
Here are the steps I followed :

     1)  create an "exportable" in dataset 1 ("devbiomart"):
         - internalName: "feature_id"
         - linkName: "feature_id"
         - name: "feature_id"
         - attributes: "feature_key"
         - type: "link"

    2)  create an "attribute" in dataset 1:
         - internalName:  "feature_key"
         - displayName:  "feature key"
         - hidden: "false"
         - field:  "feature_id_2045_key"
         - tableConstraint:  "feature_id_2045_key"
         - key:  "feature_id_2045_key"

     3) create an "importable" in dataset 2 ("devbiomart2"):
         - internalName: "feature_id"
         - linkName: "feature_id"
         - name: "feature_id"
         - filters: "value_101"
         - type: "link"

     4) create a "filter" in dataset 2 ("devbiomart2"):
         - internalName:  "value_101"
         - field:  "value_101"
         - tableConstraint:  "ngs_featurelib__dm"
         - key:  "library_id_102_key"
         - qualifier:  ">="

     5) set 2 MartDBLocation in the registry file:
<MartRegistry>
<MartDBLocation
                     name         = "devbiomart"
                     displayName  = "lepido database"
                     databaseType = "postgres"
                     host         = "xxxxxxxxx"
                     port         = "xxxxxxxx"
                     database     = "lepidodb_RNA"
                     schema       = "lepidodb_rna_schema_feature_only_aml_2"
                     user         = "xxxxxxxx"
                     password     = "xxxxxxxx"
                     visible      = "1"
                     default      = ""
                     includeDatasets = ""
                     martUser     = ""
/>
<MartDBLocation
                     name         = "devbiomart2"
                     displayName  = "lepido database - ngs lib"
                     databaseType = "postgres"
                     host         = "xxxxxxxx"
                     port         = "xxxxxxxx"
                     database     = "lepidodb_RNA_ngs_lib_091210"
                     schema       =
"lepidodb_rna_schema_ngs_lib_091210_aml_1"
                     user         = "xxxxxxxxx"
                     password     = "xxxxxxxxx"
                     visible      = "1"
                     default      = ""
                     includeDatasets = ""
                     martUser     = ""
/>
</MartRegistry>

Regards,

Alain.

--
Alain MEIL

Project Leader
Korilog SARL
BP 36, 56190 Muzillac - FRANCE
tel:  +33960368038
mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: importable/exportable - newbie question

nndegwa
Hi Alain,
Looking at the way you have defined the exportable/importable, it
appears fine to me, however one thing that is not clear or could be
worth clarifying is, how you then try to perform a query that links both
datasets i.e. the order. Basically, from what you have described,
dataset 1 should be able to link to dataset 2 if you choose dataset 1 as
the first dataset on your Martview, but the reverse is not true.
So, here is a suggestion to try: If it is possible, define both
importable & exportable on dataset 1 and dataset 2, then try the query
and see what happens.
Cheers,
Nelson

alain meil wrote:

> Hello,
>
>  I'm trying to link 2 datasets using the "importable/exportable"
> mecanism. I want to display in "dataset 2" attributes
> from "dataset 1". Nothing happens when I run martView: the 2 marts act
> totally independantly. I think I missed one important step or concept.
> Here are the steps I followed :
>
>     1)  create an "exportable" in dataset 1 ("devbiomart"):
>         - internalName: "feature_id"
>         - linkName: "feature_id"
>         - name: "feature_id"
>         - attributes: "feature_key"
>         - type: "link"
>
>    2)  create an "attribute" in dataset 1:
>         - internalName:  "feature_key"
>         - displayName:  "feature key"
>         - hidden: "false"
>         - field:  "feature_id_2045_key"
>         - tableConstraint:  "feature_id_2045_key"
>         - key:  "feature_id_2045_key"
>
>     3) create an "importable" in dataset 2 ("devbiomart2"):
>         - internalName: "feature_id"
>         - linkName: "feature_id"
>         - name: "feature_id"
>         - filters: "value_101"
>         - type: "link"
>
>     4) create a "filter" in dataset 2 ("devbiomart2"):
>         - internalName:  "value_101"
>         - field:  "value_101"
>         - tableConstraint:  "ngs_featurelib__dm"
>         - key:  "library_id_102_key"
>         - qualifier:  ">="
>
>     5) set 2 MartDBLocation in the registry file:
> <MartRegistry>
> <MartDBLocation
>                     name         = "devbiomart"
>                     displayName  = "lepido database"
>                     databaseType = "postgres"
>                     host         = "xxxxxxxxx"
>                     port         = "xxxxxxxx"
>                     database     = "lepidodb_RNA"
>                     schema       =
> "lepidodb_rna_schema_feature_only_aml_2"
>                     user         = "xxxxxxxx"
>                     password     = "xxxxxxxx"
>                     visible      = "1"
>                     default      = ""
>                     includeDatasets = ""
>                     martUser     = ""
> />
> <MartDBLocation
>                     name         = "devbiomart2"
>                     displayName  = "lepido database - ngs lib"
>                     databaseType = "postgres"
>                     host         = "xxxxxxxx"
>                     port         = "xxxxxxxx"
>                     database     = "lepidodb_RNA_ngs_lib_091210"
>                     schema       =
> "lepidodb_rna_schema_ngs_lib_091210_aml_1"
>                     user         = "xxxxxxxxx"
>                     password     = "xxxxxxxxx"
>                     visible      = "1"
>                     default      = ""
>                     includeDatasets = ""
>                     martUser     = ""
> />
> </MartRegistry>
>
> Regards,
>
> Alain.
>