Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 27, 2017 at 12:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded