Linking 2 different tables

[Benouche]

I have two different tables, from which I want to extract my datas for reporting.

The date field has the same format in the 2 tables. But the datas to proceed are different.

My report should contain information from the two tables.
As I am very beginner(...), I cannot find how to proceed.

I tried to link the date field .. but didn't work !

Any hint is warmly welcome !!!

 

[blom0344]

Hello Benouche,

From your description it is not clear if you are working on a universe/database or directly on flatfiles/spreadsheets.

In the first case the relationship between the two tables has to be defined in the corresponding universe. In the other case you should have 2 dataproviders , one for each file. The objects you want to link should be defined as dimensions in order to link them. BO usually links dimensions automatically if the names of the objects are exactly the same. If this is not the case, you can link them manually : DATA --> VIEW DATA --> definition tab of DATA MANAGER --> 'link to' option.

Be sure about the join between the 2 tables, it sounds fairly strange to join two tables over a date field (but not impossible, though) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com