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] |
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. > |
Free forum by Nabble | Edit this page |