Data Sync Error

building reports webintelligence
1

Let me start by saying that I am getting a datasync error while trying to put columns from different tables together. Now I understand datasync errors and that they mean there is some sort of bad join/connection between tables. I don’t believe I have a bad connection.

Here is my goal:


In the picture above, I want to use patient ID as the similar column to compare accounts.officeid with patients.firstname/lastname

Now with that join in place, I feel like there should be no problem. I have tried running as one query and it failed. I tried running as two separate queries (one for each table) and that failed as well. I tried merging the patient ID but still received the error.

My error/attempt:

If anyone could shed some knowledge on this matter it would be much appreciated because I am stumped. Thanks for reading! :slight_smile:
problem2.png
problem1.png

benhuber (BOB member since 2015-05-11)

2

you need to create detail variables / objects of First and Last name and Associate them with Patient ID.

The only caveat is there has to be a one to one relationship with the detail variable and the Patient ID.

Mak 1 :uk: (BOB member since 2005-01-06)

3

This solved my problem, thank you.

I saw similar suggestions here: WEBI returns 'Partial Results' (BOBJ 4.x) - SAP Community but their phrasing made absolutely no sense to me.

benhuber (BOB member since 2015-05-11)