Synchronization

[Former Member]

Hi All,

Can any one tell me how to resolve the synchronization?

i have two fact tables which have different dimensions and measures,only date is common.when i try to display all of them in a single report,its creating synchronization instead of joins.As a result of this,i am able to see data only from one fact table but not the two.

Appreciate your help...

Thanks,

Sreelekha

[Former Member · Accepted solution]

Hi Sreelekha,

Create two data providers one for each fact table. Then at the report level you can use the merged dimension concept to

show the data from the two fact tables.

Here you have onle one common column "date" you need to merge on the "date" dimension. Please note that the two dimensions should exactly have the same format.

Regards,

Rohit