universe design question

[former_member539471]

Hello All,

I have 3 tables in my schema....where

Vk table         LPC vparty table               LPC Vparty S table

PV_ id                        LPC V_id                              LPC V_id                    

S_id                            PP_ID                                  R_code

V_id                           B_ID                                      T_nbr

B_id                          PV_id                                     st_dt

                                                                              Lastdate_ts

                                                                                B_id

Vk table -> LPC vparty  join by   PV_ID

LPC vparty table  -> LPC Vparty S  table   join by  LPC V_id

Now i am trying to pull  V_id from VK table and R_code from  LPC vparty S table  it gives me incompatible objects. I need these to objects in my report.

Can anyone help me with a solution...The only way VK table and LPC V party S table can be linked is by  LPC vparty table.

Thanks All.

Regards...

[former_member4998 · Accepted solution]

Hi..Your DF have three tables

Vk table -> LPC vparty  join by   PV_ID

LPC vparty table  -> LPC Vparty S  table   join by  LPC V_id

There is no link b/w and no common objects in these two tables (VK table and LPC vparty S table) so while trying to pull from these tables related field’s into the report getting incompatible objects message.

To avoid this, use different data provider option in the report.

Include VK table related objects in one data provider,  and include LPC vparty S table related objects in one data provider.

If you use any common objects merge both data providers objects and use merged objects in the

report.

[former_member539471 · Accepted solution]

Thanks for response sreenivasulu. But there are no common objects between (VK table and LPC vparty S table) how can i merge based on common dimensions..

Thanks...

[former_member539471 · Accepted solution]

Also is there anyway i can resolve this in Universe?

[Former Member · Accepted solution]

What are the cardinalities of the joins?