Issue in data model

[sannidhikumar]

Hi All,

PFA.

We have created 2 tables key is comman in 2 tables.(Key is composite key bu using resp fields in table).

But for some fields like

00610|LC|001410|2060

00620|LC|001410|2060

00670|LC|001410|2060

associated values are not showing though values are present in backend db.

Can you please suggest on this.

Thanks

[#2]

In Your scenario i found you joined the both tables and filtered the data properly.

Relative values are getting shown others not shown when you go for selection.

\

[sannidhikumar]

hi ,

umamahesheswara any solution we can get .

thanks

[sannidhikumar]

Hello experts,

There are some problem with Key (On joining between the two tables).

Can you please suggest how shall i go ahead.

How should i join the two tables so that problem might be rectified.

Thanks

[sannidhikumar]

Hi All,

Can you please suggest how should i join the two tables.I am not able to get this.Can you please help me out.

Thanks

[stabben23]

Hi,

in Your example there is no key from table AR_CustomerLedger, se pic.

[avinashelite]

You need share the data set ...requirements your trying to achieve and sample app then we could understand help you in sorting out the same

[stabben23]

It also looks like you have different granularity in the 2 joined tables. This could lead to unexpected values in Your Charts. You need to find the lowest common keys to avoid this.

Maybe you should try to concatenate the tables instead.

[sannidhikumar]

Hi Staffman,

Thanks for the response .

Can you please suggest how would be the sequence of key as per granularity.

Thanks

[stabben23]

Maybe you have find the lowest keys, i dont know. But in Your case it seams that you have one aggregated qvd (

AR_VarianceSummary_Custom.qvd)  and one transaction table (AR_CustomerLedger.qvd). I should not join these, I should concatenate or maybe use a normal association between the tables With "key" as Your Associated key.