Skip to Content
0

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

Jun 22, 2017 at 06:17 PM

27

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gopinath Thangaraj Jun 27, 2017 at 12:38 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded