Qvd's from different sources

[Anonymous]

Hi,

I have 3 qvd's namely dim_account, dim_state and fact_lines.

account qvd is coming from sql server and rest of qvds are coming from oracle data base.

I have imported into QVW file made relationship between fact_lines and as well dim_account with correct pk and fk.

But if i pull any dimension column from account and expressions from fact, i haven't seen any data.

If i do list box for dim_account coulms there is data. is there any way to figure out this issue.

Pls help me on this issue

Regards,

Kumar

[martynlloyd]

When you display the data, check if it is right aligned or left aligned.

You may be treating one as a number and the other as text, check for extra spaces etc.

Or export both to Excel and use EXACT() to compare them...

Marty.

[avinashelite]

check with your expressions once and the table links . All the linking keys should be in same format .

Hope this helps you

[Anonymous]

Hi,

In expressions it is populating values, but in dimensions i couldn;t see any data. There is relation proper relationship between fact and dimensions and i have seen in table viewer.

[Anonymous]

I am able to see count date wise, but the problem with account QVD only.

[sudeepkm]

what is the subset ratio of your key field in both dim and fact?

Do you have a screenshot or a scrambled sample that you can share?

[Anonymous]

For fact table it is 0.05% and for dim 99.95%

[Anonymous]

this dim is coming from one source and fact is coming from another source. Is it possible to have two difference in one QVW file.

[sudeepkm]

0.05% is too less not sure how many records. but it seems there are bunch of field values not same across both the tables. unless you have matching or associated values your chart wont display anything.

I'm not saying the chart or expression or data is wrong but I think as per your subset ratio the dim to fact association is weak and not have enough amount of matching record.

[petter]

The key field - the field that connects your two tables - the dimension table and the fact table, will only match rows between the tables if the values match. So check why the values in the dimension don't match the values in the fact table. The fact table should have 100% subset ratio on the key field that goes to the dimension table.

Is it a date or timestamp in either of the source database columns? Maybe you need to do a Floor() to get the exact granularity of a full day...