cancel
Showing results for 
Search instead for 
Did you mean: 

Synchronization

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Service ID and Product ID are derived from the same column of the database.

Former Member
0 Kudos

Hi Rohit,

Thanks for ur response...

Can you plz elaborate it.

i shall give you an example

Below are the two fact tables:

TableA TableB

ServiceID ProductID

ServiceName ProductName

Date Date

ServiceTenure ProductQuality

ServiceUnit

below is my single dimension table:

TableC

ID

ID Name

Suppose i want to see the details of ServiceName,ServiceTenure,ProductName,ProductQuality and Date,i can see that data in two rows in a single report.But if i include one more dimension ServiceUnit then its just displaying either Service data or Product data but not both.On editing the SQL query i can see it as synchronization.

Thanks,

Sreelekha

Former Member
0 Kudos

Hi,

what is the report type ...

if it is a deski report then go to data manager -> lef side you will get all the data providers -> expand one data provider -> click on common dimension i.e. date on 1st data provider -> on right side you will get link to button ->click on it and link it to 2nd data provider (data type of common dimension must be same).

if it is a webi report use merge dimension concept.

Cheers,

Suresh Aluri.

former_member793810
Active Contributor
0 Kudos

Is Service ID in Table A is same as Product ID in Table B.

One field should be common in both tables in order to use merge dimension feature.

You also say that Data is common then where is date in Table B.

As Rohit said that you will have to create two data providers and two queries when you run the report you can click on merge dimension button to merge them by choosing common filed from both queries.

Regards,

Bashir Awan

Former Member
0 Kudos

You did not mention the pupose of table C..?

Does the Id column of table C is being used to derive the Product Id and Service Id?

if i include one more dimension ServiceUnit then its just displaying either Service data or Product data but not both.On editing the SQL query i can see it as synchronization.

Can you explain this..?

In response to my previous quote:

Create DP1- ServiceName, ServiceTenure and Date

Add DP2 - ProductName, ProductQuality and Date

Now run the two queries.

At the report level you need to merge the two Date objects, to show the columns in the single block from the two BO queries (Data Provider).

Regards,

Rohit