Forum Discussion

unobasta's avatar
unobasta
Frequent Visitor
6 years ago

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 years.

So, I need that Year field in Date table would filter also CostCenterList table. Problem is this will create an ambiguity between CostCenterList and the other tables.

 

 Any idea on how to solve this would be much appreciated.

 

Thank you in advance!

Need Help

2 Replies

  • adambhappy's avatar
    adambhappy
    Icon for Resolver II rankResolver II
    6 years ago

    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!