on 03-26-2010 6:58 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Service ID and Product ID are derived from the same column of the database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.