Combining Universes

[nnaxor]

I have a field in two universes that I need to use to link the two. Problem is that the field in Universe A is 023xxxxx and the field in Universe B is just xxxxx without the 023 lead. We tried creating a variable removing the lead, but the link did not work. Any ideas?


Thanks bunches.

Nnaxor

 

[PAULSGS]

How about creating an extra object in universeB and concatenate the '023' onto the 'xxxxx' then using this new field to link to its counterpart in universeA?

 

[blom0344]

Hello nnaxor,

The suggestion of paulsgs will , I think , not work, since a created object is a virtual one, it does not exist in the tables you have within the universe.

Option one is to not use a linked universe , but use at report-level 2 dataproviders and let BO create the link between the two corresponding dimensions . Of course create first a new object (as a dimension that is either the concatenation - in universe 1 - or a substring - in universe 2) Whatever universe you want to adapt.
BO gives the effect of an outer-join between the datasets.
This option is limited in use though, you can only use dimensions from both datasets in a table that are linked
However I just made a report with 3 queries on AS400 source and 2 queries on ORACLE that use such a linking option.

Option 2 is manually editing the join between the corresponding fields linking the universes, so that values from the 2 columns can be compared:

substr(023xxxxx,4,5) = xxxxx

Can't tell you if this will give a performing join though. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com