4 Replies Latest reply: Feb 12, 2014 10:58 PM by Srikanth P RSS

    Always show objective

    Fernando Keuroglian

      Hi, people

       

      I have a problem and i would like to know how recommend you to solve this :

       

      I have a fact table(sales table) that have all the facturation, this fact tables have some key , like Canal, zone and others , now i have  a new requirement and i have to add Objective to this Canal and zone.

      I do it, but my problem is that i can see the future objetive, if i have no facturation ... for example , i cant see the objective of march or april 2014 because in my fact table there is no facturation about these months.


      i create a table that have a relation with the fact table with a composed key.

       

      what change in my model do you recommend and if you have an example would be better!

       

      sorry for my english, hope you can understand me!

       

      thank you a lot

       

      Fernando