cancel
Showing results for 
Search instead for 
Did you mean: 

Business object: The report does not show the joined table results

Former Member
0 Kudos

Hi everyone:

I am new to the universe design. The report is pulling the results from two joined tables (A,B) that were created at the same universe. The report only could get the results from table A, not Table B even though I defined the join relationship on the universe design. Some tables were created by the previous person, those are working. I don't think I need to merge the two queries. Can somebody tell me what could cause this problem?

Thanks in advance,

Lili

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Are you working in UDT or IDT, Can you please mention which tool your universe has been created in UDT or IDT.

How you have defined the join based on some id column and what join you done so because you are asking like Table A data is coming Table B is not coming., Can you please give the example this helps me to give some suggestions.

One more thing like can you refresh the table structure either in DB level it can be change or not like column additionally they add or exist column might be delete, please check.

In IDT table refresh can be done in data foundation layer --> by selecting table go to 'Action' --> then select 'Refresh Structure'.

In UDT also same, select the table and refresh the structure there is no layer

Thanks,

Gopinath Thangaraj