Column Reference - Transformer

[spicysudhi]

hi

the model got 2 dimensions and 2 data sources.
the 2 data sources have a common column which actually links the both. The datasource1 actually used to form both the dimensions and the levels (its a kind of master tables).

dimension1 contains the column from which is common in both data sources.

when i build the cube, its not showing the categories in the dimension2. but if i view in the category viewr, it got the categories as i expect.

i think this is the reference problem for the dimension2 from datasource2.. how to set the reference to that dimension?

thanks,
sudhi

 

[drlex]

Sudhi,
You need to mark the common column as unique so that transformer 'knows' how to relate the data sources. Right click on the level with the common column and select properties.

"Time flies like an arrow, but fruit flies like a banana."