Hi, I’m trying to establish the relationship between General Ledger tables in Navision Attain. The only tables that need relating are the “G_L Budget Entry” and “G_L Entry” tables. There is no Diagrams specified and I would ideally like to get the data from these two tables into a Cube. Thanks
Hi David, both table you mention are fact tables, and they have no “direct” relationship. They share the same dimension like “G/L Account No.”, “Posting Date”, and the “Global Dimensions”. Therefore I see no way to put those 2 tables together into a cube, normally you would have a budget cube, finance cube and rather a “virtual cube” with the difference between planned and realized. Hope this helps. Saludos Nils
Hi Nils, Thanks for your reply. I have managed to get the data from these two tables into a cube via 3 SELECT statements and 2 UNIONs to obtain 3 Measures: Actual, budget and full year Budget. However, the dimension filters affect all rows - especially to filter on time on Actual, budget - which affects FullYear Budget. I can not see a way round this as yet. Again, thanks for you feedback. David
quote:
Originally posted by nilsm
Hi David, both table you mention are fact tables, and they have no “direct” relationship. They share the same dimension like “G/L Account No.”, “Posting Date”, and the “Global Dimensions”. Therefore I see no way to put those 2 tables together into a cube, normally you would have a budget cube, finance cube and rather a “virtual cube” with the difference between planned and realized. Hope this helps. Saludos Nils