Forum Discussion
Ambiguity in date table
Hi all, I have a cost report with actuals and budget that should be filter based on cost center and date. Each cost center is connected to a service and this service can change between ...
It seems like the simplest solution here is to handle it during import.
1) Append the Budget/Actuals so that it becomes one table
2) Add a year column to the fact table
3) Merge the fact table with the cost center list using the year and cost center as columns
4) Add the service column to the fact table
Voila!