However, when we visualise the data, it is limited by the date fields on the budget view, and will not let us see past data on the transactions view. We have created the following explore to join these together:Ĭalendar is used as the base table, and a left outer join is used to join the calendar dates to the other tables. We are trying to join them via the use of a calendar table (which has dates from the past running well into the future, date is the primary key on this table) and a reference table for the nominal codes (the nominal code is primary key on this table). They are both fact tables so do not have a natural primary key, but we have created concatenated primary keys for each. These data sets have 2 items in common, the month in which they relate to needs to be the same, and so does the nominal accounting code. I have some finance data, some of which is actuals from the past until now (as a running total of small transactions) and the other data is budget data which runs from now until the future.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |