Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to create a table that takes dimensions and measures from diffrent tables, for example:
Payment - sum filed wher filed rechiv 0001 from payment table
Expense - pay filed wher filed tipe 0005 from expenses table and so on
The fileds are not in the key table because ther are too many , the key table has the time and the place
I know i need matrix tables for the hedlines
dut how do i :
1.show the hedlines even when ther is no rechiv in thet time or place
2. put all the matrics hedlines in one chart table?
I hope i was clear
thank's
Ester
Your key or link table would need to contain all the possible combinations of the keys to work properly. I prefer to concatenate all my transactions into 1 table. It simplifies my development, runs faster and sometimes uses less RAM. Keep it simple and don't use the link table.
Karl
Thank's but I thought of a different wey because actualy i have lotes of tables in the model