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.