Hope someone can help an age old issue i have as an end user of Business Objects.
I have built 2 queries that come from 2 different universes. “Universe 1” provides me with all the policy detail and “Universe 2” provides me with all the client detail.
The primary key that are present in both universes is the CLIENT_ID.
To keep it simple, I have the following in my queries:
Qry1 - CLIENT_ID | PREMIUM (built from Univ1)
Qry2 - client_id | Customer Name (built from Univ2)
I then merge the 2 client IDs together, so I can build a table that looks like the following:
Client ID | Customer Name | Premium
However, after merging the client field, and select premium, the customer name is greyed out and vice versa when I select Premium.
I was told (and read in forums) that changing my measures to detail object would resolve the issue. When I do this the items dont grey out, but… when place together I get #DATASYNC.
I have tried various ways to get round this, so far I have tried:
changing the merged client object as detail
changing the Customer Name and Premium to detail
Final I have tried changing all 3 into details.
None of the above work??? What am I doing wrong? Can someone advise a step by tep guide of how to get this to work.
Hi Mark,
we don’t have to create measure objects as detail when merged.
Make sure that you used merged object when using customer name.
Create customer name as detail and associate it with Client ID.
However what do you do if you wish to merge dimensions only? I must apologise as my scenario was a bad example looking back, as the problem I have are reports that are all dimensions not measures.
So 1 table has client id with policy cover detail and the other has client id with address information. all of which are varchar format
Merge Client Id’s and create 2 variables, 1 for customer name and 1 for premium, change the object types to detail and associte them with Merged Client Id.
However, I get get #DATASYNC when creating them as new variables and changing to detail. If this is the correct way, how do you get around the #DATASYNC issue?
No, I have merged the 2 client IDs into one. I cant seem to get a table to show objects from both queries into one table. I was recommended to create a new varialble changing them to detail object but i get #DATASYNC error message.
In Edit report I Have:
Qry1 has client id with policy cover detail and
Qry2 has client id with address information.
When building a report I want
Client ID; Policy Cover ; Address
However
If I select Policy Cover then Address is greyed out
If I select Address then Policy Cover is greyed out
What Ive tried doing and also recommended by post on previous post is creating variables to detail objects. However, if I change the Policy Cover and Address into detail by creating new variables, they wont grey out but get #DATASYNC when adding in 1 table.
Unfortunately thats not what I want.
I want the data to be all in 1 row not 2 rows like your example. What I want is it to look at the following in a report:
Merge Client Id’s and create 2 detail variables.
1 for customer name making the master dimension Client ID from query 1 .
1 for premium master dimension Client ID from query 2.
Display merged dimension and details in report blobk.
(BOB member since 2013-09-09)
(BOB member since 2005-01-06)