transactional iqd-ugt

[sap]

Hi All
i need help from you guys,
how can we create transactional and structural data sources(iqd) to build cube,
to create above data sources do we need establish joins(star schema) in FM as per design
or just import all tables and create iqd for each table
if no need to establish joins in FM then how to link them in transformer to build cube
is any document on this available

thanks to all

cheers
sap

[Darek]

Joins in FM are not going to help you, unless you bring all your data, transactional and dimensional in one query. However, I get the impression that's not what you want.

So you need to export the IQDs for each type separately and only make sure, that the column names match between dimensional and transactional data sources.

Cheers.

[sap]

Hi darek
thanks for reply,
i have 15 dimension  table and 1 fact table which i imported in FM, from each dim i am creting an iqd with common key-is this method is correct
i want know that i need take all common keys in fact iqd in order to get scope for all dim
can you please tell me in detail.
i need to join them in Transformer how can we achieve this.

thanks a lot

cheers
sap

[anoop_ind2]

you dont need to establish the link in transformer.. the keys should be named the same in the fact as well as the dimension and transformer performs the join by itself....

[cognostechie]

Hmm.. let's say you have this Dimension table that you bring into Transformer as a data source from an iqd:

Fields -> Item-No, Item-Name, UOM, Re-order Level.

and now you have this Fact table as a data source that is also from an iqd:

Fields -> Item, Quantity, Revenue

So to join both of them you just rename the 'Item' in the Fact to 'Item-No'. Right click on the field in Transformer, choose Properties and change the Column name.

Transformer will detect that the dimension and fact table have a common key with the same name and automatically join them.